View: AR_SHIP_TO_SITE_USES_S_V

Product:	AR - Receivables
Description:	ship to site shared extract
Implementation/DBA Data:	APPS.AR_SHIP_TO_SITE_USES_S_V

View Text

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'))

Columns