FND Design Data [Home] [Help]

View: POBV_RECEIVING_SUBLEDGERS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.POBV_RECEIVING_SUBLEDGERS
View Text

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

Columns

Name
ACCOUNTING_DATE
ACCOUNTING_PERIOD_NAME
"_LA:BALANCE_TYPE"
BASE_CURRENCY_CREDIT_AMOUNT
BASE_CURRENCY_DEBIT_AMOUNT
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_RATE_DATE
ENTERED_CREDIT_AMOUNT
ENTERED_DEBIT_AMOUNT
GENERAL_LEDGER_EFFECTIVE_DATE
JE_CATEGORY
JE_BATCH_DESCRIPTION
JE_BATCH_NAME
JE_HEADER_NAME
JE_LINE_DESCRIPTION
JE_SOURCE
REVERSAL_PERIOD_NAME
"_LA:REVERSE_JOURNAL_FLAG"
SOURCE_DOCUMENT_QUANTITY
TRANSACTION_DATE
USSGL_TRANSACTION_CODE
RECEIVING_TRANSACTION_ID
TRANSACTION_CURRENCY_CODE
CURRENCY_CONVERSION_RATE_TYPE
FUNCTIONAL_CURRENCY_CODE
CHART_OF_ACCOUNTS_ID
SET_OF_BOOKS_ID
GL_ACCOUNT_ID
BUDGET_VERSION_ID
ENCUMBRANCE_TYPE_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
"_LA:ACCRUAL_METHOD_FLAG"
ENTERED_REC_TAX
ENTERED_NR_TAX
ACCOUNTED_REC_TAX
ACCOUNTED_NR_TAX