eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OTA_BOOKING_DEALS_V

Source

View Text - Preformatted


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 , CAT.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 , OTA_CATEGORY_USAGES_TL CAT 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') AND CAT.CATEGORY_USAGE_ID(+) = TBD.CATEGORY AND CAT.LANGUAGE(+)= USERENV('LANG')

View Text - HTML Formatted

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
, CAT.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
, OTA_CATEGORY_USAGES_TL CAT
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')
AND CAT.CATEGORY_USAGE_ID(+) = TBD.CATEGORY
AND CAT.LANGUAGE(+)= USERENV('LANG')