[Home] [Help]
View: FV_LINK_GL_TO_AR_REC_APPS_V
| Product: | FV - Federal Financials |
|---|
| Description: | Links General Ledger to Receivables receivable applications |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT C.CUSTOMER_ID VENDOR_ID
, C.CUSTOMER_CLASS_CODE VENDOR_TYPE
, DECODE (FSP.FACTSI_CUSTOMER_ATTRIBUTE
, 'ATTRIBUTE1'
, C.ATTRIBUTE1
, 'ATTRIBUTE2'
, C.ATTRIBUTE2
, 'ATTRIBUTE3'
, C.ATTRIBUTE3
, 'ATTRIBUTE4'
, C.ATTRIBUTE4
, 'ATTRIBUTE5'
, C.ATTRIBUTE5
, 'ATTRIBUTE6'
, C.ATTRIBUTE6
, 'ATTRIBUTE7'
, C.ATTRIBUTE7
, 'ATTRIBUTE8'
, C.ATTRIBUTE8
, 'ATTRIBUTE9'
, C.ATTRIBUTE9
, 'ATTRIBUTE10'
, C.ATTRIBUTE10
, 'ATTRIBUTE11'
, C.ATTRIBUTE11
, 'ATTRIBUTE12'
, C.ATTRIBUTE12
, 'ATTRIBUTE13'
, C.ATTRIBUTE13
, 'ATTRIBUTE14'
, C.ATTRIBUTE14
, 'ATTRIBUTE15'
, C.ATTRIBUTE15) ELIMINATIONS_ID
, GJL.ENTERED_DR ENTERED_DR
, GJL.ENTERED_CR ENTERED_CR
, GJL.CODE_COMBINATION_ID CCID
, GJL.SET_OF_BOOKS_ID SOB
, GLC.CHART_OF_ACCOUNTS_ID COA
, GLP.PERIOD_YEAR
, GLP.PERIOD_NUM
FROM AR_LOOKUPS L1
, AR_LOOKUPS L2
, RA_CUSTOMERS C
, FV_SYSTEM_PARAMETERS FSP
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
, RA_CUSTOMER_TRX_ALL CT
, RA_CUSTOMER_TRX_ALL CT_APP
, RA_CUSTOMER_TRX_LINES_ALL CT_APP_LINES
, AR_CASH_RECEIPTS_ALL CR
, AR_RECEIVABLE_APPLICATIONS_ALL RA
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, GL_PERIODS GLP
, GL_CODE_COMBINATIONS GLC
WHERE L1.LOOKUP_CODE (+) = RA.APPLICATION_TYPE
AND L1.LOOKUP_TYPE (+) = 'APPLICATION_TYPE'
AND L2.LOOKUP_CODE(+) = CT_APP_LINES.LINE_TYPE
AND L2.LOOKUP_TYPE(+) = 'STD_LINE_TYPE'
AND RA.CUSTOMER_TRX_ID = CTLGD.CUSTOMER_TRX_ID(+)
AND DECODE(RA.APPLICATION_TYPE
, 'CASH'
, 'REC'
, 'CM'
, CTLGD.ACCOUNT_CLASS) = 'REC'
AND DECODE(RA.APPLICATION_TYPE
, 'CASH'
, 'Y'
, 'CM'
, CTLGD.LATEST_REC_FLAG) = 'Y'
AND CT_APP_LINES.CUSTOMER_TRX_LINE_ID(+) = RA.APPLIED_CUSTOMER_TRX_LINE_ID
AND CT_APP.CUSTOMER_TRX_ID(+) = RA.APPLIED_CUSTOMER_TRX_ID
AND CT.CUSTOMER_TRX_ID(+) = RA.CUSTOMER_TRX_ID
AND TO_CHAR(C.CUSTOMER_ID(+)) = GJL.REFERENCE_7
AND CR.CASH_RECEIPT_ID(+) = RA.CASH_RECEIPT_ID
AND TO_CHAR(RA.RECEIVABLE_APPLICATION_ID) = GJL.REFERENCE_3
AND GJL.REFERENCE_10 = 'AR_RECEIVABLE_APPLICATIONS'
AND GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJH.ACTUAL_FLAG = 'A'
AND GJL.STATUS = 'P'
AND GJL.PERIOD_NAME = GLP.PERIOD_NAME
AND GJL.CODE_COMBINATION_ID = GLC.CODE_COMBINATION_ID
AND GLC.ACCOUNT_TYPE <> 'C'
AND GLC.ACCOUNT_TYPE <> 'D'
AND GLC.TEMPLATE_ID IS NULL
Columns