[Home] [Help]
204: l_src_org_srl_ctrl := 1;
205: END IF;
206:
207: --If the item is serial controlled in the source organization, then the
208: --shipped serials would be there in rcv_serials_supply and we should be
209: --filter the serials in RSS and MSN
210: IF (l_src_org_srl_ctrl <> 1) THEN
211: OPEN x_serial_number FOR
212: SELECT msn.serial_number
215: , rss.lot_num
216: , 0
217: , msn.current_status
218: , mms.status_code
219: FROM rcv_serials_supply rss
220: , rcv_shipment_lines rsl
221: , mtl_serial_numbers msn
222: , mtl_material_statuses_tl mms
223: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id
3658:
3659: /**
3660: * This procedure fetches the Serial Numbers for an item
3661: * inside a LPN that "Resides in Receiving". It uses the
3662: * serial number in RCV_SERIALS_SUPPLY that corresponds to the
3663: * parent transaction.
3664: * This LOV would be called from the Item-based Putaway Drop
3665: * mobile page when the user confirms a quantity lesser than
3666: * the suggested quantity.
3669: * @param p_organization_id Current Organization
3670: * @param p_inventory_item_id Inventory Item
3671: * @param p_lot_number Lot Number
3672: * @param p_txn_header_id Transaction Header ID. This would be used to match
3673: * with rcv_serials_supply
3674: * @param p_serial Serial Number entered on the UI
3675: **/
3676: PROCEDURE get_rcv_lpn_serial_lov(
3677: x_serial_number OUT NOCOPY t_genref
3690: , 0
3691: , ''
3692: , ''
3693: FROM mtl_serial_numbers msn
3694: , rcv_serials_supply rss
3695: , rcv_supply rs
3696: WHERE msn.lpn_id = p_lpn_id
3697: AND msn.inventory_item_id = p_inventory_item_id
3698: AND msn.current_organization_id = p_organization_id
3947: , lot_number
3948: , 0
3949: , current_status
3950: , mms.status_code
3951: FROM rcv_serials_supply rss
3952: , rcv_shipment_lines rsl
3953: , mtl_serial_numbers msn
3954: , mtl_material_statuses_tl mms
3955: WHERE rss.shipment_line_id(+) = rsl.shipment_line_id