VIEW: APPS.PMIFV_STANDARD_COST_LEDGER_V

Source

View Text - Preformatted

SELECT stdledger.STD_QTY, /* regular attributes */ stdledger.FORM_PROD_UM, stdledger.ROUTING_QTY, stdledger.PRODUCT_QTY, stdledger.COST_ALLOC, stdledger.LINE_TYPE, substr(pmi_cost_analz_pack.gmca_get_meaning('LINE_TYPE', stdledger.LINE_TYPE),1,80), stdledger.ITEM_QTY, stdledger.ITEM_FMQTY, stdledger.ITEM_FMQTY_UM, stdledger.CMPNT_COST, stdledger.RESOURCE_COUNT, stdledger.RESOURCE_USAGE, stdledger.NOMINAL_COST, stdledger.USAGE_UM, stdledger.RUDTL_ID, /* Id */ stdledger.ITEM_ID, stdledger.WHSE_CODE, stdledger.RESOURCES, stdledger.CMPNTCOST_ID, item.item_no, /* Resolved Foreign Keys */ item.item_desc1, item.item_um, item.item_um2, stdledger.CREATED_BY, /* WHO */ stdledger.CREATION_DATE, stdledger.LAST_UPDATE_DATE, stdledger.LAST_UPDATED_BY FROM cm_scst_led stdledger, ic_item_mst item, ic_whse_mst warehouse WHERE stdledger.item_id = item.item_id(+) and stdledger.whse_code = warehouse.whse_code and stdledger.delete_mark = 0 and (warehouse.orgn_code is NULL or warehouse.orgn_code IN (SELECT secorg.orgn_code FROM sy_orgn_mst secorg WHERE PMI_SECURITY_PKG.show_record(secorg.orgn_code) = 'TRUE')) with read only

View Text - HTML Formatted

SELECT STDLEDGER.STD_QTY
, /* REGULAR ATTRIBUTES */ STDLEDGER.FORM_PROD_UM
, STDLEDGER.ROUTING_QTY
, STDLEDGER.PRODUCT_QTY
, STDLEDGER.COST_ALLOC
, STDLEDGER.LINE_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('LINE_TYPE'
, STDLEDGER.LINE_TYPE)
, 1
, 80)
, STDLEDGER.ITEM_QTY
, STDLEDGER.ITEM_FMQTY
, STDLEDGER.ITEM_FMQTY_UM
, STDLEDGER.CMPNT_COST
, STDLEDGER.RESOURCE_COUNT
, STDLEDGER.RESOURCE_USAGE
, STDLEDGER.NOMINAL_COST
, STDLEDGER.USAGE_UM
, STDLEDGER.RUDTL_ID
, /* ID */ STDLEDGER.ITEM_ID
, STDLEDGER.WHSE_CODE
, STDLEDGER.RESOURCES
, STDLEDGER.CMPNTCOST_ID
, ITEM.ITEM_NO
, /* RESOLVED FOREIGN KEYS */ ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, STDLEDGER.CREATED_BY
, /* WHO */ STDLEDGER.CREATION_DATE
, STDLEDGER.LAST_UPDATE_DATE
, STDLEDGER.LAST_UPDATED_BY
FROM CM_SCST_LED STDLEDGER
, IC_ITEM_MST ITEM
, IC_WHSE_MST WAREHOUSE
WHERE STDLEDGER.ITEM_ID = ITEM.ITEM_ID(+)
AND STDLEDGER.WHSE_CODE = WAREHOUSE.WHSE_CODE
AND STDLEDGER.DELETE_MARK = 0
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY