eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_NOTIFICATIONS_PVT dependencies on CSP_PARTS_LOOPS_B

Line 62: , csp_parts_loops_b cplb

58: , clcrb.include_onhand_bad
59: , clcrb.include_intransit_move_orders
60: , clcrb.tolerance_percent
61: FROM csp_loop_calc_rules_b clcrb
62: , csp_parts_loops_b cplb
63: WHERE cplb.parts_loop_id = p_parts_loop_id
64: AND cplb.calculation_rule_id = clcrb.calculation_rule_id;
65:
66: /*CURSOR c_supply_demand IS

Line 231: l_parts_loop_id csp_parts_loops_b.parts_loop_id%TYPE;

227: )
228: IS
229: l_api_name CONSTANT VARCHAR2(30) := 'create_notifications';
230: l_api_version CONSTANT NUMBER := 1.0;
231: l_parts_loop_id csp_parts_loops_b.parts_loop_id%TYPE;
232: l_above NUMBER;
233: l_below NUMBER;
234: l_not_enough_good_parts NUMBER;
235: l_quantity_level NUMBER;

Line 263: , csp_parts_loops_b cplb

259: , clcrb.include_onhand_bad
260: , clcrb.include_intransit_move_orders
261: , clcrb.tolerance_percent
262: FROM csp_loop_calc_rules_b clcrb
263: , csp_parts_loops_b cplb
264: WHERE cplb.calculation_rule_id = clcrb.calculation_rule_id;
265:
266: /*CURSOR c_items(c_parts_loop_id NUMBER) IS
267: SELECT ccsds.inventory_item_id