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 9428: , rcv_serials_supply rss

9424: , msn.inspection_status
9425: , msn.lot_number
9426: FROM mtl_serial_numbers_interface msni
9427: , mtl_serial_numbers msn
9428: , rcv_serials_supply rss
9429: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9430: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)
9431: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
9432: AND msn.inventory_item_id = p_item_id

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

9505: l_wip_sup_typ_tbl num_tab; --Wip Supply Type for the current group
9506: l_mol_line_id NUMBER; --MO Line ID
9507: l_mol_lpn_id_tbl num_tab; --LPN_ID for the current task => p_lpn_id of complete_putaway
9508: l_mol_line_id_tbl num_tab; --MO Line ID
9509: l_parent_txn_id_tbl num_tab; --Parent Transaction Id - for rcv_serials_supply
9510: l_parent_txn_id NUMBER; --Parent Transaction Id - for rcv_serials_supply
9511: l_lot_control_code NUMBER; --Item Lot control code
9512: l_serial_control_code NUMBER; --Item Serial control code
9513: l_mmtt_count NUMBER; --No. of MMTTs for the current MOL

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

9506: l_mol_line_id NUMBER; --MO Line ID
9507: l_mol_lpn_id_tbl num_tab; --LPN_ID for the current task => p_lpn_id of complete_putaway
9508: l_mol_line_id_tbl num_tab; --MO Line ID
9509: l_parent_txn_id_tbl num_tab; --Parent Transaction Id - for rcv_serials_supply
9510: l_parent_txn_id NUMBER; --Parent Transaction Id - for rcv_serials_supply
9511: l_lot_control_code NUMBER; --Item Lot control code
9512: l_serial_control_code NUMBER; --Item Serial control code
9513: l_mmtt_count NUMBER; --No. of MMTTs for the current MOL
9514: l_ser_intf_id NUMBER; --Updated txn_interface_id for MSNI

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

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