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_PYA_GL_V

Source

View Text - Preformatted


SELECT substr(fpt.source_module,1,80) WIP_BASIS, jeh2.je_category TRX_REASON_NAME, fpt.source_document_number BOM_DEPARTMENT_NAME, fpt.je_line_num RCV_SHIPMENT_HEADER_ID, substr(fts.treasury_symbol,1,30) ACCOUNTING_COMPLETE, flc.description WIP_FLOW_SCHEDULE_NUMBER, fts.expiration_date PA_PERIOD_DATE, jel.accounted_dr ACCOUNTED_DR, jel.accounted_cr ACCOUNTED_CR, jel.entered_dr ENTERED_DR, jel.entered_cr ENTERED_CR, jeb.name WIP_JOB_NAME, substr(jeh2.name,1,80) AR_ADJUSTMENT_TYPE, fpt.transaction_id UNIT_PRICE, fpt.transaction_history_id PRICE_OVERRIDE, fpt.set_of_books_id SET_OF_BOOKS_ID, jel.je_header_id JE_HEADER_ID, jel.je_line_num JE_LINE_NUM, jel.code_combination_id CODE_COMBINATION_ID, jeh1.currency_code CURRENCY_CODE, 8901 APPLICATION_ID FROM fv_pya_transaction_history fpt, fv_fund_parameters ffp, fv_treasury_symbols fts, fv_lookup_codes flc, gl_je_headers jeh1, gl_je_headers jeh2, gl_je_lines jel, gl_je_batches jeb WHERE to_char(fpt.transaction_id) = jel.reference_6 AND jeh1.je_source = 'PYA Transactions' AND jel.ledger_id = fpt.set_of_books_id AND jeh1.ledger_id = jel.ledger_id AND jeh1.je_header_id = jel.je_header_id AND jeh2.je_header_id = fpt.je_header_id AND jeh2.je_batch_id = fpt.je_batch_id AND jeh2.ledger_id = fpt.set_of_books_id AND ffp.fund_value = fpt.fund_value AND ffp.set_of_books_id = fpt.set_of_books_id AND ffp.treasury_symbol_id = fts.treasury_symbol_id AND jeb.je_batch_id = fpt.je_batch_id AND flc.lookup_type = 'FUND_TIME_FRAME' AND flc.lookup_code = fts.time_frame

View Text - HTML Formatted

SELECT SUBSTR(FPT.SOURCE_MODULE
, 1
, 80) WIP_BASIS
, JEH2.JE_CATEGORY TRX_REASON_NAME
, FPT.SOURCE_DOCUMENT_NUMBER BOM_DEPARTMENT_NAME
, FPT.JE_LINE_NUM RCV_SHIPMENT_HEADER_ID
, SUBSTR(FTS.TREASURY_SYMBOL
, 1
, 30) ACCOUNTING_COMPLETE
, FLC.DESCRIPTION WIP_FLOW_SCHEDULE_NUMBER
, FTS.EXPIRATION_DATE PA_PERIOD_DATE
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, JEB.NAME WIP_JOB_NAME
, SUBSTR(JEH2.NAME
, 1
, 80) AR_ADJUSTMENT_TYPE
, FPT.TRANSACTION_ID UNIT_PRICE
, FPT.TRANSACTION_HISTORY_ID PRICE_OVERRIDE
, FPT.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JEL.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEH1.CURRENCY_CODE CURRENCY_CODE
, 8901 APPLICATION_ID
FROM FV_PYA_TRANSACTION_HISTORY FPT
, FV_FUND_PARAMETERS FFP
, FV_TREASURY_SYMBOLS FTS
, FV_LOOKUP_CODES FLC
, GL_JE_HEADERS JEH1
, GL_JE_HEADERS JEH2
, GL_JE_LINES JEL
, GL_JE_BATCHES JEB
WHERE TO_CHAR(FPT.TRANSACTION_ID) = JEL.REFERENCE_6
AND JEH1.JE_SOURCE = 'PYA TRANSACTIONS'
AND JEL.LEDGER_ID = FPT.SET_OF_BOOKS_ID
AND JEH1.LEDGER_ID = JEL.LEDGER_ID
AND JEH1.JE_HEADER_ID = JEL.JE_HEADER_ID
AND JEH2.JE_HEADER_ID = FPT.JE_HEADER_ID
AND JEH2.JE_BATCH_ID = FPT.JE_BATCH_ID
AND JEH2.LEDGER_ID = FPT.SET_OF_BOOKS_ID
AND FFP.FUND_VALUE = FPT.FUND_VALUE
AND FFP.SET_OF_BOOKS_ID = FPT.SET_OF_BOOKS_ID
AND FFP.TREASURY_SYMBOL_ID = FTS.TREASURY_SYMBOL_ID
AND JEB.JE_BATCH_ID = FPT.JE_BATCH_ID
AND FLC.LOOKUP_TYPE = 'FUND_TIME_FRAME'
AND FLC.LOOKUP_CODE = FTS.TIME_FRAME