eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ITEM_LOAD dependencies on WIP_LPN_COMPLETIONS_SERIALS

Line 527: FROM wip_lpn_completions_serials

523: AND NVL(mtrl.lot_number, '###') = NVL(p_lot_number, '###')
524: AND mtrl.quantity <> NVL(mtrl.quantity_delivered, 0)
525: AND l_lpn_context = 2
526: AND mtrl.reference_id IN (SELECT header_id
527: FROM wip_lpn_completions_serials
528: WHERE l_current_serial BETWEEN fm_serial_number AND
529: to_serial_number
530: AND NVL(lot_number, '###') = NVL(p_lot_number, '###'))
531: AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 593: -- WIP_LPN_COMPLETIONS_SERIALS contains one and only one serial.

589: -- Cursor used to get the marked serials tied to a specific MOL.
590: -- Note that in the WIP case, we are making the assumption that
591: -- the fm_serial_number is always the same as the to_serial_number.
592: -- It seems that for WIP LPN completions with serials, each record in
593: -- WIP_LPN_COMPLETIONS_SERIALS contains one and only one serial.
594: CURSOR matched_wip_serials_cursor IS
595: SELECT wlcs.fm_serial_number
596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn
597: WHERE l_lpn_context = 2

Line 596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn

592: -- It seems that for WIP LPN completions with serials, each record in
593: -- WIP_LPN_COMPLETIONS_SERIALS contains one and only one serial.
594: CURSOR matched_wip_serials_cursor IS
595: SELECT wlcs.fm_serial_number
596: FROM wip_lpn_completions_serials wlcs, mtl_serial_numbers msn
597: WHERE l_lpn_context = 2
598: AND NVL(wlcs.lot_number, '###') = NVL(p_lot_number, '###')
599: AND wlcs.header_id IN (SELECT reference_id
600: FROM mtl_txn_request_lines