APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;

4439: l_error_msg VARCHAR2(240);
4440: l_error_code VARCHAR2(240);
4441:
4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;
4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;
4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4445:
4446: -- Record Type variables
4447: l_x_mtltfr_rec Ahl_Mtltfr_Rec_Type; -- record type variable for storing each item record

Line 4459: MTL_SERIAL_NUMBERS_INTERFACE sni

4455: kfv.concatenated_segments,
4456: sni.FM_SERIAL_NUMBER
4457: FROM MTL_TRANSACTIONS_INTERFACE INTF,
4458: mtl_system_items_kfv kfv,
4459: MTL_SERIAL_NUMBERS_INTERFACE sni
4460: WHERE intf.TRANSACTION_INTERFACE_ID = p_txn_Id
4461: AND intf.inventory_item_id = kfv.inventory_item_id
4462: AND intf.organization_id = kfv.organization_id
4463: AND intf.TRANSACTION_INTERFACE_ID = sni.transaction_interface_id;

Line 4907: INTO MTL_SERIAL_NUMBERS_INTERFACE

4903: CLOSE get_serial_dff_attrib;
4904:
4905: G_DEBUG_LINE_NUM := 250;
4906: INSERT
4907: INTO MTL_SERIAL_NUMBERS_INTERFACE
4908: (
4909: TRANSACTION_INTERFACE_ID,
4910: SOURCE_CODE,
4911: SOURCE_LINE_ID,