VIEW: APPS.AR_CM_BILL_SITE_USES_H_V

Source

View Text - Preformatted

SELECT /*+INDEX(he ar_xla_lines_extract_n1) */ casa7.customer_category_code cm_bill_site_cust_cat_code ,casa7.cust_acct_site_id cm_bill_site_cust_acct_site_id ,casa7.global_attribute1 cm_bill_site_global_attr1 ,casa7.global_attribute2 cm_bill_site_global_attr2 ,casa7.global_attribute3 cm_bill_site_global_attr3 ,casa7.global_attribute4 cm_bill_site_global_attr4 ,casa7.global_attribute5 cm_bill_site_global_attr5 ,casa7.global_attribute6 cm_bill_site_global_attr6 ,casa7.global_attribute7 cm_bill_site_global_attr7 ,casa7.global_attribute8 cm_bill_site_global_attr8 ,casa7.global_attribute9 cm_bill_site_global_attr9 ,casa7.global_attribute_category cm_bill_site_global_attr_cat ,casa7.translated_customer_name cm_bill_site_trnsl_cust_name ,csua6.global_attribute1 cm_bill_uses_global_attr1 ,csua6.global_attribute_category cm_bill_uses_global_attr_cat ,csua6.gl_id_clearing cm_bill_uses_clearing_ccid ,csua6.gl_id_factor cm_bill_uses_factor_ccid ,csua6.gl_id_freight cm_bill_uses_freight_ccid ,csua6.gl_id_rec cm_bill_uses_rec_ccid ,csua6.gl_id_remittance cm_bill_uses_remittance_ccid ,csua6.gl_id_rev cm_bill_uses_rev_ccid ,csua6.gl_id_tax cm_bill_uses_tax_ccid ,csua6.gl_id_unbilled cm_bill_uses_unbilled_ccid ,csua6.gl_id_unearned cm_bill_uses_unearned_ccid ,csua6.gsa_indicator cm_bill_uses_gsa_indicator ,csua6.location cm_bill_uses_location ,csua6.site_use_code cm_bill_uses_site_use_code ,csua6.site_use_id cm_bill_uses_site_use_id ,csua6.tax_reference cm_bill_uses_tax_reference ,t6.description cm_bill_territory_description ,t6.name cm_bill_territory_name ,t6.segment1 cm_bill_territory_segment1 ,t6.segment10 cm_bill_territory_segment10 ,t6.segment11 cm_bill_territory_segment11 ,t6.segment12 cm_bill_territory_segment12 ,t6.segment13 cm_bill_territory_segment13 ,t6.segment14 cm_bill_territory_segment14 ,t6.segment15 cm_bill_territory_segment15 ,t6.segment16 cm_bill_territory_segment16 ,t6.segment17 cm_bill_territory_segment17 ,t6.segment18 cm_bill_territory_segment18 ,t6.segment19 cm_bill_territory_segment19 ,t6.segment3 cm_bill_territory_segment2 ,t6.segment19 cm_bill_territory_segment20 ,t6.segment3 cm_bill_territory_segment3 ,t6.segment4 cm_bill_territory_segment4 ,t6.segment5 cm_bill_territory_segment5 ,t6.segment6 cm_bill_territory_segment6 ,t6.segment7 cm_bill_territory_segment7 ,t6.segment8 cm_bill_territory_segment8 ,t6.segment9 cm_bill_territory_segment9 ,t6.territory_id cm_bill_territory_id ,casa7.party_site_id CM_BILL_SITE_PARTY_SITE_ID ,he.ledger_id ledger_id ,he.event_id event_id FROM hz_cust_site_uses_all csua6 ,hz_cust_acct_sites_all casa7 ,ra_territories t6 ,ar_xla_lines_extract he WHERE csua6.site_use_id = he.bill_site_use_id AND he.level_flag = 'H' AND csua6.cust_acct_site_id = casa7.cust_acct_site_id AND csua6.territory_id = t6.territory_id (+) AND he.event_type_code IN ( 'CM_CREATE' , 'CM_UPDATE')

View Text - HTML Formatted

