View: AR_PAY_SITE_USES_S_V

Product:	AR - Receivables
Description:	paying site shared extract
Implementation/DBA Data:	APPS.AR_PAY_SITE_USES_S_V

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ CASA3.CUST_ACCT_SITE_ID PAY_SITE_CUST_ACCT_SITE_ID
, CASA3.TRANSLATED_CUSTOMER_NAME PAY_SITE_TRNSL_CUST_NAME
, CSUA3.GSA_INDICATOR PAY_SITE_GSA_INDICATOR
, CSUA3.LOCATION PAY_SITE_LOCATION
, CSUA3.SITE_USE_CODE PAY_SITE_SITE_USE_CODE
, CSUA3.SITE_USE_ID PAY_SITE_SITE_USE_ID
, CSUA3.TAX_REFERENCE PAY_SITE_TAX_REFERENCE
, T3.DESCRIPTION PAY_TERRITORY_DESCRIPTION
, T3.NAME PAY_TERRITORY_NAME
, T3.SEGMENT1 PAY_TERRITORY_SEGMENT1
, T3.SEGMENT10 PAY_TERRITORY_SEGMENT10
, T3.SEGMENT11 PAY_TERRITORY_SEGMENT11
, T3.SEGMENT12 PAY_TERRITORY_SEGMENT12
, T3.SEGMENT13 PAY_TERRITORY_SEGMENT13
, T3.SEGMENT14 PAY_TERRITORY_SEGMENT14
, T3.SEGMENT15 PAY_TERRITORY_SEGMENT15
, T3.SEGMENT16 PAY_TERRITORY_SEGMENT16
, T3.SEGMENT17 PAY_TERRITORY_SEGMENT17
, T3.SEGMENT18 PAY_TERRITORY_SEGMENT18
, T3.SEGMENT19 PAY_TERRITORY_SEGMENT19
, T3.SEGMENT2 PAY_TERRITORY_SEGMENT2
, T3.SEGMENT20 PAY_TERRITORY_SEGMENT20
, T3.SEGMENT3 PAY_TERRITORY_SEGMENT3
, T3.SEGMENT4 PAY_TERRITORY_SEGMENT4
, T3.SEGMENT5 PAY_TERRITORY_SEGMENT5
, T3.SEGMENT6 PAY_TERRITORY_SEGMENT6
, T3.SEGMENT7 PAY_TERRITORY_SEGMENT7
, T3.SEGMENT8 PAY_TERRITORY_SEGMENT8
, T3.SEGMENT9 PAY_TERRITORY_SEGMENT9
, T3.TERRITORY_ID PAY_TERRITORY_ID
, CASA3.CUSTOMER_CATEGORY_CODE PAY_SITE_CUST_CAT_CODE
, CASA3.GLOBAL_ATTRIBUTE1 PAY_SITE_GLOBAL_ATTR1
, CASA3.GLOBAL_ATTRIBUTE2 PAY_SITE_GLOBAL_ATTR2
, CASA3.GLOBAL_ATTRIBUTE3 PAY_SITE_GLOBAL_ATTR3
, CASA3.GLOBAL_ATTRIBUTE4 PAY_SITE_GLOBAL_ATTR4
, CASA3.GLOBAL_ATTRIBUTE5 PAY_SITE_GLOBAL_ATTR5
, CASA3.GLOBAL_ATTRIBUTE6 PAY_SITE_GLOBAL_ATTR6
, CASA3.GLOBAL_ATTRIBUTE7 PAY_SITE_GLOBAL_ATTR7
, CASA3.GLOBAL_ATTRIBUTE8 PAY_SITE_GLOBAL_ATTR8
, CASA3.GLOBAL_ATTRIBUTE9 PAY_SITE_GLOBAL_ATTR9
, CASA3.GLOBAL_ATTRIBUTE_CATEGORY PAY_SITE_GLOBAL_ATTR_CAT
, CASA3.PARTY_SITE_ID PAY_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 CSUA3
, HZ_CUST_ACCT_SITES_ALL CASA3
, RA_TERRITORIES T3
, AR_XLA_LINES_EXTRACT L
WHERE CSUA3.SITE_USE_ID = L.PAYING_SITE_USE_ID
AND CSUA3.CUST_ACCT_SITE_ID = CASA3.CUST_ACCT_SITE_ID
AND CSUA3.TERRITORY_ID = T3.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