View: OTA_PRICE_LIST_ENTRIES_V

Product:	OTA - Learning Management
Description:	View to list all enteries in a Price List.
Implementation/DBA Data:	APPS.OTA_PRICE_LIST_ENTRIES_V

View Text

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')

Columns