[Home] [Help]
View: AR_AGREEMENTS_S_VL
Product: | AR - Receivables |
Description: | agreement shared mls extract |
Implementation/DBA Data: |
APPS.AR_AGREEMENTS_S_VL
|
View Text
SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1)*/ SOATLF.NAME AGREEMENT_NAME
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, SOATLF.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM SO_AGREEMENTS_TL SOATLF
, AR_XLA_LINES_EXTRACT L
WHERE SOATLF.AGREEMENT_ID = L.AGREEMENT_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
Name |
AGREEMENT_NAME |
EVENT_ID |
LINE_NUMBER |
LANGUAGE |
LEDGER_ID |