SELECT /*+INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ CASA7.CUSTOMER_CATEGORY_CODE CM_BILL_SITE_CUST_CAT_CODE
, CASA7.CUST_ACCT_SITE_ID CM_BILL_SITE_CUST_ACCT_SITE_ID
, CASA7.GLOBAL_ATTRIBUTE1 CM_BILL_SITE_GLOBAL_ATTR1
, CASA7.GLOBAL_ATTRIBUTE2 CM_BILL_SITE_GLOBAL_ATTR2
, CASA7.GLOBAL_ATTRIBUTE3 CM_BILL_SITE_GLOBAL_ATTR3
, CASA7.GLOBAL_ATTRIBUTE4 CM_BILL_SITE_GLOBAL_ATTR4
, CASA7.GLOBAL_ATTRIBUTE5 CM_BILL_SITE_GLOBAL_ATTR5
, CASA7.GLOBAL_ATTRIBUTE6 CM_BILL_SITE_GLOBAL_ATTR6
, CASA7.GLOBAL_ATTRIBUTE7 CM_BILL_SITE_GLOBAL_ATTR7
, CASA7.GLOBAL_ATTRIBUTE8 CM_BILL_SITE_GLOBAL_ATTR8
, CASA7.GLOBAL_ATTRIBUTE9 CM_BILL_SITE_GLOBAL_ATTR9
, CASA7.GLOBAL_ATTRIBUTE_CATEGORY CM_BILL_SITE_GLOBAL_ATTR_CAT
, CASA7.TRANSLATED_CUSTOMER_NAME CM_BILL_SITE_TRNSL_CUST_NAME
, CSUA6.GLOBAL_ATTRIBUTE1 CM_BILL_USES_GLOBAL_ATTR1
, CSUA6.GLOBAL_ATTRIBUTE_CATEGORY CM_BILL_USES_GLOBAL_ATTR_CAT
, CSUA6.GL_ID_CLEARING CM_BILL_USES_CLEARING_CCID
, CSUA6.GL_ID_FACTOR CM_BILL_USES_FACTOR_CCID
, CSUA6.GL_ID_FREIGHT CM_BILL_USES_FREIGHT_CCID
, CSUA6.GL_ID_REC CM_BILL_USES_REC_CCID
, CSUA6.GL_ID_REMITTANCE CM_BILL_USES_REMITTANCE_CCID
, CSUA6.GL_ID_REV CM_BILL_USES_REV_CCID
, CSUA6.GL_ID_TAX CM_BILL_USES_TAX_CCID
, CSUA6.GL_ID_UNBILLED CM_BILL_USES_UNBILLED_CCID
, CSUA6.GL_ID_UNEARNED CM_BILL_USES_UNEARNED_CCID
, CSUA6.GSA_INDICATOR CM_BILL_USES_GSA_INDICATOR
, CSUA6.LOCATION CM_BILL_USES_LOCATION
, CSUA6.SITE_USE_CODE CM_BILL_USES_SITE_USE_CODE
, CSUA6.SITE_USE_ID CM_BILL_USES_SITE_USE_ID
, CSUA6.TAX_REFERENCE CM_BILL_USES_TAX_REFERENCE
, T6.DESCRIPTION CM_BILL_TERRITORY_DESCRIPTION
, T6.NAME CM_BILL_TERRITORY_NAME
, T6.SEGMENT1 CM_BILL_TERRITORY_SEGMENT1
, T6.SEGMENT10 CM_BILL_TERRITORY_SEGMENT10
, T6.SEGMENT11 CM_BILL_TERRITORY_SEGMENT11
, T6.SEGMENT12 CM_BILL_TERRITORY_SEGMENT12
, T6.SEGMENT13 CM_BILL_TERRITORY_SEGMENT13
, T6.SEGMENT14 CM_BILL_TERRITORY_SEGMENT14
, T6.SEGMENT15 CM_BILL_TERRITORY_SEGMENT15
, T6.SEGMENT16 CM_BILL_TERRITORY_SEGMENT16
, T6.SEGMENT17 CM_BILL_TERRITORY_SEGMENT17
, T6.SEGMENT18 CM_BILL_TERRITORY_SEGMENT18
, T6.SEGMENT19 CM_BILL_TERRITORY_SEGMENT19
, T6.SEGMENT3 CM_BILL_TERRITORY_SEGMENT2
, T6.SEGMENT19 CM_BILL_TERRITORY_SEGMENT20
, T6.SEGMENT3 CM_BILL_TERRITORY_SEGMENT3
, T6.SEGMENT4 CM_BILL_TERRITORY_SEGMENT4
, T6.SEGMENT5 CM_BILL_TERRITORY_SEGMENT5
, T6.SEGMENT6 CM_BILL_TERRITORY_SEGMENT6
, T6.SEGMENT7 CM_BILL_TERRITORY_SEGMENT7
, T6.SEGMENT8 CM_BILL_TERRITORY_SEGMENT8
, T6.SEGMENT9 CM_BILL_TERRITORY_SEGMENT9
, T6.TERRITORY_ID CM_BILL_TERRITORY_ID
, CASA7.PARTY_SITE_ID CM_BILL_SITE_PARTY_SITE_ID
, HE.LEDGER_ID LEDGER_ID
, HE.EVENT_ID EVENT_ID
FROM HZ_CUST_SITE_USES_ALL CSUA6
, HZ_CUST_ACCT_SITES_ALL CASA7
, RA_TERRITORIES T6
, AR_XLA_LINES_EXTRACT HE
WHERE CSUA6.SITE_USE_ID = HE.BILL_SITE_USE_ID
AND HE.LEVEL_FLAG = 'H'
AND CSUA6.CUST_ACCT_SITE_ID = CASA7.CUST_ACCT_SITE_ID
AND CSUA6.TERRITORY_ID = T6.TERRITORY_ID (+)
AND HE.EVENT_TYPE_CODE IN ( 'CM_CREATE'
, 'CM_UPDATE')