AR_DRAWEE_CUSTOMERS_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
DRAW_CUST_ACCOUNT_NUMBER DRAW_CUST_TYPE DRAW_CUST_ACCOUNT_ID DRAW_CUST_NPA_NUMBER DRAW_CUST_CAT_CODE DRAW_CUST_CITY DRAW_CUST_COUNTRY DRAW_CUST_COUNTY DRAW_CUST_GROUP_TYPE DRAW_CUST_GSA_FLAG DRAW_CUST_FISCAL_CODE DRAW_CUST_PARTY_ID DRAW_CUST_PARTY_NAME DRAW_CUST_PARTY_NUMBER DRAW_CUST_PARTY_TYPE DRAW_CUST_POSTAL_CODE DRAW_CUST_PROVINCE DRAW_CUST_STATE DRAW_CUST_TAX_REFERENCE EVENT_ID

Query

SQL_Statement

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.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.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, null 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