VIEW: APPS.PMIBV_FORMULA_COST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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