DBA Data[Home] [Help]

VIEW: APPS.RCV_REC_SUB_LEDGER_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 , 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)
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
, 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)