View: POFV_MC_RECEIVING_SUBLEDGERS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_MC_RECEIVING_SUBLEDGERS

View Text

SELECT SL.ACCOUNTING_DATE
, SL.PERIOD_NAME
, '_LA:SL.ACTUAL_FLAG:GL_LOOKUPS:GL_DSS_BALANCE_TYPE:MEANING'
, SL.ACCOUNTED_CR
, SL.ACCOUNTED_DR
, SL.CURRENCY_CONVERSION_RATE
, SL.CURRENCY_CONVERSION_DATE
, SL.ENTERED_CR
, SL.ENTERED_DR
, SL.DATE_CREATED_IN_GL
, SL.JE_CATEGORY_NAME
, SL.JE_BATCH_DESCRIPTION
, SL.JE_BATCH_NAME
, SL.JE_HEADER_NAME
, SL.JE_LINE_DESCRIPTION
, SL.JE_SOURCE_NAME
, SL.REVERSAL_PERIOD_NAME
, '_LA:SL.REVERSE_JOURNAL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.SOURCE_DOC_QUANTITY
, SL.TRANSACTION_DATE
, SL.USSGL_TRANSACTION_CODE
, '_DF:PO:RCV_RECEIVING_SUB_LEDGER:SL'
, SL.RCV_TRANSACTION_ID
, '_LA:RT.TRANSACTION_TYPE:PO_LOOKUP_CODES:RCV TRANSACTION TYPE:DISPLAYED_FIELD'
, RT.SHIPMENT_HEADER_ID
, HR.SHIPMENT_NUM
, RT.SHIPMENT_LINE_ID
, LI.LINE_NUM
, SL.CURRENCY_CODE
, CU.NAME
, SL.USER_CURRENCY_CONVERSION_TYPE
, RA.USER_CONVERSION_TYPE
, RA.DESCRIPTION
, SL.FUNCTIONAL_CURRENCY_CODE
, FC.NAME
, SL.CHART_OF_ACCOUNTS_ID
, CA.ID_FLEX_STRUCTURE_NAME
, CA.DESCRIPTION
, SL.SET_OF_BOOKS_ID
, SB.NAME
, SL.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:CC'
, SL.BUDGET_VERSION_ID
, BV.BUDGET_NAME
, SL.ENCUMBRANCE_TYPE_ID
, ET.ENCUMBRANCE_TYPE
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, SL.RECOVERABLE_TAX
, SL.NONRECOVERABLE_TAX
, SL.ENTERED_REC_TAX
, SL.ENTERED_NR_TAX
, SL.ACCOUNTED_REC_TAX
, SL.ACCOUNTED_NR_TAX
, '_LA:SL.ACCRUAL_METHOD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
FROM RCV_MC_REC_SUB_LEDGER SL
, RCV_TRANSACTIONS RT
, RCV_SHIPMENT_HEADERS HR
, RCV_SHIPMENT_LINES LI
, FND_CURRENCIES_VL CU
, GL_DAILY_CONVERSION_TYPES RA
, FND_CURRENCIES_VL FC
, FND_ID_FLEX_STRUCTURES_VL CA
, GL_SETS_OF_BOOKS SB
, GL_CODE_COMBINATIONS CC
, GL_BUDGET_VERSIONS BV
, GL_ENCUMBRANCE_TYPES ET
WHERE SL.RCV_TRANSACTION_ID = RT.TRANSACTION_ID
AND RT.SHIPMENT_HEADER_ID = HR.SHIPMENT_HEADER_ID(+)
AND RT.SHIPMENT_LINE_ID = LI.SHIPMENT_LINE_ID
AND SL.CURRENCY_CODE = CU.CURRENCY_CODE(+)
AND SL.USER_CURRENCY_CONVERSION_TYPE = RA.CONVERSION_TYPE(+)
AND SL.FUNCTIONAL_CURRENCY_CODE = FC.CURRENCY_CODE(+)
AND SL.CHART_OF_ACCOUNTS_ID = CA.ID_FLEX_NUM(+)
AND CA.APPLICATION_ID(+) = 101
AND CA.ID_FLEX_CODE(+) = 'GL#'AND SL.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND SL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID(+)
AND SL.BUDGET_VERSION_ID = BV.BUDGET_VERSION_ID(+)
AND SL.ENCUMBRANCE_TYPE_ID = ET.ENCUMBRANCE_TYPE_ID(+) WITH READ ONLY

Columns