View: PMIBV_FORMULA_COST_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing Information for product by formula
Implementation/DBA Data:	APPS.PMIBV_FORMULA_COST_V

View Text

SELECT FMASTER.FORMULA_NO
, FMASTER.FORMULA_VERS
, FMASTER.FORMULA_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('GMD_FORMULA_USE'
, FMASTER.FORMULA_TYPE)
, 1
, 80)
, FMASTER.SCALE_TYPE
, FMASTER.FORMULA_DESC1
, FMASTER.FORMULA_DESC2
, FMASTER.FORMULA_CLASS
, FMASTER.FMCONTROL_CLASS
, FMASTER.FORMULA_ID
, EFFECTIVITY.FMEFF_ID
, EFFECTIVITY.ORGN_CODE
, EFFECTIVITY.ITEM_ID
, EFFECTIVITY.ROUTING_ID
, EFFECTIVITY.FORMULA_ID
, EFFECTIVITY.CUST_ID
, EFFECTIVITY.FORMULA_USE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('GMD_FORMULA_USE'
, EFFECTIVITY.FORMULA_USE)
, 1
, 80)
, EFFECTIVITY.END_DATE
, EFFECTIVITY.START_DATE
, EFFECTIVITY.INV_MIN_QTY
, EFFECTIVITY.INV_MAX_QTY
, EFFECTIVITY.MIN_QTY
, EFFECTIVITY.MAX_QTY
, EFFECTIVITY.STD_QTY
, EFFECTIVITY.ITEM_UM
, EFFECTIVITY.PREFERENCE
, PRODUCT.ITEM_NO
, PRODUCT.ITEM_DESC1
, PRODUCT.ITEM_DESC2
, PRODUCT.ITEM_UM
, PRODUCT.ITEM_UM2
, CUSTOMER.CUST_NO
, CUSTOMER.CUST_NAME
, ROUTING.ROUTING_ID
, ROUTING.ROUTING_NO
, ROUTING.ROUTING_VERS
, ROUTING.ROUTING_DESC
, ROUTING.ROUTING_CLASS
, ROUTING.ROUTING_QTY
, ROUTING.ITEM_UM
, COSTDETAIL.COST_LEVEL
, COSTDETAIL.CMPNT_COST
, COSTDETAIL.BURDEN_IND
, COSTDETAIL.ROLLOVER_IND
, COSTDETAIL.TOTAL_QTY
, COSTDETAIL.COSTCALC_ORIG
, COSTDETAIL.RMCALC_TYPE
, COSTDETAIL.ROLLUP_REF_NO
, COSTDETAIL.CMPNTCOST_ID
, COSTDETAIL.WHSE_CODE
, WAREHOUSE.WHSE_NAME
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, COSTDETAIL.COST_MTHD_CODE
, COSTDETAIL.COST_CMPNTCLS_ID
, COSTDETAIL.COST_ANALYSIS_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTMASTER.COST_CMPNTCLS_DESC
, COSTMASTER.SORT_SEQUENCE
, COSTMASTER.USAGE_IND
, COSTMASTER.PRIMARY_CMPNTCLS_ID
, COSTMASTER.PRODUCT_COST_IND
, COSTMASTER.UPDATE_COST_IND
, COSTMASTER.CMPNT_GROUP
, COSTMASTER.PPV_IND
, STDLEDGER.STD_QTY
, 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
, STDLEDGER.ITEM_ID
, STDLEDGER.WHSE_CODE
, STDLEDGER.RESOURCES
, LEDGER_ITEM.ITEM_NO
, LEDGER_ITEM.ITEM_DESC1
, LEDGER_ITEM.ITEM_UM
, LEDGER_ITEM.ITEM_UM2
, FMASTER.CREATED_BY
, FMASTER.CREATION_DATE
, FMASTER.LAST_UPDATE_DATE
, FMASTER.LAST_UPDATED_BY
FROM FM_FORM_MST FMASTER
, IC_ITEM_MST PRODUCT
, FM_FORM_EFF EFFECTIVITY
, OP_CUST_MST CUSTOMER
, FM_ROUT_HDR ROUTING
, CM_CMPT_DTL COSTDETAIL
, CM_CMPT_MST COSTMASTER
, IC_WHSE_MST WAREHOUSE
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
, CM_SCST_LED STDLEDGER
, IC_ITEM_MST LEDGER_ITEM
WHERE EFFECTIVITY.FORMULA_ID(+) = FMASTER.FORMULA_ID
AND PRODUCT.ITEM_ID(+) = EFFECTIVITY.ITEM_ID
AND CUSTOMER.CUST_ID(+) = EFFECTIVITY.CUST_ID
AND ROUTING.ROUTING_ID(+) = EFFECTIVITY.ROUTING_ID
AND COSTDETAIL.FMEFF_ID(+) = EFFECTIVITY.FMEFF_ID
AND COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND COSTDETAIL.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND COSTDETAIL.CMPNTCOST_ID = STDLEDGER.CMPNTCOST_ID(+)
AND STDLEDGER.ITEM_ID = LEDGER_ITEM.ITEM_ID
AND FMASTER.INACTIVE_IND = 0
AND FMASTER.DELETE_MARK = 0
AND EFFECTIVITY.DELETE_MARK = 0
AND (EFFECTIVITY.ORGN_CODE IS NULL OR EFFECTIVITY.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