APPS.CSP_PLANNER_NOTIFICATIONS dependencies on INV_MIN_MAX_TEMP

Line 187: FROM INV_MIN_MAX_TEMP;

183: , MIN_ORD_QTY
184: , MAX_ORD_QTY
185: , FIX_MULT
186: , REORD_QTY
187: FROM INV_MIN_MAX_TEMP;
188:
189: l_minmax_rslts_rec minmax_rslts_cur%ROWTYPE;
190:
191: CURSOR item_attr_cur(p_item_Segments VARCHAR2,

Line 778: -- cleanup INV_MIN_MAX_TEMP table

774: END IF;
775: END IF;
776: END IF;
777: END LOOP;
778: -- cleanup INV_MIN_MAX_TEMP table
779: delete from INV_MIN_MAX_TEMP;
780: END IF;
781:
782: -- create notifications for excess on order

Line 779: delete from INV_MIN_MAX_TEMP;

775: END IF;
776: END IF;
777: END LOOP;
778: -- cleanup INV_MIN_MAX_TEMP table
779: delete from INV_MIN_MAX_TEMP;
780: END IF;
781:
782: -- create notifications for excess on order
783:

Line 826: -- for all records in inv_min_max_temp with supply qty > 0

822: , p_exception_set_id => l_exception_set_id
823: , x_return_status => l_Return_status
824: , x_msg_data => l_msg_data);
825:
826: -- for all records in inv_min_max_temp with supply qty > 0
827: -- create EOO notifications
828: declare
829: l_item_id NUMBER;
830: l_planner VARCHAR2(30);

Line 958: DELETE FROM INV_MIN_MAX_TEMP;

954: END IF;
955: END LOOP;
956: end;
957: -- cleanup minmax temp tbl
958: DELETE FROM INV_MIN_MAX_TEMP;
959:
960: -- For all IO/PO/WIP notifs in notifications tbl,
961: -- create recommendations for excess, repair and new buy/make
962: -- For all EOO notifications,

Line 2140: FROM INV_MIN_MAX_TEMP

2136: ELSE
2137: BEGIN
2138: SELECT (tot_avail_qty - max_qty) excess_qty
2139: INTO l_excess_qty
2140: FROM INV_MIN_MAX_TEMP
2141: WHERE item_Segments = l_item;
2142:
2143: EXCEPTION
2144: WHEN NO_DATA_FOUND THEN

Line 2150: -- cleanup inv_min_max_Temp

2146: WHEN OTHERS THEN
2147: l_Excess_qty := -2;
2148: END;
2149:
2150: -- cleanup inv_min_max_Temp
2151: DELETE FROM INV_MIN_MAX_TEMP;
2152: END IF;
2153: END IF;
2154: IF (nvl(l_excess_qty, 0) > 0) THEN

Line 2151: DELETE FROM INV_MIN_MAX_TEMP;

2147: l_Excess_qty := -2;
2148: END;
2149:
2150: -- cleanup inv_min_max_Temp
2151: DELETE FROM INV_MIN_MAX_TEMP;
2152: END IF;
2153: END IF;
2154: IF (nvl(l_excess_qty, 0) > 0) THEN
2155: x_excess_parts_tbl(idx).quantity := l_excess_qty;

Line 2236: FROM INV_MIN_MAX_TEMP

2232: ELSE
2233: BEGIN
2234: SELECT (tot_avail_qty - max_qty) excess_qty
2235: INTO l_excess_qty
2236: FROM INV_MIN_MAX_TEMP
2237: WHERE item_Segments = l_item;
2238: EXCEPTION
2239: WHEN NO_DATA_FOUND THEN
2240: l_Excess_qty := -1;

Line 2244: -- cleanup inv_min_max_Temp

2240: l_Excess_qty := -1;
2241: WHEN OTHERS THEN
2242: l_Excess_qty := -1;
2243: END;
2244: -- cleanup inv_min_max_Temp
2245: DELETE FROM INV_MIN_MAX_TEMP;
2246: END If;
2247: ELSE
2248: INV_Quantity_Tree_PUB.Query_Quantities

Line 2245: DELETE FROM INV_MIN_MAX_TEMP;

2241: WHEN OTHERS THEN
2242: l_Excess_qty := -1;
2243: END;
2244: -- cleanup inv_min_max_Temp
2245: DELETE FROM INV_MIN_MAX_TEMP;
2246: END If;
2247: ELSE
2248: INV_Quantity_Tree_PUB.Query_Quantities
2249: ( p_api_version_number => 1.0