[Home] [Help]
View: ARFV_UNREV_DISTS_ALC_V
Product: | AR - Receivables |
Description: | This shows Alternate Currencies information about unearned revenue amounts transferred to the Subledger Accounting. |
Implementation/DBA Data: |
APPS.ARFV_UNREV_DISTS_ALC_V
|
View Text
SELECT ROUND(LNK.UNROUNDED_ACCOUNTED_DR/NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, (-1*CUR.PRECISION))) )* NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, (-1*CUR.PRECISION))) ACCOUNTED_DR
, ROUND(LNK.UNROUNDED_ACCOUNTED_CR/NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, (-1*CUR.PRECISION))) )* NVL(CUR.MINIMUM_ACCOUNTABLE_UNIT
, POWER(10
, (-1*CUR.PRECISION))) ACCOUNTED_CR
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, LG.NAME
, CT.TRX_NUMBER
, CTLD.CUST_TRX_LINE_GL_DIST_ID
, LG.LEDGER_ID
, CTLD.CUSTOMER_TRX_ID FROM FND_CURRENCIES CUR
, GL_LEDGERS_PUBLIC_V LG
, XLA_AE_HEADERS HED
, XLA_AE_LINES LIN
, XLA_DISTRIBUTION_LINKS LNK
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLD
, RA_CUSTOMER_TRX_ALL CT
WHERE CUR.CURRENCY_CODE = LG.CURRENCY_CODE
AND LG.LEDGER_CATEGORY_CODE = 'ALC'
AND LG.LEDGER_ID = HED.LEDGER_ID
AND HED.APPLICATION_ID = 222
AND HED.AE_HEADER_ID = LNK.AE_HEADER_ID
AND LIN.APPLICATION_ID = 222
AND DECODE(LIN.ACCOUNTING_CLASS_CODE
, 'UNEARNED_REVENUE'
, 'UNEARN'
, LIN.ACCOUNTING_CLASS_CODE) = CTLD.ACCOUNT_CLASS
AND LIN.AE_HEADER_ID = LNK.AE_HEADER_ID
AND LIN.AE_LINE_NUM = LNK.AE_LINE_NUM
AND LNK.APPLICATION_ID = 222 /* FILTER OUT REVERSAL LINKS */
AND LNK.AE_HEADER_ID = LNK.REF_AE_HEADER_ID /* FILTER OUT LINKS BEING REVERSED BY ANOTHER LINK */
AND NOT EXISTS (SELECT 'REVERSED'
FROM XLA_DISTRIBUTION_LINKS LNK2
WHERE LNK2.APPLICATION_ID = 222
AND LNK2.REF_AE_HEADER_ID = LNK.AE_HEADER_ID
AND LNK2.REF_TEMP_LINE_NUM = LNK.TEMP_LINE_NUM)
AND LNK.SOURCE_DISTRIBUTION_TYPE = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = CTLD.CUST_TRX_LINE_GL_DIST_ID
AND CTLD.ACCOUNT_CLASS = 'UNEARN'
AND CTLD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID WITH READ ONLY
Columns
Name |
FUNCTIONAL_DEBIT_AMOUNT |
FUNCTIONAL_CREDIT_AMOUNT |
"_LA:POSTED_FLAG" |
LEDGER_NAME |
TRANSACTION_NUMBER |
CUST_TRX_LINE_GL_DIST_ID |
LEDGER_ID |
CUSTOMER_TRX_ID |