VIEW: APPS.OTA_EVENT_ASSOCIAT_BILLING_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')