VIEW: APPS.POBV_RECEIVING_SUBLEDGERS

Source

View Text - Preformatted

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, SL.RCV_TRANSACTION_ID, SL.CURRENCY_CODE, SL.USER_CURRENCY_CONVERSION_TYPE, SL.FUNCTIONAL_CURRENCY_CODE, SL.CHART_OF_ACCOUNTS_ID, SL.SET_OF_BOOKS_ID, SL.CODE_COMBINATION_ID, SL.BUDGET_VERSION_ID, SL.ENCUMBRANCE_TYPE_ID, SL.CREATION_DATE, SL.CREATED_BY, SL.LAST_UPDATE_DATE, SL.LAST_UPDATED_BY, '_LA:SL.ACCRUAL_METHOD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', SL.ENTERED_REC_TAX, SL.ENTERED_NR_TAX, SL.ACCOUNTED_REC_TAX, SL.ACCOUNTED_NR_TAX FROM RCV_RECEIVING_SUB_LEDGER SL WITH READ ONLY

View Text - HTML Formatted

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
, SL.RCV_TRANSACTION_ID
, SL.CURRENCY_CODE
, SL.USER_CURRENCY_CONVERSION_TYPE
, SL.FUNCTIONAL_CURRENCY_CODE
, SL.CHART_OF_ACCOUNTS_ID
, SL.SET_OF_BOOKS_ID
, SL.CODE_COMBINATION_ID
, SL.BUDGET_VERSION_ID
, SL.ENCUMBRANCE_TYPE_ID
, SL.CREATION_DATE
, SL.CREATED_BY
, SL.LAST_UPDATE_DATE
, SL.LAST_UPDATED_BY
, '_LA:SL.ACCRUAL_METHOD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, SL.ENTERED_REC_TAX
, SL.ENTERED_NR_TAX
, SL.ACCOUNTED_REC_TAX
, SL.ACCOUNTED_NR_TAX
FROM RCV_RECEIVING_SUB_LEDGER SL WITH READ ONLY