VIEW: APPS.AR_CM_SOLD_SITE_USES_H_V

Source

View Text - Preformatted

SELECT /*+INDEX (he ar_xla_lines_extract_n1)*/ casa9.customer_category_code cm_sold_site_cust_cat_code ,casa9.cust_acct_site_id cm_sold_site_cust_acct_site_id ,casa9.global_attribute1 cm_sold_site_global_attr1 ,casa9.global_attribute2 cm_sold_site_global_attr2 ,casa9.global_attribute3 cm_sold_site_global_attr3 ,casa9.global_attribute4 cm_sold_site_global_attr4 ,casa9.global_attribute5 cm_sold_site_global_attr5 ,casa9.global_attribute6 cm_sold_site_global_attr6 ,casa9.global_attribute7 cm_sold_site_global_attr7 ,casa9.global_attribute8 cm_sold_site_global_attr8 ,casa9.global_attribute9 cm_sold_site_global_attr9 ,casa9.global_attribute_category cm_sold_site_global_attr_cat ,casa9.translated_customer_name cm_sold_site_trnsl_cust_name ,csua8.gsa_indicator cm_sold_site_gsa_indicator ,csua8.location cm_sold_site_location ,csua8.site_use_code cm_sold_site_site_use_code ,csua8.site_use_id cm_sold_site_site_use_id ,csua8.tax_reference cm_sold_site_tax_reference ,t8.description cm_sold_territory_description ,t8.name cm_sold_territory_name ,t8.segment1 cm_sold_territory_segment1 ,t8.segment10 cm_sold_territory_segment10 ,t8.segment11 cm_sold_territory_segment11 ,t8.segment12 cm_sold_territory_segment12 ,t8.segment13 cm_sold_territory_segment13 ,t8.segment14 cm_sold_territory_segment14 ,t8.segment15 cm_sold_territory_segment15 ,t8.segment16 cm_sold_territory_segment16 ,t8.segment17 cm_sold_territory_segment17 ,t8.segment18 cm_sold_territory_segment18 ,t8.segment19 cm_sold_territory_segment19 ,t8.segment2 cm_sold_territory_segment2 ,t8.segment20 cm_sold_territory_segment20 ,t8.segment3 cm_sold_territory_segment3 ,t8.segment4 cm_sold_territory_segment4 ,t8.segment5 cm_sold_territory_segment5 ,t8.segment6 cm_sold_territory_segment6 ,t8.segment7 cm_sold_territory_segment7 ,t8.segment8 cm_sold_territory_segment8 ,t8.segment9 cm_sold_territory_segment9 ,t8.territory_id cm_sold_territory_id ,csua8.global_attribute1 CM_SOLD_USES_GLOBAL_ATTR1 ,csua8.global_attribute_category CM_SOLD_USES_GLOBAL_ATTR_CAT ,csua8.gsa_indicator CM_SOLD_USES_GSA_INDICATOR ,csua8.location CM_SOLD_USES_LOCATION ,csua8.site_use_code CM_SOLD_USES_SITE_USE_CODE ,csua8.site_use_id CM_SOLD_USES_SITE_USE_ID ,csua8.tax_reference CM_SOLD_USES_TAX_REFERENCE ,casa9.party_site_id CM_SOLD_SITE_PARTY_SITE_ID ,he.ledger_id ledger_id ,he.event_id event_id FROM hz_cust_site_uses_all csua8 ,hz_cust_acct_sites_all casa9 ,ra_territories t8 ,ar_xla_lines_extract he WHERE he.level_flag = 'H' and csua8.site_use_id = he.sold_site_use_id and csua8.cust_acct_site_id = casa9.cust_acct_site_id and csua8.territory_id = t8.territory_id (+)

