View: FV_PYA_GL_V

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

View Text

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

Columns