[Home] [Help]
284: ' SELECT /*+ index(oel oe_odr_lines_sn_n1) */ oel.LINE_ID , oel.ATO_LINE_ID ,oel.ITEM_TYPE_CODE,oel.RN, '
285: ||' oel.INVENTORY_ITEM_ID, oel.organization_id '
286: ||' FROM MRP_SN_ODR_LINES oel '
287: ||' WHERE ato_line_id is not null'
288: ||' AND item_type_code in (''MODEL'',''STANDARD'',''CONFIG'') '
289: ||' AND ( oel.rn > :p_lrn ) '
290: ||' UNION ALL'
291: ||' SELECT /*+ index(mr mtl_reservations_sn_n1) */ oel.LINE_ID , oel.ATO_LINE_ID ,oel.ITEM_TYPE_CODE,oel.RN, '
292: ||' oel.INVENTORY_ITEM_ID, oel.organization_id '
292: ||' oel.INVENTORY_ITEM_ID, oel.organization_id '
293: ||' FROM MRP_SN_ODR_LINES oel, '
294: ||' MRP_SN_MTL_RESERVATIONS mr '
295: ||' WHERE ato_line_id is not null'
296: ||' AND item_type_code in (''MODEL'',''STANDARD'',''CONFIG'') '
297: ||' AND mr.DEMAND_SOURCE_LINE_ID = oel.LINE_ID '
298: ||' AND ( mr.RN > :p_lrn AND oel.RN <= :p_lrn) '
299: ||' ORDER BY organization_id ';
300:
306: ' SELECT UNIQUE oel.LINE_ID , oel.ATO_LINE_ID ,oel.ITEM_TYPE_CODE,oel.RN, oel.INVENTORY_ITEM_ID, oel.organization_id '
307: ||' FROM MRP_SN_ODR_LINES oel '
308: ||' WHERE ato_line_id is not null'
309: ||' AND ordered_quantity > NVL(shipped_quantity,0) '
310: ||' AND item_type_code in (''MODEL'',''STANDARD'',''CONFIG'') '
311: ||' ORDER BY oel.organization_id ';
312:
313: OPEN Order_Line_Cur for lv_cursor_stmt;
314:
562: END;
563:
564: END IF;
565:
566: ELSIF (pItemCode = 'STANDARD' ) THEN
567: /* Explode the ATO Item to get the SMC's under it*/
568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Exploding the ATO Item: Line_id = '||pLineId);
569:
570: /* If the ATO item is shipped, get 1 into lv_ato_item_shipped,