Skip to Main Content

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Same views with different names

User_OLCAWJan 24 2022

Just wonder why there are multiple views (records) with the same SQL query, just different names. Example:
PSXLATFIELD_VW, PTAFXLAT_SRCH and EOCF_XLATTAB_VW all delivered by PPSOFT with the identical SQL:
SELECT DISTINCT FIELDNAME FROM PSXLATITEM
My understanding is we are supposed to reuse existing record (view), not keep creating identical one. Any explanation?

Comments
Post Details
Added on Jan 24 2022
1 comment
354 views