APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 3336: FROM mtl_serial_numbers_interface

3332: IF (p_lot_control_code > 1 AND p_serial_control_code = 6) THEN
3333: BEGIN
3334: SELECT count(1)
3335: INTO l_msni_count
3336: FROM mtl_serial_numbers_interface
3337: WHERE product_transaction_id = p_transaction_temp_id
3338: AND product_code = 'RCV';
3339:
3340: IF (l_debug = 1) THEN

Line 5489: mtl_serial_numbers_interface msni

5485: rcv_transactions rt,
5486: rcv_serials_supply rss,
5487: rcv_shipment_lines rsl,
5488: rcv_shipment_headers rsh,
5489: mtl_serial_numbers_interface msni
5490: WHERE rs.item_id = p_item_id
5491: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5492: AND (p_revision is null or rs.item_revision = p_revision)
5493: AND rs.to_organization_id = p_organization_id