APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_SERIAL_NUMBERS

Line 689: FROM mtl_serial_numbers_interface

685: -- (For other docs, the value of l_msni_count would be 0).
686: IF (p_doc_type = 'INTSHIP') THEN
687: SELECT count(1)
688: INTO l_msni_count
689: FROM mtl_serial_numbers_interface
690: WHERE product_transaction_id = p_original_rti_id
691: AND product_code = 'RCV';
692: END IF;
693:

Line 721: UPDATE mtl_serial_numbers_interface

717: print_debug('Updated ' || SQL%ROWCOUNT || ' lot records', 4);
718: END IF;
719:
720: --For a lot and serial controlled item, update the MSNI records too
721: UPDATE mtl_serial_numbers_interface
722: SET product_transaction_id = l_interface_txn_id
723: WHERE product_code = 'RCV'
724: AND product_transaction_id = p_original_rti_id;
725:

Line 732: UPDATE mtl_serial_numbers_interface

728: END IF;
729:
730: ELSIF (p_serial_control_code > 1) THEN
731: --Update the serial interface records
732: UPDATE mtl_serial_numbers_interface
733: SET product_transaction_id = l_interface_txn_id
734: WHERE product_code = 'RCV'
735: AND product_transaction_id = p_original_rti_id;
736:

Line 2886: FROM mtl_serial_numbers

2882: BEGIN
2883:
2884: SELECT status_id
2885: INTO l_serial_status_id
2886: FROM mtl_serial_numbers
2887: WHERE serial_number = p_serial_number
2888: AND inventory_item_id = p_item_id;
2889:
2890: EXCEPTION

Line 2990: mtl_serial_numbers_interface msni

2986: rcv_transactions rt,
2987: rcv_serials_supply rss,
2988: rcv_shipment_lines rsl,
2989: rcv_shipment_headers rsh,
2990: mtl_serial_numbers_interface msni
2991: WHERE rs.item_id = p_item_id
2992: -- AND Nvl(rs.item_revision,nvl(p_revision,'@@@')) = nvl(p_revision,'@@@') BUG13562127
2993: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)
2994: AND rs.to_organization_id = p_organization_id

Line 3041: mtl_serial_numbers_interface msni,

3037: FROM rcv_supply rs,
3038: rcv_transactions rt,
3039: rcv_shipment_lines rsl,
3040: rcv_shipment_headers rsh,
3041: mtl_serial_numbers_interface msni,
3042: mtl_transaction_lots_interface mtli
3043: WHERE rs.item_id = p_item_id
3044: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)
3045: AND rs.to_organization_id = p_organization_id

Line 3657: mtl_serial_numbers_interface msni

3653: SELECT 'Y' INTO l_rss_exist FROM DUAL
3654: WHERE EXISTS
3655: (SELECT 1
3656: FROM rcv_serials_supply rss,
3657: mtl_serial_numbers_interface msni
3658: WHERE msni.product_code = 'RCV'
3659: AND msni.product_transaction_id = p_original_rti_id
3660: AND rss.serial_num between msni.fm_serial_number and msni.to_serial_number
3661: AND rss.supply_type_code = 'RECEIVING');