View: RCV_REC_SUB_LEDGER_MRC_V

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

View Text

SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RCV_TRANSACTION_ID
, CURRENCY_CODE
, ACTUAL_FLAG
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, SET_OF_BOOKS_ID
, ACCOUNTING_DATE
, CODE_COMBINATION_ID
, ACCOUNTED_DR
, ACCOUNTED_CR
, ENCUMBRANCE_TYPE_ID
, ENTERED_DR
, ENTERED_CR
, BUDGET_VERSION_ID
, CURRENCY_CONVERSION_DATE
, USER_CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, TRANSACTION_DATE
, PERIOD_NAME
, CHART_OF_ACCOUNTS_ID
, FUNCTIONAL_CURRENCY_CODE
, DATE_CREATED_IN_GL
, JE_BATCH_NAME
, JE_BATCH_DESCRIPTION
, JE_HEADER_NAME
, JE_LINE_DESCRIPTION
, REVERSE_JOURNAL_FLAG
, REVERSAL_PERIOD_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SUBLEDGER_DOC_SEQUENCE_ID
, SUBLEDGER_DOC_SEQUENCE_VALUE
, USSGL_TRANSACTION_CODE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, SOURCE_DOC_QUANTITY
, ACCOUNTED_NR_TAX
, ACCOUNTED_REC_TAX
, ACCRUAL_METHOD_FLAG
, ENTERED_NR_TAX
, ENTERED_REC_TAX
, GL_SL_LINK_ID
, RCV_SUB_LEDGER_ID
, ACCOUNTING_EVENT_ID
, ACCOUNTING_LINE_TYPE
, PA_ADDITION_FLAG
FROM RCV_MC_REC_SUB_LEDGER
WHERE SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTR(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)

Columns