View: FV_TC_GL_V

Product:	FV - Federal Financials
Description:
Implementation/DBA Data:	APPS.FV_TC_GL_V

View Text

SELECT DECODE(FTC.CONFIRMATION_STATUS_FLAG
, 'B'
, TO_NUMBER(NULL)
, APC.TREASURY_PAY_NUMBER) APPLIED_TO_TRX_LINE_NUMBER
, FTC.TREASURY_DOC_DATE PAYMENT_DEPOSIT_DATE
, APC.VENDOR_NAME WIP_JOB_NAME
, FTC.CHECKRUN_NAME WIP_FLOW_SCHEDULE_NUMBER
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, APC.CHECK_NUMBER APPLIED_TO_TRX_HDR_ID
, APC.CHECK_DATE PA_ACCRUE_THRU_DATE
, FTC.TREASURY_CONFIRMATION_ID WIP_JOB_ID
, APC.CHECK_ID WIP_LINE_ID
, JEL.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, FTC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JEH.CURRENCY_CODE CURRENCY_CODE
, 8901 APPLICATION_ID
, FTC.ORG_ID ORG_ID
FROM FV_TREASURY_CONFIRMATIONS_ALL FTC
, GL_JE_LINES JEL
, GL_JE_HEADERS JEH
, AP_CHECKS_ALL APC
WHERE TO_CHAR(FTC.TREASURY_CONFIRMATION_ID) = JEL.REFERENCE_1
AND FTC.SET_OF_BOOKS_ID = JEL.LEDGER_ID
AND JEH.JE_SOURCE = 'PAYABLES'
AND JEH.JE_CATEGORY = 'TREASURY CONFIRMATION'
AND JEH.JE_HEADER_ID = JEL.JE_HEADER_ID
AND JEH.LEDGER_ID = JEL.LEDGER_ID
AND APC.CHECKRUN_NAME = FTC.CHECKRUN_NAME
AND APC.CHECK_ID = JEL.REFERENCE_3
AND APC.ORG_ID = FTC.ORG_ID

Columns