APPS.MRP_CL_FUNCTION dependencies on CST_COST_TYPES

Line 116: cst_cost_types cct

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
120: AND cst.inventory_item_id = p_item_id

Line 128: FROM cst_cost_types cct,

124: SELECT NVL(cst.tl_resource,0)
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)

Line 165: cst_cost_types cct

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
169: AND cst.inventory_item_id = p_item_id

Line 174: FROM cst_cost_types cct,

170: AND cst.organization_id = p_org_id;
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)