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_PUTAWAY_UTILS dependencies on RCV_SERIALS_SUPPLY

Line 10300: , rcv_serials_supply rss

10296: , msn.inspection_status
10297: , msn.lot_number
10298: FROM mtl_serial_numbers_interface msni
10299: , mtl_serial_numbers msn
10300: , rcv_serials_supply rss
10301: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
10302: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)
10303: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
10304: AND msn.inventory_item_id = p_item_id

Line 10381: l_parent_txn_id_tbl num_tab; --Parent Transaction Id - for rcv_serials_supply

10377: l_wip_sup_typ_tbl num_tab; --Wip Supply Type for the current group
10378: l_mol_line_id NUMBER; --MO Line ID
10379: l_mol_lpn_id_tbl num_tab; --LPN_ID for the current task => p_lpn_id of complete_putaway
10380: l_mol_line_id_tbl num_tab; --MO Line ID
10381: l_parent_txn_id_tbl num_tab; --Parent Transaction Id - for rcv_serials_supply
10382: l_parent_txn_id NUMBER; --Parent Transaction Id - for rcv_serials_supply
10383: l_lot_control_code NUMBER; --Item Lot control code
10384: l_serial_control_code NUMBER; --Item Serial control code
10385: l_mmtt_count NUMBER; --No. of MMTTs for the current MOL

Line 10382: l_parent_txn_id NUMBER; --Parent Transaction Id - for rcv_serials_supply

10378: l_mol_line_id NUMBER; --MO Line ID
10379: l_mol_lpn_id_tbl num_tab; --LPN_ID for the current task => p_lpn_id of complete_putaway
10380: l_mol_line_id_tbl num_tab; --MO Line ID
10381: l_parent_txn_id_tbl num_tab; --Parent Transaction Id - for rcv_serials_supply
10382: l_parent_txn_id NUMBER; --Parent Transaction Id - for rcv_serials_supply
10383: l_lot_control_code NUMBER; --Item Lot control code
10384: l_serial_control_code NUMBER; --Item Serial control code
10385: l_mmtt_count NUMBER; --No. of MMTTs for the current MOL
10386: l_ser_intf_id NUMBER; --Updated txn_interface_id for MSNI

Line 10719: --Eg. MOL1 has serials S1 - S5 with parent tranasction RT1 (rcv_serials_supply)

10715: --serials confirmed in the UI
10716: --The check for serialized item is needed only for a receiving LPN
10717: --We need this because for splitting move orders, we must first consume those
10718: --MOLS with serials of the parent txn
10719: --Eg. MOL1 has serials S1 - S5 with parent tranasction RT1 (rcv_serials_supply)
10720: -- MOL2 has serials S6 -S10 with parent transaction RT2
10721: -- User confirms S2, S6, S8 from the UI.
10722: --We should split MOL1 into MOL1 = 1 and create new line MOL3 for qty 4
10723: --We should split MOL2 into MOL2 = 2 and create new line MOL4 for qty 3