View: OTA_EVENT_ASSOCIAT_BILLING_V

Product:	OTA - Learning Management
Description:	View to show the Finance information related to an Event Association
Implementation/DBA Data:	APPS.OTA_EVENT_ASSOCIAT_BILLING_V

View Text

SELECT TEA.EVENT_ASSOCIATION_ID
, TDB.BOOKING_ID
, TDB.OBJECT_VERSION_NUMBER
, TDB.BOOKING_STATUS_TYPE_ID
, BST.NAME
, TDB.INTERNAL_BOOKING_FLAG
, TDB.SOURCE_OF_BOOKING
, HR_GENERAL.DECODE_LOOKUP ('BOOKING_SOURCE'
, TDB.SOURCE_OF_BOOKING)
, TDB.CONTACT_ID
, SUBSTRB( PARTY.PERSON_LAST_NAME
, 1
, 40)
, SUBSTRB( PARTY.PERSON_FIRST_NAME
, 1
, 50)
, PARTY.PERSON_PRE_NAME_ADJUNCT
, CTI_LOOK.MEANING
, INITCAP(SUBSTRB( PARTY.PERSON_LAST_NAME
, 1
, 40)||'
, '||CTI_LOOK.MEANING||' '|| SUBSTRB( PARTY.PERSON_FIRST_NAME
, 1
, 50))
, EVT.STANDARD_PRICE
, EVT.CURRENCY_CODE
, TBD.BOOKING_DEAL_ID
, TBD.NAME
, TBD.TYPE
, DECODE(TBD.TYPE
, 'D'
, TBD.NAME
, NULL)
, DECODE(TBD.TYPE
, 'P'
, TBD.NAME
, NULL)
, TPL.TRAINING_UNIT_TYPE
, TU_LOOK.MEANING
, TFH.FINANCE_HEADER_ID
, TFH.CUSTOMER_ID
, SUBSTRB(CUS_PARTY.PARTY_NAME
, 1
, 50)
, TFH.INVOICE_CONTACT
, TFH.INVOICE_ADDRESS
, TFL.FINANCE_LINE_ID
, TFL.STANDARD_AMOUNT
, TFL.MONEY_AMOUNT
, TFL.UNITARY_AMOUNT
FROM OTA_EVENT_ASSOCIATIONS TEA
, OTA_DELEGATE_BOOKINGS TDB
, OTA_EVENTS EVT
, OTA_FINANCE_LINES TFL
, OTA_FINANCE_HEADERS TFH
, OTA_BOOKING_DEALS TBD
, OTA_PRICE_LISTS TPL
, HZ_PARTIES CUS_PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HR_LOOKUPS TU_LOOK
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_ORG_CONTACTS ORG_CONT
, HZ_PARTIES REL_PARTY
, AR_LOOKUPS CTI_LOOK
, OTA_BOOKING_STATUS_TYPES_TL BST
WHERE EVT.EVENT_ID = TEA.EVENT_ID
AND EVT.PRICE_BASIS = 'C'
AND TDB.EVENT_ID = EVT.EVENT_ID
AND TDB.CUSTOMER_ID = TEA.CUSTOMER_ID
AND TFL.BOOKING_ID = TDB.BOOKING_ID
AND TFL.CANCELLED_FLAG = 'N'
AND TFH.FINANCE_HEADER_ID (+) = TFL.FINANCE_HEADER_ID
AND CUST_ACCT.CUST_ACCOUNT_ID (+) = TFH.CUSTOMER_ID
AND CUST_ACCT.PARTY_ID = CUS_PARTY.PARTY_ID (+)
AND TBD.BOOKING_DEAL_ID (+) = TFL.BOOKING_DEAL_ID
AND TPL.PRICE_LIST_ID (+) = TBD.PRICE_LIST_ID
AND TU_LOOK.LOOKUP_TYPE (+) = 'TRAINING_UNIT'
AND TU_LOOK.LOOKUP_CODE (+) = TPL.TRAINING_UNIT_TYPE
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = TDB.CONTACT_ID
AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.DIRECTIONAL_FLAG = 'F'
AND CTI_LOOK.LOOKUP_TYPE = 'CONTACT_TITLE'
AND CTI_LOOK.LOOKUP_CODE (+) = PARTY.PERSON_PRE_NAME_ADJUNCT
AND BST.BOOKING_STATUS_TYPE_ID = TDB.BOOKING_STATUS_TYPE_ID
AND BST.LANGUAGE = USERENV ('LANG')

Columns