Product: | AR - Receivables |
---|---|
Description: | drawee customer header extract |
Implementation/DBA Data: | APPS.AR_DRAWEE_CUSTOMERS_H_V |
SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ CA2.ACCOUNT_NUMBER DRAW_CUST_ACCOUNT_NUMBER
, CA2.CUSTOMER_TYPE DRAW_CUST_TYPE
, CA2.CUST_ACCOUNT_ID DRAW_CUST_ACCOUNT_ID
, CA2.GLOBAL_ATTRIBUTE1 DRAW_CUST_GLOBAL_ATTR1
, CA2.GLOBAL_ATTRIBUTE10 DRAW_CUST_GLOBAL_ATTR10
, CA2.GLOBAL_ATTRIBUTE12 DRAW_CUST_GLOBAL_ATTR12
, CA2.GLOBAL_ATTRIBUTE9 DRAW_CUST_GLOBAL_ATTR9
, CA2.GLOBAL_ATTRIBUTE_CATEGORY DRAW_CUST_GLOBAL_ATTR_CAT
, CA2.NPA_NUMBER DRAW_CUST_NPA_NUMBER
, P2.CATEGORY_CODE DRAW_CUST_CAT_CODE
, P2.CITY DRAW_CUST_CITY
, P2.COUNTRY DRAW_CUST_COUNTRY
, P2.COUNTY DRAW_CUST_COUNTY
, P2.GROUP_TYPE DRAW_CUST_GROUP_TYPE
, P2.GSA_INDICATOR_FLAG DRAW_CUST_GSA_FLAG
, P2.JGZZ_FISCAL_CODE DRAW_CUST_FISCAL_CODE
, P2.KNOWN_AS DRAW_CUST_ALTERNATE_NAME
, P2.PARTY_ID DRAW_CUST_PARTY_ID
, P2.PARTY_NAME DRAW_CUST_PARTY_NAME
, P2.PARTY_NUMBER DRAW_CUST_PARTY_NUMBER
, P2.PARTY_TYPE DRAW_CUST_PARTY_TYPE
, P2.POSTAL_CODE DRAW_CUST_POSTAL_CODE
, P2.SIC_CODE_TYPE DRAW_CUST_PROVINCE
, P2.STATE DRAW_CUST_STATE
, P2.TAX_REFERENCE DRAW_CUST_TAX_REFERENCE
, HE.EVENT_ID EVENT_ID
FROM HZ_CUST_ACCOUNTS CA2
, HZ_PARTIES P2
, AR_XLA_LINES_EXTRACT HE
WHERE CA2.CUST_ACCOUNT_ID = HE.DRAWEE_CUSTOMER_ID
AND HE.LEVEL_FLAG = 'H'
AND CA2.PARTY_ID = P2.PARTY_ID