APPS.CSP_NOTIFICATIONS_PVT dependencies on CSP_MSTRSTCK_LISTS_ITMS

Line 79: FROM csp_mstrstck_lists_itms cmsi

75: + decode(l_include_onhand_bad,'Y',nvl(ccsds.onhand_bad,0),0) quantity_level
76: , ccsds.onhand_good
77: , cmsi.total_loop_min_good_quantity
78: , cmsi.total_loop_quantity
79: FROM csp_mstrstck_lists_itms cmsi
80: , csp_curr_sup_dem_sums ccsds
81: WHERE parts_loop_id = p_parts_loop_id
82: AND subinventory_code is null
83: AND ccsds.parts_loop_id = cmsi.parts_loops_id

Line 100: FROM csp_mstrstck_lists_itms cmsi

96: + decode(l_include_onhand_bad,'Y',nvl(ccsds.onhand_bad,0),0) quantity_level
97: , nvl(ccsds.onhand_good,0)
98: , nvl(cmsi.total_loop_min_good_quantity,0)
99: , nvl(cmsi.total_loop_quantity,0)
100: FROM csp_mstrstck_lists_itms cmsi
101: , csp_curr_sup_dem_sums ccsds
102: WHERE cmsi.parts_loops_id = p_parts_loop_id
103: AND ccsds.parts_loop_id(+) = cmsi.parts_loops_id
104: AND ccsds.subinventory_code(+) is null

Line 121: FROM csp_mstrstck_lists_itms cmsi

117: + decode(l_include_onhand_bad,'Y',nvl(ccsds.onhand_bad,0),0) quantity_level
118: , nvl(ccsds.onhand_good,0)
119: , nvl(cmsi.total_loop_min_good_quantity,0)
120: , nvl(cmsi.total_loop_quantity,0)
121: FROM csp_mstrstck_lists_itms cmsi
122: , CSP_SUP_DEM_PL_MV ccsds
123: WHERE cmsi.parts_loops_id = p_parts_loop_id
124: AND ccsds.parts_loop_id(+) = cmsi.parts_loops_id
125: AND cmsi.inventory_item_id = p_inventory_item_id

Line 274: FROM CSP_MSTRSTCK_LISTS_ITMS

270: AND subinventory_code is null;*/
271:
272: CURSOR c_items(c_parts_loop_id NUMBER) IS
273: SELECT INVENTORY_ITEM_ID inventory_item_id
274: FROM CSP_MSTRSTCK_LISTS_ITMS
275: WHERE PARTS_LOOPS_ID = c_parts_loop_id;
276:
277: CURSOR get_planner(c_parts_loop_id number,
278: c_inventory_item_id number) IS

Line 280: FROM csp_mstrstck_lists_itms

276:
277: CURSOR get_planner(c_parts_loop_id number,
278: c_inventory_item_id number) IS
279: SELECT planner_code
280: FROM csp_mstrstck_lists_itms
281: WHERE parts_loops_id = c_parts_loop_id
282: AND inventory_item_id = c_inventory_item_id;
283: l_get_app_info boolean;
284: l_status varchar2(1);