View: OTFV_COST_TRANSFER

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, TFH.PAYING_COST_CENTER PAYING_COST_CENTER
, EVT.TITLE EVENT_TITLE
, EVT.EVENT_TYPE EVENT_TYPE
, DECODE(ACI.ACTIVITY_CATEGORY
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('ACTIVITY_CATEGORY'
, ACI.ACTIVITY_CATEGORY)) CATEGORY_NAME
, TAV.VERSION_NAME ACTIVITY_NAME
, EVT.COURSE_START_DATE EVENT_START_DATE
, (EVT.COURSE_END_DATE-EVT.COURSE_START_DATE+1) TRAINING_DURATION_DAYS
, ORGT.NAME EVENT_CENTER
, DEL.FULL_NAME STUDENT_NAME
, DEL.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, BST.NAME BOOKING_STATUS
, TDB.DATE_BOOKING_PLACED BOOKING_DATE
, TFL.DATE_RAISED BILLING_DATE
, TFL.CURRENCY_CODE CURRENCY
, TFL.MONEY_AMOUNT ENROLLMENT_AMOUNT
, TFL.TRANSFER_DATE TRANSFER_DATE
, DECODE(TFL.TRANSFER_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('GL_TRANSFER_STATUS'
, TFL.TRANSFER_STATUS)) TRANSFER_STATUS
, '_KF:SQLGL:GL#:GCC'
, TDB.DELEGATE_PERSON_ID PERSON_ID
, TDB.BOOKING_ID BOOKING_ID
, TDB.BOOKING_STATUS_TYPE_ID BOOKING_STATUS_TYPE_ID
, TFL.FINANCE_LINE_ID FINANCE_LINE_ID
, TFH.FINANCE_HEADER_ID FINANCDE_HEADER_ID
, TDB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVT.TRAINING_CENTER_ID TRAINING_CENTER_ID
, EVT.OFFERING_ID OFFERING_ID
, TAV.RCO_ID RCO_ID
FROM OTA_DELEGATE_BOOKINGS TDB
, OTA_FINANCE_LINES TFL
, OTA_FINANCE_HEADERS TFH
, GL_CODE_COMBINATIONS GCC
, OTA_BOOKING_STATUS_TYPES BST
, PER_ALL_PEOPLE_F DEL
, OTA_EVENTS EVT
, OTA_ACTIVITY_VERSIONS TAV
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, OTA_ACT_CAT_INCLUSIONS ACI
, OTA_CATEGORY_USAGES TCU
WHERE TFH.TYPE = 'CT'
AND EVT.TRAINING_CENTER_ID = ORGT.ORGANIZATION_ID(+)
AND DECODE(ORGT.LANGUAGE
, NULL
, 'X'
, ORGT.LANGUAGE)= DECODE(ORGT.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND TFH.FINANCE_HEADER_ID = TFL.FINANCE_HEADER_ID
AND TFH.TRANSFER_FROM_CC_ID = GCC.CODE_COMBINATION_ID(+)
AND TFL.BOOKING_ID = TDB.BOOKING_ID(+)
AND TDB.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID(+)
AND TDB.DELEGATE_PERSON_ID = DEL.PERSON_ID(+)
AND TDB.DATE_BOOKING_PLACED BETWEEN DEL.EFFECTIVE_START_DATE(+)
AND DEL.EFFECTIVE_END_DATE(+)
AND TDB.EVENT_ID = EVT.EVENT_ID (+)
AND EVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID (+)
AND TAV.ACTIVITY_VERSION_ID = ACI.ACTIVITY_VERSION_ID (+)
AND ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID (+)
AND (TCU.TYPE = 'DM' OR TCU.TYPE IS NULL)
AND TDB.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID(+)
AND DECODE(BGRT.LANGUAGE
, NULL
, 'X'
, BGRT.LANGUAGE)= DECODE(BGRT.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND TDB.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TDB.BUSINESS_GROUP_ID) WITH READ ONLY

Columns