APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_SYSTEM_ITEMS_B

Line 2880: FROM mtl_system_items_b

2876: --start part 2 bug 12814511
2877: BEGIN
2878: SELECT lot_control_code,serial_number_control_code
2879: INTO l2_lot_code,l_serial_control_code1
2880: FROM mtl_system_items_b
2881: WHERE inventory_item_id = p_item_id
2882: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
2883: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);--bug13558642
2884:

Line 5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh

5114: , lpn.organization_id
5115: , msi.serial_number_control_code
5116: , msi.primary_uom_code
5117: , lpnc.secondary_quantity -- Bug 7708998
5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
5119: WHERE rsh.shipment_header_id = p_shipment_header_id
5120: AND((lpn.source_header_id = rsh.shipment_header_id)
5121: OR (lpn.source_header_id IS NULL AND lpn.source_name = rsh.shipment_num)) --BUG14846625/16711363
5122: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 9760: FROM mtl_system_items_b

9756: --start bug 12814511
9757: BEGIN
9758: SELECT lot_control_code
9759: INTO l_lot_code
9760: FROM mtl_system_items_b
9761: WHERE inventory_item_id = p_inventory_item_id
9762: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
9763: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);
9764: IF (l_debug = 1) THEN