[Home] [Help]
17876: -- Note: Repeating the where condition below to force the db optimizer
17877: -- to drive the main-query from sub-query. bug: 4145360
17878: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
17879: AND wdd2.lpn_id IN ( SELECT line_id
17880: FROM WMS_TXN_CONTEXT_TEMP
17881: WHERE txn_source_name = 'XFER_LPN_RES'
17882: AND txn_source_name = 'XFER_LPN_RES' );
17883:
17884: CURSOR item_deliveries(p_lot VARCHAR2) IS
17924:
17925: -- Workaround for performance issue 3631133
17926: -- lpn_id for the LPN and it's child lpns will be stored in this global
17927: -- temp table under the line_id
17928: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )
17929: SELECT distinct lpn_id, 'XFER_LPN_RES'
17930: FROM wms_license_plate_numbers
17931: START WITH lpn_id = p_lpn_id
17932: CONNECT BY parent_lpn_id = PRIOR lpn_id;
17983: END LOOP;
17984:
17985: -- Workaround for performance issue 3631133
17986: -- need to delete the inserted values in temp table above
17987: DELETE FROM WMS_TXN_CONTEXT_TEMP
17988: WHERE txn_source_name = 'XFER_LPN_RES';
17989: ELSE
17990: --LPN split, transfer reservation of a single item type
17991: IF (l_debug = 1) THEN