VIEW: APPS.AR_SOLD_TO_SITE_USES_S_V

Source

View Text - Preformatted

SELECT /*+INDEX (l ar_xla_lines_extract_n1)*/ casa4.customer_category_code sold_site_cust_cat_code ,casa4.cust_acct_site_id sold_site_cust_acct_site_id ,casa4.global_attribute1 sold_site_global_attr1 ,casa4.global_attribute2 sold_site_global_attr2 ,casa4.global_attribute3 sold_site_global_attr3 ,casa4.global_attribute4 sold_site_global_attr4 ,casa4.global_attribute5 sold_site_global_attr5 ,casa4.global_attribute6 sold_site_global_attr6 ,casa4.global_attribute7 sold_site_global_attr7 ,casa4.global_attribute8 sold_site_global_attr8 ,casa4.global_attribute9 sold_site_global_attr9 ,casa4.global_attribute_category sold_site_global_attr_cat ,casa4.translated_customer_name sold_site_trnsl_cust_name ,csua4.gsa_indicator sold_site_gsa_indicator ,csua4.location sold_site_location ,csua4.site_use_code sold_site_site_use_code ,csua4.site_use_id sold_site_site_use_id ,csua4.tax_reference sold_site_tax_reference ,t4.description sold_territory_description ,t4.name sold_territory_name ,t4.segment1 sold_territory_segment1 ,t4.segment10 sold_territory_segment10 ,t4.segment11 sold_territory_segment11 ,t4.segment12 sold_territory_segment12 ,t4.segment13 sold_territory_segment13 ,t4.segment14 sold_territory_segment14 ,t4.segment15 sold_territory_segment15 ,t4.segment16 sold_territory_segment16 ,t4.segment17 sold_territory_segment17 ,t4.segment18 sold_territory_segment18 ,t4.segment19 sold_territory_segment19 ,t4.segment2 sold_territory_segment2 ,t4.segment20 sold_territory_segment20 ,t4.segment3 sold_territory_segment3 ,t4.segment4 sold_territory_segment4 ,t4.segment5 sold_territory_segment5 ,t4.segment6 sold_territory_segment6 ,t4.segment7 sold_territory_segment7 ,t4.segment8 sold_territory_segment8 ,t4.segment9 sold_territory_segment9 ,t4.territory_id sold_territory_id ,csua4.global_attribute1 SOLD_USES_GLOBAL_ATTR1 ,csua4.global_attribute_category SOLD_USES_GLOBAL_ATTR_CAT ,csua4.gl_id_clearing SOLD_USES_CLEARING_CCID ,csua4.gl_id_factor SOLD_USES_FACTOR_CCID ,csua4.gl_id_freight SOLD_USES_FREIGHT_CCID ,csua4.gl_id_rec SOLD_USES_REC_CCID ,csua4.gl_id_remittance SOLD_USES_REMITTANCE_CCID ,csua4.gl_id_rev SOLD_USES_REV_CCID ,csua4.gl_id_tax SOLD_USES_TAX_CCID ,csua4.gl_id_unbilled SOLD_USES_UNBILLED_CCID ,csua4.gl_id_unearned SOLD_USES_UNEARNED_CCID ,csua4.gl_id_unpaid_rec SOLD_USES_UNPAID_REC_CCID ,csua4.gsa_indicator SOLD_USES_GSA_INDICATOR ,csua4.location SOLD_USES_LOCATION ,csua4.site_use_code SOLD_USES_SITE_USE_CODE ,csua4.site_use_id SOLD_USES_SITE_USE_ID ,csua4.tax_reference SOLD_USES_TAX_REFERENCE ,casa4.party_site_id SOLD_SITE_PARTY_SITE_ID ,l.event_id event_id ,l.line_number line_number ,l.ledger_id ledger_id FROM hz_cust_site_uses_all csua4 ,hz_cust_acct_sites_all casa4 ,ra_territories t4 ,ar_xla_lines_extract l WHERE csua4.site_use_id = l.sold_site_use_id AND csua4.cust_acct_site_id = casa4.cust_acct_site_id AND csua4.territory_id = t4.territory_id (+) AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))

View Text - HTML Formatted

