VIEW: APPS.OTA_RESOURCE_BOOKINGS_V

Source

View Text - Preformatted

SELECT TRB.ROWID , TSR.BUSINESS_GROUP_ID , TRB.RESOURCE_BOOKING_ID , TRB.SUPPLIED_RESOURCE_ID , TSR.RESOURCE_DEFINITION_ID , TSR.VENDOR_ID , VEN.VENDOR_NAME , TSR.RESOURCE_TYPE , RT_LOOK.MEANING , SRT.NAME , TSR.CONSUMABLE_FLAG , TSR.CURRENCY_CODE , TSR.COST , TSR.COST_UNIT , TRB.EVENT_ID , ENT.TITLE , EVT.COURSE_START_DATE , EVT.COURSE_END_DATE , EVT.COURSE_START_TIME , EVT.COURSE_END_TIME , EVT.CURRENCY_CODE , EVT.CENTRE , hr_general.decode_fnd_comm_lookup( 'TRAINING_CENTRE', EVT.CENTRE) , TAV.ACTIVITY_VERSION_ID , TAV.VERSION_NAME , TRB.DATE_BOOKING_PLACED , TRB.OBJECT_VERSION_NUMBER , TRB.STATUS , BS_LOOK.MEANING , TRB.ABSOLUTE_PRICE , TRB.BOOKING_PERSON_ID , FND.USER_NAME , TRB.COMMENTS , TRB.CONTACT_NAME , TRB.CONTACT_PHONE_NUMBER , TRB.DELEGATES_PER_UNIT , TRB.QUANTITY , TRB.REQUIRED_DATE_FROM , TRB.REQUIRED_DATE_TO , TRB.REQUIRED_END_TIME , TRB.REQUIRED_START_TIME , TRB.DELIVER_TO , TRB.PRIMARY_VENUE_FLAG , TRB.ROLE_TO_PLAY , hr_general.decode_fnd_comm_lookup('TRAINER_PARTICIPATION', TRB.ROLE_TO_PLAY ) , TRB.LAST_UPDATE_DATE , TRB.LAST_UPDATED_BY , TRB.LAST_UPDATE_LOGIN , TRB.CREATED_BY , TRB.CREATION_DATE , TRB.TRB_INFORMATION_CATEGORY , TRB.TRB_INFORMATION1 , TRB.TRB_INFORMATION2 , TRB.TRB_INFORMATION3 , TRB.TRB_INFORMATION4 , TRB.TRB_INFORMATION5 , TRB.TRB_INFORMATION6 , TRB.TRB_INFORMATION7 , TRB.TRB_INFORMATION8 , TRB.TRB_INFORMATION9 , TRB.TRB_INFORMATION10 , TRB.TRB_INFORMATION11 , TRB.TRB_INFORMATION12 , TRB.TRB_INFORMATION13 , TRB.TRB_INFORMATION14 , TRB.TRB_INFORMATION15 , TRB.TRB_INFORMATION16 , TRB.TRB_INFORMATION17 , TRB.TRB_INFORMATION18 , TRB.TRB_INFORMATION19 , TRB.TRB_INFORMATION20 , TFL.CURRENCY_CODE , TFL.MONEY_AMOUNT , TFL.FINANCE_HEADER_ID , TFL.FINANCE_LINE_ID , TFL.TRANSFER_STATUS , TFL.OBJECT_VERSION_NUMBER ,EVT.TRAINING_CENTER_ID ,EVT.LOCATION_ID ,OFF.LANGUAGE_CODE ,TSR.TRAINING_CENTER_ID ,TSR.LOCATION_ID ,TSR.TRAINER_ID ,TRB.DISPLAY_TO_LEARNER_FLAG ,TRB.BOOK_ENTIRE_PERIOD_FLAG ,TRB.FORUM_ID ,TRB.CHAT_ID ,TRB.TIMEZONE_CODE FROM OTA_RESOURCE_BOOKINGS TRB , OTA_EVENTS EVT , OTA_EVENTS_TL ENT , OTA_ACTIVITY_VERSIONS_TL TAV , OTA_SUPPLIABLE_RESOURCES TSR , OTA_SUPPLIABLE_RESOURCES_TL SRT , PO_VENDORS VEN , FND_USER FND , HR_LOOKUPS RT_LOOK , HR_LOOKUPS BS_LOOK , OTA_FINANCE_LINES TFL , OTA_OFFERINGS OFF WHERE RT_LOOK.LOOKUP_TYPE = 'RESOURCE_TYPE' AND RT_LOOK.LOOKUP_CODE = TSR.RESOURCE_TYPE AND BS_LOOK.LOOKUP_TYPE = 'RESOURCE_BOOKING_STATUS' AND BS_LOOK.LOOKUP_CODE = TRB.STATUS AND VEN.VENDOR_ID(+) = TSR.VENDOR_ID AND EVT.EVENT_ID (+) = TRB.EVENT_ID AND ENT.EVENT_ID(+) = EVT.EVENT_ID AND ENT.LANGUAGE(+) = USERENV('LANG') AND TAV.ACTIVITY_VERSION_ID (+) = EVT.ACTIVITY_VERSION_ID AND TAV.LANGUAGE (+) = USERENV('LANG') AND TSR.SUPPLIED_RESOURCE_ID = TRB.SUPPLIED_RESOURCE_ID AND SRT.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID AND SRT.LANGUAGE = USERENV('LANG') AND FND.USER_ID (+) = TRB.BOOKING_PERSON_ID AND TRB.RESOURCE_BOOKING_ID = TFL.RESOURCE_BOOKING_ID (+) AND TFL.CANCELLED_FLAG (+) = 'N' AND evt.parent_offering_id = off.offering_id(+)

View Text - HTML Formatted

