eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_SHIP_TO_SITE_USES_S_V

Source

View Text - Preformatted


SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ casa5.customer_category_code ship_site_cust_cat_code ,casa5.cust_acct_site_id ship_site_cust_acct_site_id ,casa5.global_attribute1 ship_site_global_attr1 ,casa5.global_attribute2 ship_site_global_attr2 ,casa5.global_attribute3 ship_site_global_attr3 ,casa5.global_attribute4 ship_site_global_attr4 ,casa5.global_attribute5 ship_site_global_attr5 ,casa5.global_attribute6 ship_site_global_attr6 ,casa5.global_attribute7 ship_site_global_attr7 ,casa5.global_attribute8 ship_site_global_attr8 ,casa5.global_attribute9 ship_site_global_attr9 ,casa5.global_attribute_category ship_site_global_attr_cat ,casa5.translated_customer_name ship_site_trnsl_cust_name ,csua5.gsa_indicator ship_site_gsa_indicator ,csua5.location ship_site_location ,csua5.site_use_code ship_site_site_use_code ,csua5.site_use_id ship_site_site_use_id ,csua5.tax_reference ship_site_tax_reference ,t5.description ship_territory_description ,t5.name ship_territory_name ,t5.segment1 ship_territory_segment1 ,t5.segment10 ship_territory_segment10 ,t5.segment11 ship_territory_segment11 ,t5.segment12 ship_territory_segment12 ,t5.segment13 ship_territory_segment13 ,t5.segment14 ship_territory_segment14 ,t5.segment15 ship_territory_segment15 ,t5.segment16 ship_territory_segment16 ,t5.segment17 ship_territory_segment17 ,t5.segment18 ship_territory_segment18 ,t5.segment19 ship_territory_segment19 ,t5.segment2 ship_territory_segment2 ,t5.segment20 ship_territory_segment20 ,t5.segment3 ship_territory_segment3 ,t5.segment4 ship_territory_segment4 ,t5.segment5 ship_territory_segment5 ,t5.segment6 ship_territory_segment6 ,t5.segment7 ship_territory_segment7 ,t5.segment8 ship_territory_segment8 ,t5.segment9 ship_territory_segment9 ,t5.territory_id ship_territory_id ,csua5.global_attribute1 SHIP_USES_GLOBAL_ATTR1 ,csua5.global_attribute_category SHIP_USES_GLOBAL_ATTR_CAT ,csua5.gl_id_clearing SHIP_USES_CLEARING_CCID ,csua5.gl_id_factor SHIP_USES_FACTOR_CCID ,csua5.gl_id_freight SHIP_USES_FREIGHT_CCID ,csua5.gl_id_rec SHIP_USES_REC_CCID ,csua5.gl_id_remittance SHIP_USES_REMITTANCE_CCID ,csua5.gl_id_rev SHIP_USES_REV_CCID ,csua5.gl_id_tax SHIP_USES_TAX_CCID ,csua5.gl_id_unbilled SHIP_USES_UNBILLED_CCID ,csua5.gl_id_unearned SHIP_USES_UNEARNED_CCID ,csua5.gl_id_unpaid_rec SHIP_USES_UNPAID_REC_CCID ,csua5.gsa_indicator SHIP_USES_GSA_INDICATOR ,csua5.location SHIP_USES_LOCATION ,csua5.site_use_code SHIP_USES_SITE_USE_CODE ,csua5.site_use_id SHIP_USES_SITE_USE_ID ,csua5.tax_reference SHIP_USES_TAX_REFERENCE ,casa5.party_site_id SHIP_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 csua5 ,hz_cust_acct_sites_all casa5 ,ra_territories t5 ,ar_xla_lines_extract l WHERE csua5.site_use_id = l.ship_site_use_id AND csua5.cust_acct_site_id = casa5.cust_acct_site_id AND csua5.territory_id = t5.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)*/ CASA5.CUSTOMER_CATEGORY_CODE SHIP_SITE_CUST_CAT_CODE
, CASA5.CUST_ACCT_SITE_ID SHIP_SITE_CUST_ACCT_SITE_ID
, CASA5.GLOBAL_ATTRIBUTE1 SHIP_SITE_GLOBAL_ATTR1
, CASA5.GLOBAL_ATTRIBUTE2 SHIP_SITE_GLOBAL_ATTR2
, CASA5.GLOBAL_ATTRIBUTE3 SHIP_SITE_GLOBAL_ATTR3
, CASA5.GLOBAL_ATTRIBUTE4 SHIP_SITE_GLOBAL_ATTR4
, CASA5.GLOBAL_ATTRIBUTE5 SHIP_SITE_GLOBAL_ATTR5
, CASA5.GLOBAL_ATTRIBUTE6 SHIP_SITE_GLOBAL_ATTR6
, CASA5.GLOBAL_ATTRIBUTE7 SHIP_SITE_GLOBAL_ATTR7
, CASA5.GLOBAL_ATTRIBUTE8 SHIP_SITE_GLOBAL_ATTR8
, CASA5.GLOBAL_ATTRIBUTE9 SHIP_SITE_GLOBAL_ATTR9
, CASA5.GLOBAL_ATTRIBUTE_CATEGORY SHIP_SITE_GLOBAL_ATTR_CAT
, CASA5.TRANSLATED_CUSTOMER_NAME SHIP_SITE_TRNSL_CUST_NAME
, CSUA5.GSA_INDICATOR SHIP_SITE_GSA_INDICATOR
, CSUA5.LOCATION SHIP_SITE_LOCATION
, CSUA5.SITE_USE_CODE SHIP_SITE_SITE_USE_CODE
, CSUA5.SITE_USE_ID SHIP_SITE_SITE_USE_ID
, CSUA5.TAX_REFERENCE SHIP_SITE_TAX_REFERENCE
, T5.DESCRIPTION SHIP_TERRITORY_DESCRIPTION
, T5.NAME SHIP_TERRITORY_NAME
, T5.SEGMENT1 SHIP_TERRITORY_SEGMENT1
, T5.SEGMENT10 SHIP_TERRITORY_SEGMENT10
, T5.SEGMENT11 SHIP_TERRITORY_SEGMENT11
, T5.SEGMENT12 SHIP_TERRITORY_SEGMENT12
, T5.SEGMENT13 SHIP_TERRITORY_SEGMENT13
, T5.SEGMENT14 SHIP_TERRITORY_SEGMENT14
, T5.SEGMENT15 SHIP_TERRITORY_SEGMENT15
, T5.SEGMENT16 SHIP_TERRITORY_SEGMENT16
, T5.SEGMENT17 SHIP_TERRITORY_SEGMENT17
, T5.SEGMENT18 SHIP_TERRITORY_SEGMENT18
, T5.SEGMENT19 SHIP_TERRITORY_SEGMENT19
, T5.SEGMENT2 SHIP_TERRITORY_SEGMENT2
, T5.SEGMENT20 SHIP_TERRITORY_SEGMENT20
, T5.SEGMENT3 SHIP_TERRITORY_SEGMENT3
, T5.SEGMENT4 SHIP_TERRITORY_SEGMENT4
, T5.SEGMENT5 SHIP_TERRITORY_SEGMENT5
, T5.SEGMENT6 SHIP_TERRITORY_SEGMENT6
, T5.SEGMENT7 SHIP_TERRITORY_SEGMENT7
, T5.SEGMENT8 SHIP_TERRITORY_SEGMENT8
, T5.SEGMENT9 SHIP_TERRITORY_SEGMENT9
, T5.TERRITORY_ID SHIP_TERRITORY_ID
, CSUA5.GLOBAL_ATTRIBUTE1 SHIP_USES_GLOBAL_ATTR1
, CSUA5.GLOBAL_ATTRIBUTE_CATEGORY SHIP_USES_GLOBAL_ATTR_CAT
, CSUA5.GL_ID_CLEARING SHIP_USES_CLEARING_CCID
, CSUA5.GL_ID_FACTOR SHIP_USES_FACTOR_CCID
, CSUA5.GL_ID_FREIGHT SHIP_USES_FREIGHT_CCID
, CSUA5.GL_ID_REC SHIP_USES_REC_CCID
, CSUA5.GL_ID_REMITTANCE SHIP_USES_REMITTANCE_CCID
, CSUA5.GL_ID_REV SHIP_USES_REV_CCID
, CSUA5.GL_ID_TAX SHIP_USES_TAX_CCID
, CSUA5.GL_ID_UNBILLED SHIP_USES_UNBILLED_CCID
, CSUA5.GL_ID_UNEARNED SHIP_USES_UNEARNED_CCID
, CSUA5.GL_ID_UNPAID_REC SHIP_USES_UNPAID_REC_CCID
, CSUA5.GSA_INDICATOR SHIP_USES_GSA_INDICATOR
, CSUA5.LOCATION SHIP_USES_LOCATION
, CSUA5.SITE_USE_CODE SHIP_USES_SITE_USE_CODE
, CSUA5.SITE_USE_ID SHIP_USES_SITE_USE_ID
, CSUA5.TAX_REFERENCE SHIP_USES_TAX_REFERENCE
, CASA5.PARTY_SITE_ID SHIP_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 CSUA5
, HZ_CUST_ACCT_SITES_ALL CASA5
, RA_TERRITORIES T5
, AR_XLA_LINES_EXTRACT L
WHERE CSUA5.SITE_USE_ID = L.SHIP_SITE_USE_ID
AND CSUA5.CUST_ACCT_SITE_ID = CASA5.CUST_ACCT_SITE_ID
AND CSUA5.TERRITORY_ID = T5.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'))