APPS.CSP_EXCESS_PARTS_PVT dependencies on INV_MIN_MAX_TEMP

Line 134: FROM INV_MIN_MAX_TEMP;

130: , MIN_ORD_QTY
131: , MAX_ORD_QTY
132: , FIX_MULT
133: , REORD_QTY
134: FROM INV_MIN_MAX_TEMP;
135:
136: l_minmax_rslts_rec minmax_rslts_cur%ROWTYPE;
137:
138: CURSOR item_attr_cur(p_item_Segments VARCHAR2,

Line 198: Cursor INV_MIN_MAX_TEMP IS

194: organization_id = p_organization_id and
195: SUBINVENTORY_CODE = p_subinventory_code and
196: (EFFECTIVE_DATE_END is null or trunc(EFFECTIVE_DATE_END) > trunc(sysdate));
197:
198: Cursor INV_MIN_MAX_TEMP IS
199: SELECT ITEM_SEGMENTS,MIN_QTY,MAX_QTY,ONHAND_QTY,SUPPLY_QTY,DEMAND_QTY,
200: TOT_AVAIL_QTY,MIN_ORD_QTY,MAX_ORD_QTY,FIX_MULT,REORD_QTY
201: FROM INV_MIN_MAX_TEMP;
202:

Line 201: FROM INV_MIN_MAX_TEMP;

197:
198: Cursor INV_MIN_MAX_TEMP IS
199: SELECT ITEM_SEGMENTS,MIN_QTY,MAX_QTY,ONHAND_QTY,SUPPLY_QTY,DEMAND_QTY,
200: TOT_AVAIL_QTY,MIN_ORD_QTY,MAX_ORD_QTY,FIX_MULT,REORD_QTY
201: FROM INV_MIN_MAX_TEMP;
202:
203: cursor c_org_items is
204: select distinct moq.inventory_item_id,
205: nvl(msib.max_minmax_quantity,0) max,

Line 480: For INV_REC IN INV_MIN_MAX_TEMP LOOP

476:
477: --ORGANIZATION Level
478: --if l_level = 1 then
479:
480: For INV_REC IN INV_MIN_MAX_TEMP LOOP
481:
482: Begin
483: SELECT msik.inventory_item_id
484: INTO l_item_id

Line 834: Delete from INV_MIN_MAX_TEMP;

830: end if;
831: end if;
832: end if;
833: End if;
834: Delete from INV_MIN_MAX_TEMP;
835: End loop;
836:
837: exception
838: when others then