VIEW: APPS.RCV_SUB_LEDGER_DET_MRC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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