Product: | OTA - Learning Management |
---|---|
Description: | View to list all information about an Enrollment Agreement. |
Implementation/DBA Data: | APPS.OTA_BOOKING_DEALS_V |
SELECT TBD.ROWID
, TBD.BOOKING_DEAL_ID
, TBD.OBJECT_VERSION_NUMBER
, TBD.BUSINESS_GROUP_ID
, TBD.NAME
, TBD.CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUS_NAME
, TBD.APPROVED_BY_PERSON_ID
, USR.USER_NAME PPF_FULL_NAME
, TBD.TYPE
, HR_GENERAL.DECODE_LOOKUP('BOOKING_DEAL_TYPE'
, TBD.TYPE) TBD_TYPE_MEANING
, TBD.PRICE_LIST_ID
, TPL.NAME TPL_NAME
, TPL.PRICE_LIST_TYPE TPL_TYPE
, HR_GENERAL.DECODE_LOOKUP('PRICE_LIST_TYPE'
, TPL.PRICE_LIST_TYPE) TPL_TYPE_MEANING
, HR_GENERAL.DECODE_LOOKUP('TRAINING_UNIT'
, TPL.TRAINING_UNIT_TYPE) TPL_UNIT
, TPL.SINGLE_UNIT_PRICE TPL_UNIT_PRICE
, TBD.EVENT_ID
, ENT.TITLE EVT_TITLE
, TBD.ACTIVITY_VERSION_ID
, TAV.VERSION_NAME TAV_NAME
, TBD.CATEGORY
, HR_GENERAL.DECODE_LOOKUP('ACTIVITY_CATEGORY'
, TBD.CATEGORY) CAT_NAME
, TBD.START_DATE
, TBD.END_DATE
, NVL (TPL.CURRENCY_CODE
, EVT.CURRENCY_CODE) CURRENCY_CODE
, TBD.DISCOUNT_PERCENTAGE
, TBD.NUMBER_OF_PLACES
, TBD.LIMIT_EACH_EVENT_FLAG
, TBD.OVERDRAFT_LIMIT
, TBD.DESCRIPTION
, DECODE(TBD.TYPE
, 'P'
, OTA_TBD_API.TFL_PURCHASED (TBD.BOOKING_DEAL_ID
, TPL.PRICE_LIST_TYPE)) TFL_PURCHASED
, DECODE(TBD.TYPE
, 'P'
, OTA_TBD_API.TFL_BALANCE (TBD.BOOKING_DEAL_ID
, TPL.PRICE_LIST_TYPE)) TFL_BALANCE
, OTA_TBD_API.TFL_FLAG (TBD.BOOKING_DEAL_ID) TFL_FLAG
, TBD.COMMENTS
, TBD.TBD_INFORMATION_CATEGORY
, TBD.TBD_INFORMATION1
, TBD.TBD_INFORMATION2
, TBD.TBD_INFORMATION3
, TBD.TBD_INFORMATION4
, TBD.TBD_INFORMATION5
, TBD.TBD_INFORMATION6
, TBD.TBD_INFORMATION7
, TBD.TBD_INFORMATION8
, TBD.TBD_INFORMATION9
, TBD.TBD_INFORMATION10
, TBD.TBD_INFORMATION11
, TBD.TBD_INFORMATION12
, TBD.TBD_INFORMATION13
, TBD.TBD_INFORMATION14
, TBD.TBD_INFORMATION15
, TBD.TBD_INFORMATION16
, TBD.TBD_INFORMATION17
, TBD.TBD_INFORMATION18
, TBD.TBD_INFORMATION19
, TBD.TBD_INFORMATION20
, TBD.CREATED_BY
, TBD.CREATION_DATE
, TBD.LAST_UPDATE_LOGIN
, TBD.LAST_UPDATED_BY
, TBD.LAST_UPDATE_DATE
FROM OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, OTA_PRICE_LISTS TPL
, FND_USER USR
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS ACCT
, OTA_BOOKING_DEALS TBD
WHERE ACCT.CUST_ACCOUNT_ID(+) = TBD.CUSTOMER_ID
AND ACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND USR.USER_ID (+) = TBD.APPROVED_BY_PERSON_ID
AND TPL.PRICE_LIST_ID (+) = TBD.PRICE_LIST_ID
AND EVT.EVENT_ID (+) = TBD.EVENT_ID
AND ENT.EVENT_ID (+) = EVT.EVENT_ID
AND ENT.LANGUAGE (+) = USERENV('LANG')
AND TAV.ACTIVITY_VERSION_ID (+) = TBD.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE(+)= USERENV('LANG')