FND Design Data [Home] [Help]

View: RCV_SUB_LEDGER_DET_MRC_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.RCV_SUB_LEDGER_DET_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"
, "PO_LINE_LOCATION_ID"
, "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"
, "ACCRUAL_METHOD_FLAG"
, "GL_SL_LINK_ID"
, "ENTERED_REC_TAX"
, "ENTERED_NR_TAX"
, "ACCOUNTED_REC_TAX"
, "ACCOUNTED_NR_TAX"
, "RCV_SL_DETAILS_ID"
FROM RCV_MC_SUB_LEDGER_DETAILS

Columns

Name
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
PO_LINE_LOCATION_ID
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
ACCRUAL_METHOD_FLAG
GL_SL_LINK_ID
ENTERED_REC_TAX
ENTERED_NR_TAX
ACCOUNTED_REC_TAX
ACCOUNTED_NR_TAX
RCV_SL_DETAILS_ID