View: PMITS_TEST_SUBLEDGER_V

Product:	PMI - Process Manufacturing Intelligence
Description:	GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process.
Implementation/DBA Data:	APPS.PMITS_TEST_SUBLEDGER_V

View Text

SELECT SOURCE
, SUBLEDGER_ID
, CO_CODE
, FISCAL_YEAR
, PERIOD
, SUB_EVENT_CODE
, VOUCHER_ID
, DOC_TYPE
, DOC_ID
, DECODE(DOC_TYPE
, 'XFER'
, DOC_ID
, 'TRNI'
, DOC_ID
, 'MTRI'
, DOC_ID
, 'TRNR'
, DOC_ID
, 1) JOIN_DOC_ID
, LINE_ID
, ACCT_TTL_CODE
, ACCTG_UNIT_NO
, ACCT_NO
, DEBIT_CREDIT_SIGN
, ACCTG_UNIT_DESC
, ACCT_DESC
, AMOUNT_BASE
, AMOUNT_TRANS
, CURRENCY_BASE
, CURRENCY_TRANS
, JV_QUANTITY
, JV_QUANTITY_UM
, SUB_EVENT_DESC
, TRANS_SOURCE_CODE
, TRANS_SOURCE_DESC
, GL_TRANS_DATE
, ORGN_CODE
, DOC_NO
, DOC_DATE
, LINE_NO
, RESOURCE_ITEM_NO
, RESOURCE_ITEM_NO_DESC
, TRANS_DATE
, WHSE_CODE
, TRANS_QTY_USAGE
, TRANS_QTY_USAGE_UM
, REFERENCE_NO
, DECODE(SUB_EVENT_CODE
, 'STEP'
, 'NONMATERIAL'
, 'CLOS'
, 'NONMATERIAL'
, 'RVAL'
, 'NONMATERIAL'
, 'MATERIAL')
FROM GL_SUBR_TST_VW
WHERE (ORGN_CODE IS NULL OR 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(ORGN_CODE) )

Columns