SELECT /*+INDEX (L AR_XLA_LINES_EXTRACT_N1)*/ CASA4.CUSTOMER_CATEGORY_CODE SOLD_SITE_CUST_CAT_CODE
, CASA4.CUST_ACCT_SITE_ID SOLD_SITE_CUST_ACCT_SITE_ID
, CASA4.GLOBAL_ATTRIBUTE1 SOLD_SITE_GLOBAL_ATTR1
, CASA4.GLOBAL_ATTRIBUTE2 SOLD_SITE_GLOBAL_ATTR2
, CASA4.GLOBAL_ATTRIBUTE3 SOLD_SITE_GLOBAL_ATTR3
, CASA4.GLOBAL_ATTRIBUTE4 SOLD_SITE_GLOBAL_ATTR4
, CASA4.GLOBAL_ATTRIBUTE5 SOLD_SITE_GLOBAL_ATTR5
, CASA4.GLOBAL_ATTRIBUTE6 SOLD_SITE_GLOBAL_ATTR6
, CASA4.GLOBAL_ATTRIBUTE7 SOLD_SITE_GLOBAL_ATTR7
, CASA4.GLOBAL_ATTRIBUTE8 SOLD_SITE_GLOBAL_ATTR8
, CASA4.GLOBAL_ATTRIBUTE9 SOLD_SITE_GLOBAL_ATTR9
, CASA4.GLOBAL_ATTRIBUTE_CATEGORY SOLD_SITE_GLOBAL_ATTR_CAT
, CASA4.TRANSLATED_CUSTOMER_NAME SOLD_SITE_TRNSL_CUST_NAME
, CSUA4.GSA_INDICATOR SOLD_SITE_GSA_INDICATOR
, CSUA4.LOCATION SOLD_SITE_LOCATION
, CSUA4.SITE_USE_CODE SOLD_SITE_SITE_USE_CODE
, CSUA4.SITE_USE_ID SOLD_SITE_SITE_USE_ID
, CSUA4.TAX_REFERENCE SOLD_SITE_TAX_REFERENCE
, T4.DESCRIPTION SOLD_TERRITORY_DESCRIPTION
, T4.NAME SOLD_TERRITORY_NAME
, T4.SEGMENT1 SOLD_TERRITORY_SEGMENT1
, T4.SEGMENT10 SOLD_TERRITORY_SEGMENT10
, T4.SEGMENT11 SOLD_TERRITORY_SEGMENT11
, T4.SEGMENT12 SOLD_TERRITORY_SEGMENT12
, T4.SEGMENT13 SOLD_TERRITORY_SEGMENT13
, T4.SEGMENT14 SOLD_TERRITORY_SEGMENT14
, T4.SEGMENT15 SOLD_TERRITORY_SEGMENT15
, T4.SEGMENT16 SOLD_TERRITORY_SEGMENT16
, T4.SEGMENT17 SOLD_TERRITORY_SEGMENT17
, T4.SEGMENT18 SOLD_TERRITORY_SEGMENT18
, T4.SEGMENT19 SOLD_TERRITORY_SEGMENT19
, T4.SEGMENT2 SOLD_TERRITORY_SEGMENT2
, T4.SEGMENT20 SOLD_TERRITORY_SEGMENT20
, T4.SEGMENT3 SOLD_TERRITORY_SEGMENT3
, T4.SEGMENT4 SOLD_TERRITORY_SEGMENT4
, T4.SEGMENT5 SOLD_TERRITORY_SEGMENT5
, T4.SEGMENT6 SOLD_TERRITORY_SEGMENT6
, T4.SEGMENT7 SOLD_TERRITORY_SEGMENT7
, T4.SEGMENT8 SOLD_TERRITORY_SEGMENT8
, T4.SEGMENT9 SOLD_TERRITORY_SEGMENT9
, T4.TERRITORY_ID SOLD_TERRITORY_ID
, CSUA4.GLOBAL_ATTRIBUTE1 SOLD_USES_GLOBAL_ATTR1
, CSUA4.GLOBAL_ATTRIBUTE_CATEGORY SOLD_USES_GLOBAL_ATTR_CAT
, CSUA4.GL_ID_CLEARING SOLD_USES_CLEARING_CCID
, CSUA4.GL_ID_FACTOR SOLD_USES_FACTOR_CCID
, CSUA4.GL_ID_FREIGHT SOLD_USES_FREIGHT_CCID
, CSUA4.GL_ID_REC SOLD_USES_REC_CCID
, CSUA4.GL_ID_REMITTANCE SOLD_USES_REMITTANCE_CCID
, CSUA4.GL_ID_REV SOLD_USES_REV_CCID
, CSUA4.GL_ID_TAX SOLD_USES_TAX_CCID
, CSUA4.GL_ID_UNBILLED SOLD_USES_UNBILLED_CCID
, CSUA4.GL_ID_UNEARNED SOLD_USES_UNEARNED_CCID
, CSUA4.GL_ID_UNPAID_REC SOLD_USES_UNPAID_REC_CCID
, CSUA4.GSA_INDICATOR SOLD_USES_GSA_INDICATOR
, CSUA4.LOCATION SOLD_USES_LOCATION
, CSUA4.SITE_USE_CODE SOLD_USES_SITE_USE_CODE
, CSUA4.SITE_USE_ID SOLD_USES_SITE_USE_ID
, CSUA4.TAX_REFERENCE SOLD_USES_TAX_REFERENCE
, CASA4.PARTY_SITE_ID SOLD_SITE_PARTY_SITE_ID
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, L.LEDGER_ID LEDGER_ID
FROM HZ_CUST_SITE_USES_ALL CSUA4
, HZ_CUST_ACCT_SITES_ALL CASA4
, RA_TERRITORIES T4
, AR_XLA_LINES_EXTRACT L
WHERE CSUA4.SITE_USE_ID = L.SOLD_SITE_USE_ID
AND CSUA4.CUST_ACCT_SITE_ID = CASA4.CUST_ACCT_SITE_ID
AND CSUA4.TERRITORY_ID = T4.TERRITORY_ID (+)
AND ((L.EVENT_CLASS_CODE IN ('INVOICE'
, 'DEBIT_MEMO'
, 'DEPOSIT'
, 'GUARANTEE'
, 'CHARGEBACK'
, 'ADJUSTMENT')
AND L.LEVEL_FLAG = 'H') OR (L.EVENT_CLASS_CODE IN ('CREDIT_MEMO'
, 'RECEIPT')
AND L.LEVEL_FLAG = 'L'
AND L.FROM_TO_FLAG = 'T'))