SELECT TRB.ROWID
, TSR.BUSINESS_GROUP_ID
, TRB.RESOURCE_BOOKING_ID
, TRB.SUPPLIED_RESOURCE_ID
, TSR.RESOURCE_DEFINITION_ID
, TSR.VENDOR_ID
, VEN.VENDOR_NAME
, TSR.RESOURCE_TYPE
, RT_LOOK.MEANING
, SRT.NAME
, TSR.CONSUMABLE_FLAG
, TSR.CURRENCY_CODE
, TSR.COST
, TSR.COST_UNIT
, TRB.EVENT_ID
, ENT.TITLE
, EVT.COURSE_START_DATE
, EVT.COURSE_END_DATE
, EVT.COURSE_START_TIME
, EVT.COURSE_END_TIME
, EVT.CURRENCY_CODE
, EVT.CENTRE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP( 'TRAINING_CENTRE'
, EVT.CENTRE)
, TAV.ACTIVITY_VERSION_ID
, TAV.VERSION_NAME
, TRB.DATE_BOOKING_PLACED
, TRB.OBJECT_VERSION_NUMBER
, TRB.STATUS
, BS_LOOK.MEANING
, TRB.ABSOLUTE_PRICE
, TRB.BOOKING_PERSON_ID
, FND.USER_NAME
, TRB.COMMENTS
, TRB.CONTACT_NAME
, TRB.CONTACT_PHONE_NUMBER
, TRB.DELEGATES_PER_UNIT
, TRB.QUANTITY
, TRB.REQUIRED_DATE_FROM
, TRB.REQUIRED_DATE_TO
, TRB.REQUIRED_END_TIME
, TRB.REQUIRED_START_TIME
, TRB.DELIVER_TO
, TRB.PRIMARY_VENUE_FLAG
, TRB.ROLE_TO_PLAY
, HR_GENERAL.DECODE_FND_COMM_LOOKUP('TRAINER_PARTICIPATION'
, TRB.ROLE_TO_PLAY )
, TRB.LAST_UPDATE_DATE
, TRB.LAST_UPDATED_BY
, TRB.LAST_UPDATE_LOGIN
, TRB.CREATED_BY
, TRB.CREATION_DATE
, TRB.TRB_INFORMATION_CATEGORY
, TRB.TRB_INFORMATION1
, TRB.TRB_INFORMATION2
, TRB.TRB_INFORMATION3
, TRB.TRB_INFORMATION4
, TRB.TRB_INFORMATION5
, TRB.TRB_INFORMATION6
, TRB.TRB_INFORMATION7
, TRB.TRB_INFORMATION8
, TRB.TRB_INFORMATION9
, TRB.TRB_INFORMATION10
, TRB.TRB_INFORMATION11
, TRB.TRB_INFORMATION12
, TRB.TRB_INFORMATION13
, TRB.TRB_INFORMATION14
, TRB.TRB_INFORMATION15
, TRB.TRB_INFORMATION16
, TRB.TRB_INFORMATION17
, TRB.TRB_INFORMATION18
, TRB.TRB_INFORMATION19
, TRB.TRB_INFORMATION20
, TFL.CURRENCY_CODE
, TFL.MONEY_AMOUNT
, TFL.FINANCE_HEADER_ID
, TFL.FINANCE_LINE_ID
, TFL.TRANSFER_STATUS
, TFL.OBJECT_VERSION_NUMBER
, EVT.TRAINING_CENTER_ID
, EVT.LOCATION_ID
, OFF.LANGUAGE_CODE
, TSR.TRAINING_CENTER_ID
, TSR.LOCATION_ID
, TSR.TRAINER_ID
, TRB.DISPLAY_TO_LEARNER_FLAG
, TRB.BOOK_ENTIRE_PERIOD_FLAG
, TRB.FORUM_ID
, TRB.CHAT_ID
, TRB.TIMEZONE_CODE
FROM OTA_RESOURCE_BOOKINGS TRB
, OTA_EVENTS EVT
, OTA_EVENTS_TL ENT
, OTA_ACTIVITY_VERSIONS_TL TAV
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL SRT
, PO_VENDORS VEN
, FND_USER FND
, HR_LOOKUPS RT_LOOK
, HR_LOOKUPS BS_LOOK
, OTA_FINANCE_LINES TFL
, OTA_OFFERINGS OFF
WHERE RT_LOOK.LOOKUP_TYPE = 'RESOURCE_TYPE'
AND RT_LOOK.LOOKUP_CODE = TSR.RESOURCE_TYPE
AND BS_LOOK.LOOKUP_TYPE = 'RESOURCE_BOOKING_STATUS'
AND BS_LOOK.LOOKUP_CODE = TRB.STATUS
AND VEN.VENDOR_ID(+) = TSR.VENDOR_ID
AND EVT.EVENT_ID (+) = TRB.EVENT_ID
AND ENT.EVENT_ID(+) = EVT.EVENT_ID
AND ENT.LANGUAGE(+) = USERENV('LANG')
AND TAV.ACTIVITY_VERSION_ID (+) = EVT.ACTIVITY_VERSION_ID
AND TAV.LANGUAGE (+) = USERENV('LANG')
AND TSR.SUPPLIED_RESOURCE_ID = TRB.SUPPLIED_RESOURCE_ID
AND SRT.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID
AND SRT.LANGUAGE = USERENV('LANG')
AND FND.USER_ID (+) = TRB.BOOKING_PERSON_ID
AND TRB.RESOURCE_BOOKING_ID = TFL.RESOURCE_BOOKING_ID (+)
AND TFL.CANCELLED_FLAG (+) = 'N'
AND EVT.PARENT_OFFERING_ID = OFF.OFFERING_ID(+)