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_LOOP_CALC_RULES_B

Line 39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;

35: l_negp NUMBER;
36: l_onhand_good NUMBER;
37: l_min_good NUMBER;
38: l_total_loop_quantity NUMBER;
39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;
40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;

Line 40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;

36: l_onhand_good NUMBER;
37: l_min_good NUMBER;
38: l_total_loop_quantity NUMBER;
39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;
40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;

Line 41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;

37: l_min_good NUMBER;
38: l_total_loop_quantity NUMBER;
39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;
40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;

Line 42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;

38: l_total_loop_quantity NUMBER;
39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;
40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;

Line 43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;

39: l_include_intransit_mo csp_loop_calc_rules_b.include_intransit_move_orders%TYPE;
40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;

Line 44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;

40: l_include_move_orders csp_loop_calc_rules_b.include_move_orders%TYPE;
41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;
48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;

Line 45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;

41: l_include_work_orders csp_loop_calc_rules_b.include_work_orders%TYPE;
42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;
48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;
49:

Line 46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;

42: l_include_purchase_orders csp_loop_calc_rules_b.include_purchase_orders%TYPE;
43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;
48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;
49:
50: CURSOR c_calculation_rule IS

Line 47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;

43: l_include_requisitions csp_loop_calc_rules_b.include_requisitions%TYPE;
44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;
48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;
49:
50: CURSOR c_calculation_rule IS
51: SELECT clcrb.include_sales_orders

Line 48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;

44: l_include_interorg_transfers csp_loop_calc_rules_b.include_interorg_transfers%TYPE;
45: l_include_onhand_good csp_loop_calc_rules_b.include_onhand_good%TYPE;
46: l_include_onhand_bad csp_loop_calc_rules_b.include_onhand_bad%TYPE;
47: l_include_sales_orders csp_loop_calc_rules_b.include_sales_orders%TYPE;
48: l_tolerance_percent csp_loop_calc_rules_b.tolerance_percent%TYPE;
49:
50: CURSOR c_calculation_rule IS
51: SELECT clcrb.include_sales_orders
52: , clcrb.include_move_orders

Line 61: FROM csp_loop_calc_rules_b clcrb

57: , clcrb.include_onhand_good
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:

Line 262: FROM csp_loop_calc_rules_b clcrb

258: , clcrb.include_onhand_good
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