View: OTFV_TRAINING_AMOUNT

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_TRAINING_AMOUNT

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, TAD.NAME ACTIVITY_TYPE
, TAV.VERSION_NAME ACTIVITY_NAME
, EVT.TITLE EVENT_TITLE
, HR_BIS.BIS_DECODE_LOOKUP('SCHEDULED_EVENT_STATUS'
, EVT.EVENT_STATUS) EVENT_STATUS
, DECODE(BST.TYPE
, 'A'
, 'ATTENDED'
, 'P'
, 'PLACED'
, 'W'
, 'WAITLISTED'
, 'C'
, 'CANCELLED'
, 'R'
, 'RESTRICTED') BOOKING_STATUS
, OEH.FLOW_STATUS_CODE ORDER_HEADER_STATUS
, OEL.FLOW_STATUS_CODE ORDER_LINE_STATUS
, NUMBER_OF_PLACES PLACES_BOOKED
, NVL(TFL.MONEY_AMOUNT
, 0) OTA_AMOUNT
, TFL.CURRENCY_CODE OTA_AMOUNT_CURRENCY
, NVL(OEL.ORDERED_QUANTITY * OEL.UNIT_SELLING_PRICE
, 0) OE_AMOUNT
, OEH.TRANSACTIONAL_CURR_CODE OE_AMOUNT_CURRENCY
, DECODE(TDB.INTERNAL_BOOKING_FLAG
, 'Y'
, 'YES'
, 'NO') INTERNAL_BOOKING
, DECODE(TDB.INTERNAL_BOOKING_FLAG
, 'N'
, 'YES'
, 'NO') EXTERNAL_BOOKING
, EVT.EVENT_ID EVENT_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TDB.BOOKING_ID ENROLLMENT_ID
, TDB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM OTA_DELEGATE_BOOKINGS TDB
, OTA_BOOKING_STATUS_TYPES BST
, OTA_EVENTS EVT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_FINANCE_LINES TFL
, OE_ORDER_LINES_ALL OEL
, OE_ORDER_HEADERS_ALL OEH
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE TDB.EVENT_ID = EVT.EVENT_ID
AND BST.BOOKING_STATUS_TYPE_ID = TDB.BOOKING_STATUS_TYPE_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TDB.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND EVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID (+)
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID (+)
AND TDB.BOOKING_ID = TFL.BOOKING_ID (+)
AND TDB.LINE_ID = OEL.LINE_ID (+)
AND OEL.HEADER_ID = OEH.HEADER_ID (+)
AND TDB.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TDB.BUSINESS_GROUP_ID) WITH READ ONLY

Columns