View Text - HTML Formatted

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1)*/ CASA9.CUSTOMER_CATEGORY_CODE CM_SOLD_SITE_CUST_CAT_CODE
, CASA9.CUST_ACCT_SITE_ID CM_SOLD_SITE_CUST_ACCT_SITE_ID
, CASA9.GLOBAL_ATTRIBUTE1 CM_SOLD_SITE_GLOBAL_ATTR1
, CASA9.GLOBAL_ATTRIBUTE2 CM_SOLD_SITE_GLOBAL_ATTR2
, CASA9.GLOBAL_ATTRIBUTE3 CM_SOLD_SITE_GLOBAL_ATTR3
, CASA9.GLOBAL_ATTRIBUTE4 CM_SOLD_SITE_GLOBAL_ATTR4
, CASA9.GLOBAL_ATTRIBUTE5 CM_SOLD_SITE_GLOBAL_ATTR5
, CASA9.GLOBAL_ATTRIBUTE6 CM_SOLD_SITE_GLOBAL_ATTR6
, CASA9.GLOBAL_ATTRIBUTE7 CM_SOLD_SITE_GLOBAL_ATTR7
, CASA9.GLOBAL_ATTRIBUTE8 CM_SOLD_SITE_GLOBAL_ATTR8
, CASA9.GLOBAL_ATTRIBUTE9 CM_SOLD_SITE_GLOBAL_ATTR9
, CASA9.GLOBAL_ATTRIBUTE_CATEGORY CM_SOLD_SITE_GLOBAL_ATTR_CAT
, CASA9.TRANSLATED_CUSTOMER_NAME CM_SOLD_SITE_TRNSL_CUST_NAME
, CSUA8.GSA_INDICATOR CM_SOLD_SITE_GSA_INDICATOR
, CSUA8.LOCATION CM_SOLD_SITE_LOCATION
, CSUA8.SITE_USE_CODE CM_SOLD_SITE_SITE_USE_CODE
, CSUA8.SITE_USE_ID CM_SOLD_SITE_SITE_USE_ID
, CSUA8.TAX_REFERENCE CM_SOLD_SITE_TAX_REFERENCE
, T8.DESCRIPTION CM_SOLD_TERRITORY_DESCRIPTION
, T8.NAME CM_SOLD_TERRITORY_NAME
, T8.SEGMENT1 CM_SOLD_TERRITORY_SEGMENT1
, T8.SEGMENT10 CM_SOLD_TERRITORY_SEGMENT10
, T8.SEGMENT11 CM_SOLD_TERRITORY_SEGMENT11
, T8.SEGMENT12 CM_SOLD_TERRITORY_SEGMENT12
, T8.SEGMENT13 CM_SOLD_TERRITORY_SEGMENT13
, T8.SEGMENT14 CM_SOLD_TERRITORY_SEGMENT14
, T8.SEGMENT15 CM_SOLD_TERRITORY_SEGMENT15
, T8.SEGMENT16 CM_SOLD_TERRITORY_SEGMENT16
, T8.SEGMENT17 CM_SOLD_TERRITORY_SEGMENT17
, T8.SEGMENT18 CM_SOLD_TERRITORY_SEGMENT18
, T8.SEGMENT19 CM_SOLD_TERRITORY_SEGMENT19
, T8.SEGMENT2 CM_SOLD_TERRITORY_SEGMENT2
, T8.SEGMENT20 CM_SOLD_TERRITORY_SEGMENT20
, T8.SEGMENT3 CM_SOLD_TERRITORY_SEGMENT3
, T8.SEGMENT4 CM_SOLD_TERRITORY_SEGMENT4
, T8.SEGMENT5 CM_SOLD_TERRITORY_SEGMENT5
, T8.SEGMENT6 CM_SOLD_TERRITORY_SEGMENT6
, T8.SEGMENT7 CM_SOLD_TERRITORY_SEGMENT7
, T8.SEGMENT8 CM_SOLD_TERRITORY_SEGMENT8
, T8.SEGMENT9 CM_SOLD_TERRITORY_SEGMENT9
, T8.TERRITORY_ID CM_SOLD_TERRITORY_ID
, CSUA8.GLOBAL_ATTRIBUTE1 CM_SOLD_USES_GLOBAL_ATTR1
, CSUA8.GLOBAL_ATTRIBUTE_CATEGORY CM_SOLD_USES_GLOBAL_ATTR_CAT
, CSUA8.GSA_INDICATOR CM_SOLD_USES_GSA_INDICATOR
, CSUA8.LOCATION CM_SOLD_USES_LOCATION
, CSUA8.SITE_USE_CODE CM_SOLD_USES_SITE_USE_CODE
, CSUA8.SITE_USE_ID CM_SOLD_USES_SITE_USE_ID
, CSUA8.TAX_REFERENCE CM_SOLD_USES_TAX_REFERENCE
, CASA9.PARTY_SITE_ID CM_SOLD_SITE_PARTY_SITE_ID
, HE.LEDGER_ID LEDGER_ID
, HE.EVENT_ID EVENT_ID
FROM HZ_CUST_SITE_USES_ALL CSUA8
, HZ_CUST_ACCT_SITES_ALL CASA9
, RA_TERRITORIES T8
, AR_XLA_LINES_EXTRACT HE
WHERE HE.LEVEL_FLAG = 'H'
AND CSUA8.SITE_USE_ID = HE.SOLD_SITE_USE_ID
AND CSUA8.CUST_ACCT_SITE_ID = CASA9.CUST_ACCT_SITE_ID
AND CSUA8.TERRITORY_ID = T8.TERRITORY_ID (+)