View: OTFV_ENROLLMENT_AGREEMENTS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, TBD.NAME AGREEMENT_NAME
, DECODE(TBD.TYPE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('BOOKING_DEAL_TYPE'
, TBD.TYPE)) AGREEMENT_TYPE
, TBD.COMMENTS AGREEMENT_COMMENTS
, TBD.DESCRIPTION DESCRIPTION
, DECODE(TBD.CATEGORY
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('ACTIVITY_CATEGORY'
, TBD.CATEGORY)) CATEGORY
, TBD.START_DATE AGREEMENT_START_DATE
, TBD.END_DATE AGREEMENT_END_DATE
, TBD.DISCOUNT_PERCENTAGE DISCOUNT_PERCENT
, DECODE(TBD.LIMIT_EACH_EVENT_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TBD.LIMIT_EACH_EVENT_FLAG)) LIMIT_EACH_EVENT
, TBD.NUMBER_OF_PLACES MAXIMUM_PLACES
, TBD.OVERDRAFT_LIMIT OVERDRAFT_LIMIT
, DECODE(TBD.TYPE
, 'P'
, OTA_TBD_API.TFL_PURCHASED(TBD.BOOKING_DEAL_ID
, TPL.PRICE_LIST_TYPE)) TOTAL_PURCHASED
, DECODE(TBD.TYPE
, 'P'
, OTA_TBD_API.TFL_BALANCE(TBD.BOOKING_DEAL_ID
, TPL.PRICE_LIST_TYPE)) BALANCE
, CUS.CUSTOMER_NAME CUSTOMER_NAME
, EVT.TITLE EVENT_TITLE
, TAV.VERSION_NAME ACTIVITY_NAME
, TAD.NAME ACTIVITY_TYPE
, FND.USER_NAME APPROVED_BY
, TPL.NAME PRICE_LIST_NAME
, DECODE(TPL.PRICE_LIST_TYPE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('PRICE_LIST_TYPE'
, TPL.PRICE_LIST_TYPE)) PRICE_LIST_TYPE
, DECODE(TPL.DEFAULT_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TPL.DEFAULT_FLAG)) DEFAULT_PRICE_LIST
, TPL.DESCRIPTION PRICE_LIST_DESCRIPTION
, TPL.TRAINING_UNIT_TYPE TRAINING_UNITS
, TPL.SINGLE_UNIT_PRICE UNIT_PRICE
, OTA_GENERAL.FND_CURRENCY_NAME(TPL.CURRENCY_CODE) PRICE_LIST_CURRENCY
, TPL.START_DATE PRICE_LIST_DATE_FROM
, TPL.END_DATE PRICE_LIST_DATE_TO
, '_DF:OTA:OTA_BOOKING_DEALS:TBD'
, TBD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CUS.CUSTOMER_ID CUSTOMER_ID
, EVT.EVENT_ID EVENT_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TBD.APPROVED_BY_PERSON_ID APPROVED_BY_PERSON_ID
, TPL.PRICE_LIST_ID PRICE_LIST_ID
, TBD.BOOKING_DEAL_ID AGREEMENT_ID
, TAV.RCO_ID RCO_ID
, EVT.OFFERING_ID OFFERING_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_VERSIONS TAV
, OTA_EVENTS EVT
, OTA_PRICE_LISTS TPL
, OTA_BOOKING_DEALS TBD
, RA_CUSTOMERS CUS
, FND_USER FND
WHERE TBD.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TBD.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID (+)
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID(+)
AND TBD.EVENT_ID = EVT.EVENT_ID (+)
AND TBD.PRICE_LIST_ID = TPL.PRICE_LIST_ID (+)
AND TBD.CUSTOMER_ID = CUS.CUSTOMER_ID (+)
AND TBD.APPROVED_BY_PERSON_ID = FND.USER_ID (+)
AND TBD.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TBD.BUSINESS_GROUP_ID) WITH READ ONLY

Columns