APPS.MRP_CL_FUNCTION dependencies on CST_ITEM_COSTS

Line 115: FROM cst_item_costs cst,

111: SELECT NVL(cst.tl_resource,0)
112: + NVL(cst.tl_overhead,0)
113: + NVL(cst.tl_material_overhead,0)
114: + NVL(cst.tl_outside_processing,0)
115: FROM cst_item_costs cst,
116: cst_cost_types cct
117: WHERE cct.costing_method_type = p_primary_cost_method
118: AND cct.cost_type_id = DECODE(p_primary_cost_method,1,1,2,2,1)
119: AND cst.cost_type_id = cct.cost_type_id

Line 129: cst_item_costs cst

125: + NVL(cst.tl_overhead,0)
126: + NVL(cst.tl_material_overhead,0)
127: + NVL(cst.tl_outside_processing,0)
128: FROM cst_cost_types cct,
129: cst_item_costs cst
130: WHERE cst.cost_type_id = cct.default_cost_type_id
131: AND cct.costing_method_type = p_primary_cost_method
132: AND cct.cost_type_id = DECODE(p_primary_cost_method,1,1,2,2,1)
133: AND cst.inventory_item_id = p_item_id

Line 164: FROM cst_item_costs cst,

160: RETURN NUMBER IS
161:
162: CURSOR COST_C IS
163: SELECT NVL(cst.item_cost,0)
164: FROM cst_item_costs cst,
165: cst_cost_types cct
166: WHERE cct.costing_method_type = p_primary_cost_method
167: AND cct.cost_type_id = DECODE(p_primary_cost_method,1,1,2,2,1)
168: AND cst.cost_type_id = cct.cost_type_id

Line 175: cst_item_costs cst

171:
172: CURSOR COST_C2 IS
173: SELECT NVL(cst.item_cost,0)
174: FROM cst_cost_types cct,
175: cst_item_costs cst
176: WHERE cst.cost_type_id = cct.default_cost_type_id
177: AND cct.costing_method_type = p_primary_cost_method
178: AND cct.cost_type_id = DECODE(p_primary_cost_method,1,1,2,2,1)
179: AND cst.inventory_item_id = p_item_id