View: AST_EV_HIS_PER_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_EV_HIS_PER_V

View Text

SELECT REG.EVENT_REGISTRATION_ID
, REG.EVENT_OFFER_ID
, EVT.EVENT_OFFER_NAME
, REG.ORDER_HEADER_ID
, REG.DATE_REGISTRATION_PLACED
, CST.PARTY_ID CUSTOMER_ID
, CST.PARTY_TYPE PARTY_TYPE
, CST.PARTY_NAME MAIN_CONTACT_FULL_NAME
, REG.ATTENDANT_CONTACT_ID MAIN_CONTACT_ID
, CST1.PARTY_NAME ENROLLEE_FULL_NAME
, HCP.PHONE_COUNTRY_CODE || DECODE(HCP.PHONE_AREA_CODE
, NULL
, NULL
, HCP.PHONE_AREA_CODE
, '(' || HCP.PHONE_AREA_CODE || ')') || HCP.PHONE_NUMBER || DECODE(HCP.PHONE_EXTENSION
, NULL
, NULL
, HCP.PHONE_EXTENSION
, ' EXT ' || HCP.PHONE_EXTENSION) ENROLLEE_PHONE_NUMBER
, REG.CONFIRMATION_CODE
, REG.SYSTEM_STATUS_CODE
, REG.OBJECT_VERSION_NUMBER
, EVT.INVENTORY_ITEM_ID
, OOH.TRANSACTIONAL_CURR_CODE
, LKU.MEANING PAYMENT_STATUS
, OOH.PAYMENT_TYPE_CODE
, OOH.PAYMENT_AMOUNT
, QPH.NAME PRICE_LIST_NAME
, REG.CANCELLATION_REASON_CODE
FROM AMS_EVENT_REGISTRATIONS REG
, AMS_EVENT_OFFERS_VL EVT
, HZ_PARTIES CST
, HZ_PARTIES CST1
, HZ_CONTACT_POINTS HCP
, AMS_LOOKUPS LKU
, OE_ORDER_HEADERS OOH
, OE_ORDER_LINES OOL
, QP_LIST_HEADERS_VL QPH
WHERE EVT.EVENT_OFFER_ID = REG.EVENT_OFFER_ID
AND CST.PARTY_ID = REG.REGISTRANT_PARTY_ID
AND CST.PARTY_TYPE = 'PERSON'
AND CST1.PARTY_ID = REG.ATTENDANT_CONTACT_ID
AND CST1.PARTY_ID = HCP.OWNER_TABLE_ID(+)
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP.CONTACT_POINT_TYPE(+) = 'PHONE'
AND HCP.PRIMARY_FLAG(+) = 'Y'
AND HCP. STATUS(+) = 'A'
AND LKU.LOOKUP_TYPE(+)='AMS_EVENT_PAYMENT_STATUS'
AND LKU.LOOKUP_CODE(+)=REG.PAYMENT_STATUS_CODE
AND OOH.HEADER_ID (+) = REG.ORDER_HEADER_ID
AND OOL.LINE_ID(+) = REG.ORDER_LINE_ID
AND QPH.LIST_HEADER_ID (+) = OOL.PRICE_LIST_ID

Columns