VIEW: APPS.PMITS_TEST_SUBLEDGER_V

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )