Product: | OTA - Learning Management |
---|---|
Description: | View to list all resource bookings. |
Implementation/DBA Data: | APPS.OTA_RESOURCE_BOOKINGS_V |
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
, EVT.LANGUAGE_ID
, 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
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
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'