DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CST_ITEM_COSTS

Line 904: FROM cst_item_costs cic,

900: IF (l_EOO_qty > 0) THEN
901: BEGIN
902: SELECT cic.item_cost
903: INTO l_item_cost
904: FROM cst_item_costs cic,
905: mtl_parameters mp
906: WHERE cic.inventory_item_id = l_item_id
907: AND cic.organization_id = mp.organization_id
908: AND cic.cost_type_id = mp.primary_cost_method

Line 1197: FROM cst_item_costs cic,

1193:
1194: begin
1195: SELECT cic.item_cost
1196: INTO l_item_cost
1197: FROM cst_item_costs cic,
1198: mtl_parameters mp
1199: WHERE cic.inventory_item_id = onc.inventory_item_id
1200: AND cic.organization_id = mp.organization_id
1201: AND cic.cost_type_id = mp.primary_cost_method