VIEW: APPS.AR_DRAWEE_SITE_USES_H_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)