VIEW: APPS.OTA_PRICE_LIST_ENTRIES_V

Source

View Text - Preformatted

SELECT PLE.ROWID ROW_ID , TAD.BUSINESS_GROUP_ID , PLE.PRICE_LIST_ENTRY_ID , PLE.PRICE_LIST_ID , TPL.NAME PRICE_LIST_NAME , TPL.START_DATE PRICE_LIST_START_DATE , TPL.END_DATE PRICE_LIST_END_DATE , PLE.VENDOR_SUPPLY_ID , TAV.VENDOR_ID , VENDORS.VENDOR_NAME , TAV.ACTIVITY_VERSION_ID , AVT.VERSION_NAME ACTIVITY_VERSION_NAME , TAD.ACTIVITY_ID , ADT.NAME ACTIVITY_NAME , PLE.START_DATE , PLE.END_DATE , PLE.PRICE , PLE.PRICE_BASIS , HR_GENERAL.DECODE_LOOKUP('EVENT_PRICE_BASIS',PLE.PRICE_BASIS) PRICE_BASIS_MEANING , PLE.MAXIMUM_ATTENDEES , PLE.MINIMUM_ATTENDEES , PLE.COMMENTS , PLE_INFORMATION_CATEGORY , PLE_INFORMATION1 , PLE_INFORMATION2 , PLE_INFORMATION3 , PLE_INFORMATION4 , PLE_INFORMATION5 , PLE_INFORMATION6 , PLE_INFORMATION7 , PLE_INFORMATION8 , PLE_INFORMATION9 , PLE_INFORMATION10 , PLE_INFORMATION11 , PLE_INFORMATION12 , PLE_INFORMATION13 , PLE_INFORMATION14 , PLE_INFORMATION15 , PLE_INFORMATION16 , PLE_INFORMATION17 , PLE_INFORMATION18 , PLE_INFORMATION19 , PLE_INFORMATION20 , PLE.OBJECT_VERSION_NUMBER , PLE.LAST_UPDATE_DATE , PLE.LAST_UPDATED_BY , PLE.LAST_UPDATE_LOGIN , PLE.CREATED_BY , PLE.CREATION_DATE FROM PO_VENDORS VENDORS , OTA_ACTIVITY_DEFINITIONS TAD , OTA_ACTIVITY_DEFINITIONS_TL ADT , OTA_ACTIVITY_VERSIONS TAV , OTA_ACTIVITY_VERSIONS_TL AVT , OTA_PRICE_LISTS TPL , OTA_PRICE_LIST_ENTRIES PLE WHERE VENDORS.VENDOR_ID(+) = TAV.VENDOR_ID AND TPL.PRICE_LIST_ID = PLE.PRICE_LIST_ID AND TAD.ACTIVITY_ID = TAV.ACTIVITY_ID AND ADT.ACTIVITY_ID = TAD.ACTIVITY_ID AND ADT.LANGUAGE = USERENV('LANG') AND TAV.ACTIVITY_VERSION_ID = PLE.ACTIVITY_VERSION_ID AND AVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID AND AVT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT PLE.ROWID ROW_ID
, TAD.BUSINESS_GROUP_ID
, PLE.PRICE_LIST_ENTRY_ID
, PLE.PRICE_LIST_ID
, TPL.NAME PRICE_LIST_NAME
, TPL.START_DATE PRICE_LIST_START_DATE
, TPL.END_DATE PRICE_LIST_END_DATE
, PLE.VENDOR_SUPPLY_ID
, TAV.VENDOR_ID
, VENDORS.VENDOR_NAME
, TAV.ACTIVITY_VERSION_ID
, AVT.VERSION_NAME ACTIVITY_VERSION_NAME
, TAD.ACTIVITY_ID
, ADT.NAME ACTIVITY_NAME
, PLE.START_DATE
, PLE.END_DATE
, PLE.PRICE
, PLE.PRICE_BASIS
, HR_GENERAL.DECODE_LOOKUP('EVENT_PRICE_BASIS'
, PLE.PRICE_BASIS) PRICE_BASIS_MEANING
, PLE.MAXIMUM_ATTENDEES
, PLE.MINIMUM_ATTENDEES
, PLE.COMMENTS
, PLE_INFORMATION_CATEGORY
, PLE_INFORMATION1
, PLE_INFORMATION2
, PLE_INFORMATION3
, PLE_INFORMATION4
, PLE_INFORMATION5
, PLE_INFORMATION6
, PLE_INFORMATION7
, PLE_INFORMATION8
, PLE_INFORMATION9
, PLE_INFORMATION10
, PLE_INFORMATION11
, PLE_INFORMATION12
, PLE_INFORMATION13
, PLE_INFORMATION14
, PLE_INFORMATION15
, PLE_INFORMATION16
, PLE_INFORMATION17
, PLE_INFORMATION18
, PLE_INFORMATION19
, PLE_INFORMATION20
, PLE.OBJECT_VERSION_NUMBER
, PLE.LAST_UPDATE_DATE
, PLE.LAST_UPDATED_BY
, PLE.LAST_UPDATE_LOGIN
, PLE.CREATED_BY
, PLE.CREATION_DATE
FROM PO_VENDORS VENDORS
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL ADT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
, OTA_PRICE_LISTS TPL
, OTA_PRICE_LIST_ENTRIES PLE
WHERE VENDORS.VENDOR_ID(+) = TAV.VENDOR_ID
AND TPL.PRICE_LIST_ID = PLE.PRICE_LIST_ID
AND TAD.ACTIVITY_ID = TAV.ACTIVITY_ID
AND ADT.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ADT.LANGUAGE = USERENV('LANG')
AND TAV.ACTIVITY_VERSION_ID = PLE.ACTIVITY_VERSION_ID
AND AVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE = USERENV('LANG')