APPS.CSP_EXCESS_PARTS_PVT dependencies on INV_MIN_MAX_TEMP

Line 132: FROM INV_MIN_MAX_TEMP;

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

Line 196: Cursor INV_MIN_MAX_TEMP IS

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

Line 199: FROM INV_MIN_MAX_TEMP;

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

Line 478: For INV_REC IN INV_MIN_MAX_TEMP LOOP

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

Line 748: Delete from INV_MIN_MAX_TEMP;

744: end if;
745: end if;
746: end if;
747: End if;
748: Delete from INV_MIN_MAX_TEMP;
749: End loop;
750: end;
751:
752: procedure apply_business_rules(