View: FV_LINK_GL_TO_TREAS_CONFIRM_V

View Text

SELECT V.VENDOR_ID VENDOR_ID
, V.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE
, DECODE (FSP.FACTSI_VENDOR_ATTRIBUTE
, 'ATTRIBUTE1'
, V.ATTRIBUTE1
, 'ATTRIBUTE2'
, V.ATTRIBUTE2
, 'ATTRIBUTE3'
, V.ATTRIBUTE3
, 'ATTRIBUTE4'
, V.ATTRIBUTE4
, 'ATTRIBUTE5'
, V.ATTRIBUTE5
, 'ATTRIBUTE6'
, V.ATTRIBUTE6
, 'ATTRIBUTE7'
, V.ATTRIBUTE7
, 'ATTRIBUTE8'
, V.ATTRIBUTE8
, 'ATTRIBUTE9'
, V.ATTRIBUTE9
, 'ATTRIBUTE10'
, V.ATTRIBUTE10
, 'ATTRIBUTE11'
, V.ATTRIBUTE11
, 'ATTRIBUTE12'
, V.ATTRIBUTE12
, 'ATTRIBUTE13'
, V.ATTRIBUTE13
, 'ATTRIBUTE14'
, V.ATTRIBUTE14
, 'ATTRIBUTE15'
, V.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 GL_JE_LINES GJL
, GL_JE_HEADERS GJH
, AP_CHECKS_ALL APC
, PO_VENDORS V
, FV_SYSTEM_PARAMETERS FSP
, GL_PERIODS GLP
, GL_CODE_COMBINATIONS GLC
WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
AND GJH.JE_SOURCE = 'PAYABLES'
AND GJH.JE_CATEGORY = 'TREASURY CONFIRMATION'
AND APC.VENDOR_ID = V.VENDOR_ID
AND GJL.REFERENCE_3 = TO_CHAR(APC.CHECK_ID)
AND GJL.REFERENCE_3 IS NOT NULL
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