AR_DRAWEE_SITE_USES_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
DRAW_SITE_CUST_CAT_CODE DRAW_SITE_CUST_ACCT_SITE_ID DRAW_SITE_TRNSL_CUST_NAME DRAW_SITE_GSA_INDICATOR DRAW_SITE_LOCATION DRAW_SITE_SITE_USE_CODE DRAW_SITE_SITE_USE_ID DRAW_SITE_TAX_REFERENCE DRAW_USES_GSA_INDICATOR DRAW_USES_LOCATION DRAW_USES_SITE_USE_CODE DRAW_USES_SITE_USE_ID DRAW_USES_TAX_REFERENCE DRAW_SITE_PARTY_SITE_ID EVENT_ID

Query

SQL_Statement

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ CASA2.CUSTOMER_CATEGORY_CODE DRAW_SITE_CUST_CAT_CODE, CASA2.CUST_ACCT_SITE_ID DRAW_SITE_CUST_ACCT_SITE_ID, CASA2.TRANSLATED_CUSTOMER_NAME DRAW_SITE_TRNSL_CUST_NAME, CSUA2.GSA_INDICATOR DRAW_SITE_GSA_INDICATOR, CSUA2.LOCATION DRAW_SITE_LOCATION, CSUA2.SITE_USE_CODE DRAW_SITE_SITE_USE_CODE, CSUA2.SITE_USE_ID DRAW_SITE_SITE_USE_ID, CSUA2.TAX_REFERENCE DRAW_SITE_TAX_REFERENCE, CSUA2.GSA_INDICATOR DRAW_USES_GSA_INDICATOR, CSUA2.LOCATION DRAW_USES_LOCATION, CSUA2.SITE_USE_CODE DRAW_USES_SITE_USE_CODE, CSUA2.SITE_USE_ID DRAW_USES_SITE_USE_ID, CSUA2.TAX_REFERENCE DRAW_USES_TAX_REFERENCE, CASA2.PARTY_SITE_ID DRAW_SITE_PARTY_SITE_ID, HE.EVENT_ID EVENT_ID FROM HZ_CUST_SITE_USES_ALL CSUA2, HZ_CUST_ACCT_SITES_ALL CASA2, AR_XLA_LINES_EXTRACT HE WHERE CSUA2.SITE_USE_ID = HE.DRAWEE_SITE_USE_ID AND HE.LEVEL_FLAG = 'H' AND CSUA2.CUST_ACCT_SITE_ID = CASA2.CUST_ACCT_SITE_ID