VIEW: APPS.AR_RCT_SITE_USES_H_V

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ casa3.cust_acct_site_id rct_site_cust_acct_site_id ,casa3.translated_customer_name rct_site_trnsl_cust_name ,csua3.gsa_indicator rct_site_gsa_indicator ,csua3.location rct_site_location ,csua3.site_use_code rct_site_site_use_code ,csua3.site_use_id rct_site_site_use_id ,csua3.tax_reference rct_site_tax_reference ,t3.description rct_territory_description ,t3.name rct_territory_name ,t3.segment1 rct_territory_segment1 ,t3.segment10 rct_territory_segment10 ,t3.segment11 rct_territory_segment11 ,t3.segment12 rct_territory_segment12 ,t3.segment13 rct_territory_segment13 ,t3.segment14 rct_territory_segment14 ,t3.segment15 rct_territory_segment15 ,t3.segment16 rct_territory_segment16 ,t3.segment17 rct_territory_segment17 ,t3.segment18 rct_territory_segment18 ,t3.segment19 rct_territory_segment19 ,t3.segment2 rct_territory_segment2 ,t3.segment20 rct_territory_segment20 ,t3.segment3 rct_territory_segment3 ,t3.segment4 rct_territory_segment4 ,t3.segment5 rct_territory_segment5 ,t3.segment6 rct_territory_segment6 ,t3.segment7 rct_territory_segment7 ,t3.segment8 rct_territory_segment8 ,t3.segment9 rct_territory_segment9 ,t3.territory_id rct_territory_id ,casa3.CUSTOMER_CATEGORY_CODE rct_site_cust_cat_code ,casa3.global_attribute1 rct_site_global_attr1 ,casa3.global_attribute2 rct_site_global_attr2 ,casa3.global_attribute3 rct_site_global_attr3 ,casa3.global_attribute4 rct_site_global_attr4 ,casa3.global_attribute5 rct_site_global_attr5 ,casa3.global_attribute6 rct_site_global_attr6 ,casa3.global_attribute7 rct_site_global_attr7 ,casa3.global_attribute8 rct_site_global_attr8 ,casa3.global_attribute9 rct_site_global_attr9 ,casa3.global_attribute_category rct_site_global_attr_cat ,casa3.party_site_id rct_site_party_site_id ,l.event_id event_id ,l.ledger_id ledger_id ,csua3.gl_id_clearing rct_bill_uses_clearing_ccid ,csua3.gl_id_freight rct_bill_uses_freight_ccid ,csua3.gl_id_rec rct_bill_uses_rec_ccid ,csua3.gl_id_rev rct_bill_uses_rev_ccid ,csua3.gl_id_tax rct_bill_uses_tax_ccid ,csua3.gl_id_unbilled rct_bill_uses_unbilled_ccid ,csua3.gl_id_unearned rct_bill_uses_unearned_ccid FROM hz_cust_site_uses_all csua3 ,hz_cust_acct_sites_all casa3 ,ra_territories t3 ,ar_xla_lines_extract l WHERE csua3.site_use_id = l.paying_site_use_id AND l.level_flag = 'H' AND csua3.cust_acct_site_id = casa3.cust_acct_site_id AND csua3.territory_id = t3.territory_id (+)

