View: PMIFV_STANDARD_COST_LEDGER_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Ledger of Process Manufacturing Costing detail information produced during Cost Rollup processing.
Implementation/DBA Data:	APPS.PMIFV_STANDARD_COST_LEDGER_V

View Text

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

Columns