View: FV_LINK_GL_TO_INVOICES_V

View Text

SELECT V.VENDOR_ID VENDOR_ID
, V.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE
, V.ATTRIBUTE9 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 PO_HEADERS_ALL PH
, PO_DISTRIBUTIONS_ALL PD
, AP_INVOICES_ALL I
, AP_INVOICE_DISTRIBUTIONS_ALL D
, GL_PERIODS GLP
, GL_CODE_COMBINATIONS GLC
, GL_JE_HEADERS GJH
, GL_JE_LINES GJL
, PO_VENDORS V
, AP_LOOKUP_CODES L
, GL_LOOKUPS L2
WHERE L2.LOOKUP_TYPE = 'SUBLDGR_DRILLDOWN_TRANS_TYPE'
AND L2.LOOKUP_CODE = NVL(GJL.REFERENCE_10
, 'EXPENSE')
AND L.LOOKUP_CODE = D.LINE_TYPE_LOOKUP_CODE
AND L.LOOKUP_TYPE = 'INVOICE DISTRIBUTION TYPE'
AND PH.PO_HEADER_ID(+) = PD.PO_HEADER_ID
AND PD.PO_DISTRIBUTION_ID(+) = D.PO_DISTRIBUTION_ID
AND I.INVOICE_ID = D.INVOICE_ID
AND I.VENDOR_ID = V.VENDOR_ID
AND D.POSTED_FLAG = 'Y'
AND TO_CHAR(D.DISTRIBUTION_LINE_NUMBER) = GJL.REFERENCE_3
AND TO_CHAR( I.INVOICE_ID) = GJL.REFERENCE_2
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
AND GJH.JE_SOURCE = 'PAYABLES'

Columns