View Text - HTML Formatted

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ CASA3.CUST_ACCT_SITE_ID RCT_SITE_CUST_ACCT_SITE_ID
, CASA3.TRANSLATED_CUSTOMER_NAME RCT_SITE_TRNSL_CUST_NAME
, CSUA3.GSA_INDICATOR RCT_SITE_GSA_INDICATOR
, CSUA3.LOCATION RCT_SITE_LOCATION
, CSUA3.SITE_USE_CODE RCT_SITE_SITE_USE_CODE
, CSUA3.SITE_USE_ID RCT_SITE_SITE_USE_ID
, CSUA3.TAX_REFERENCE RCT_SITE_TAX_REFERENCE
, T3.DESCRIPTION RCT_TERRITORY_DESCRIPTION
, T3.NAME RCT_TERRITORY_NAME
, T3.SEGMENT1 RCT_TERRITORY_SEGMENT1
, T3.SEGMENT10 RCT_TERRITORY_SEGMENT10
, T3.SEGMENT11 RCT_TERRITORY_SEGMENT11
, T3.SEGMENT12 RCT_TERRITORY_SEGMENT12
, T3.SEGMENT13 RCT_TERRITORY_SEGMENT13
, T3.SEGMENT14 RCT_TERRITORY_SEGMENT14
, T3.SEGMENT15 RCT_TERRITORY_SEGMENT15
, T3.SEGMENT16 RCT_TERRITORY_SEGMENT16
, T3.SEGMENT17 RCT_TERRITORY_SEGMENT17
, T3.SEGMENT18 RCT_TERRITORY_SEGMENT18
, T3.SEGMENT19 RCT_TERRITORY_SEGMENT19
, T3.SEGMENT2 RCT_TERRITORY_SEGMENT2
, T3.SEGMENT20 RCT_TERRITORY_SEGMENT20
, T3.SEGMENT3 RCT_TERRITORY_SEGMENT3
, T3.SEGMENT4 RCT_TERRITORY_SEGMENT4
, T3.SEGMENT5 RCT_TERRITORY_SEGMENT5
, T3.SEGMENT6 RCT_TERRITORY_SEGMENT6
, T3.SEGMENT7 RCT_TERRITORY_SEGMENT7
, T3.SEGMENT8 RCT_TERRITORY_SEGMENT8
, T3.SEGMENT9 RCT_TERRITORY_SEGMENT9
, T3.TERRITORY_ID RCT_TERRITORY_ID
, CASA3.CUSTOMER_CATEGORY_CODE RCT_SITE_CUST_CAT_CODE
, CASA3.GLOBAL_ATTRIBUTE1 RCT_SITE_GLOBAL_ATTR1
, CASA3.GLOBAL_ATTRIBUTE2 RCT_SITE_GLOBAL_ATTR2
, CASA3.GLOBAL_ATTRIBUTE3 RCT_SITE_GLOBAL_ATTR3
, CASA3.GLOBAL_ATTRIBUTE4 RCT_SITE_GLOBAL_ATTR4
, CASA3.GLOBAL_ATTRIBUTE5 RCT_SITE_GLOBAL_ATTR5
, CASA3.GLOBAL_ATTRIBUTE6 RCT_SITE_GLOBAL_ATTR6
, CASA3.GLOBAL_ATTRIBUTE7 RCT_SITE_GLOBAL_ATTR7
, CASA3.GLOBAL_ATTRIBUTE8 RCT_SITE_GLOBAL_ATTR8
, CASA3.GLOBAL_ATTRIBUTE9 RCT_SITE_GLOBAL_ATTR9
, CASA3.GLOBAL_ATTRIBUTE_CATEGORY RCT_SITE_GLOBAL_ATTR_CAT
, CASA3.PARTY_SITE_ID RCT_SITE_PARTY_SITE_ID
, L.EVENT_ID EVENT_ID
, L.LEDGER_ID LEDGER_ID
, CSUA3.GL_ID_CLEARING RCT_BILL_USES_CLEARING_CCID
, CSUA3.GL_ID_FREIGHT RCT_BILL_USES_FREIGHT_CCID
, CSUA3.GL_ID_REC RCT_BILL_USES_REC_CCID
, CSUA3.GL_ID_REV RCT_BILL_USES_REV_CCID
, CSUA3.GL_ID_TAX RCT_BILL_USES_TAX_CCID
, CSUA3.GL_ID_UNBILLED RCT_BILL_USES_UNBILLED_CCID
, CSUA3.GL_ID_UNEARNED RCT_BILL_USES_UNEARNED_CCID
FROM HZ_CUST_SITE_USES_ALL CSUA3
, HZ_CUST_ACCT_SITES_ALL CASA3
, RA_TERRITORIES T3
, AR_XLA_LINES_EXTRACT L
WHERE CSUA3.SITE_USE_ID = L.PAYING_SITE_USE_ID
AND L.LEVEL_FLAG = 'H'
AND CSUA3.CUST_ACCT_SITE_ID = CASA3.CUST_ACCT_SITE_ID
AND CSUA3.TERRITORY_ID = T3.TERRITORY_ID (+)