View: AR_SOLD_TO_SITE_USES_S_V

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

View Text

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

Columns