DBA Data[Home] [Help]

APPS.EDW_UTIL dependencies on CST_ITEM_COSTS

Line 40: cst_item_costs cst

36: SELECT NVL(cst.item_cost,0)
37: INTO l_cost
38: FROM cst_cost_types cct,
39: mtl_parameters mtl,
40: cst_item_costs cst
41: WHERE (cst.cost_type_id = cct.cost_type_id
42: OR (cst.cost_type_id = cct.default_cost_type_id
43: AND (NOT EXISTS (SELECT 'Primary Cost Type Row'
44: FROM cst_item_costs cst1

Line 44: FROM cst_item_costs cst1

40: cst_item_costs cst
41: WHERE (cst.cost_type_id = cct.cost_type_id
42: OR (cst.cost_type_id = cct.default_cost_type_id
43: AND (NOT EXISTS (SELECT 'Primary Cost Type Row'
44: FROM cst_item_costs cst1
45: WHERE cst1.inventory_item_id = cst.inventory_item_id
46: AND cst1.organization_id = cst.organization_id
47: AND cst1.cost_type_id = cct.cost_type_id))))
48: AND cct.costing_method_type = mtl.primary_cost_method