eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FV_TC_GL_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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