View: AR_DRAWEE_SITE_USES_H_V

Product:	AR - Receivables
Description:	drawee customer site header extract
Implementation/DBA Data:	APPS.AR_DRAWEE_SITE_USES_H_V

View Text

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.GLOBAL_ATTRIBUTE1 DRAW_SITE_GLOBAL_ATTR1
, CASA2.GLOBAL_ATTRIBUTE2 DRAW_SITE_GLOBAL_ATTR2
, CASA2.GLOBAL_ATTRIBUTE3 DRAW_SITE_GLOBAL_ATTR3
, CASA2.GLOBAL_ATTRIBUTE4 DRAW_SITE_GLOBAL_ATTR4
, CASA2.GLOBAL_ATTRIBUTE5 DRAW_SITE_GLOBAL_ATTR5
, CASA2.GLOBAL_ATTRIBUTE6 DRAW_SITE_GLOBAL_ATTR6
, CASA2.GLOBAL_ATTRIBUTE7 DRAW_SITE_GLOBAL_ATTR7
, CASA2.GLOBAL_ATTRIBUTE8 DRAW_SITE_GLOBAL_ATTR8
, CASA2.GLOBAL_ATTRIBUTE9 DRAW_SITE_GLOBAL_ATTR9
, CASA2.GLOBAL_ATTRIBUTE_CATEGORY DRAW_SITE_GLOBAL_ATTR_CAT
, 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
, T2.DESCRIPTION DRAW_TERRITORY_DESCRIPTION
, T2.NAME DRAW_TERRITORY_NAME
, T2.SEGMENT1 DRAW_TERRITORY_SEGMENT1
, T2.SEGMENT10 DRAW_TERRITORY_SEGMENT10
, T2.SEGMENT11 DRAW_TERRITORY_SEGMENT11
, T2.SEGMENT12 DRAW_TERRITORY_SEGMENT12
, T2.SEGMENT13 DRAW_TERRITORY_SEGMENT13
, T2.SEGMENT14 DRAW_TERRITORY_SEGMENT14
, T2.SEGMENT15 DRAW_TERRITORY_SEGMENT15
, T2.SEGMENT16 DRAW_TERRITORY_SEGMENT16
, T2.SEGMENT17 DRAW_TERRITORY_SEGMENT17
, T2.SEGMENT18 DRAW_TERRITORY_SEGMENT18
, T2.SEGMENT19 DRAW_TERRITORY_SEGMENT19
, T2.SEGMENT2 DRAW_TERRITORY_SEGMENT2
, T2.SEGMENT20 DRAW_TERRITORY_SEGMENT20
, T2.SEGMENT3 DRAW_TERRITORY_SEGMENT3
, T2.SEGMENT4 DRAW_TERRITORY_SEGMENT4
, T2.SEGMENT5 DRAW_TERRITORY_SEGMENT5
, T2.SEGMENT6 DRAW_TERRITORY_SEGMENT6
, T2.SEGMENT7 DRAW_TERRITORY_SEGMENT7
, T2.SEGMENT8 DRAW_TERRITORY_SEGMENT8
, T2.SEGMENT9 DRAW_TERRITORY_SEGMENT9
, T2.TERRITORY_ID DRAW_TERRITORY_ID
, CSUA2.GLOBAL_ATTRIBUTE1 DRAW_USES_GLOBAL_ATTR1
, CSUA2.GLOBAL_ATTRIBUTE_CATEGORY DRAW_USES_GLOBAL_ATTR_CAT
, 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
, RA_TERRITORIES T2
, 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
AND CSUA2.TERRITORY_ID = T2.TERRITORY_ID (+)

Columns