eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_EXP_TO_EAM_PVT dependencies on MTL_EAM_ASSET_NUM_INTERFACE

Line 18: l_serial_num mtl_eam_asset_num_interface.serial_number%TYPE;

14: p_maintainable_flag IN mtl_serial_numbers.maintainable_flag%TYPE)
15: IS
16:
17: location_rec pn_locations_all%ROWTYPE;
18: l_serial_num mtl_eam_asset_num_interface.serial_number%TYPE;
19: l_query VARCHAR2(4000);
20: l_where_clause VARCHAR2(1000);
21: l_industry VARCHAR2(30);
22: l_installation_status VARCHAR2(5);

Line 41: l_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE;

37: l_count INTEGER;
38: l_locn_type VARCHAR2(30);
39: l_locn_code_from VARCHAR2(90);
40: l_locn_code_to VARCHAR2(90);
41: l_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE;
42: l_parent_inv_id mtl_eam_asset_num_interface.parent_inventory_item_id%TYPE; /* 8607381 */
43:
44: -- Bug 9347599
45: CURSOR get_inv_item_id(c_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE)

Line 42: l_parent_inv_id mtl_eam_asset_num_interface.parent_inventory_item_id%TYPE; /* 8607381 */

38: l_locn_type VARCHAR2(30);
39: l_locn_code_from VARCHAR2(90);
40: l_locn_code_to VARCHAR2(90);
41: l_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE;
42: l_parent_inv_id mtl_eam_asset_num_interface.parent_inventory_item_id%TYPE; /* 8607381 */
43:
44: -- Bug 9347599
45: CURSOR get_inv_item_id(c_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE)
46: IS

Line 45: CURSOR get_inv_item_id(c_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE)

41: l_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE;
42: l_parent_inv_id mtl_eam_asset_num_interface.parent_inventory_item_id%TYPE; /* 8607381 */
43:
44: -- Bug 9347599
45: CURSOR get_inv_item_id(c_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE)
46: IS
47: SELECT inventory_item_id
48: FROM mtl_eam_asset_num_interface
49: WHERE instance_number = c_parent_instance_number;

Line 48: FROM mtl_eam_asset_num_interface

44: -- Bug 9347599
45: CURSOR get_inv_item_id(c_parent_instance_number mtl_eam_asset_num_interface.parent_instance_number%TYPE)
46: IS
47: SELECT inventory_item_id
48: FROM mtl_eam_asset_num_interface
49: WHERE instance_number = c_parent_instance_number;
50:
51: BEGIN
52:

Line 138: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';

134: l_query := l_query || l_where_clause;
135: END IF;
136:
137: l_query := l_query || ' ORDER BY location_id ';
138: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';
139: pnp_debug_pkg.log(l_info);
140:
141: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
142:

Line 243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';

239: l_serial_num := location_rec.location_code;
240: END IF;
241:
242:
243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
244:
245: fnd_message.set_name ('PN','PN_XPEAM_INS');
246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
247: l_message := fnd_message.get;

Line 246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');

242:
243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
244:
245: fnd_message.set_name ('PN','PN_XPEAM_INS');
246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
247: l_message := fnd_message.get;
248: pnp_debug_pkg.put_log_msg(l_message);
249:
250:

Line 261: from mtl_eam_asset_num_interface

257: /* Commented for bug 9347599
258: IF l_parent_instance_number is not null then
259: select inventory_item_id
260: into l_parent_inv_id
261: from mtl_eam_asset_num_interface
262: where instance_number = l_parent_instance_number;
263: else
264: l_parent_inv_id := NULL;
265: END IF;

Line 275: INSERT INTO mtl_eam_asset_num_interface(

271: FETCH get_inv_item_id INTO l_parent_inv_id;
272: CLOSE get_inv_item_id;
273: END IF;
274:
275: INSERT INTO mtl_eam_asset_num_interface(
276: inventory_item_id,
277: serial_number,
278: interface_header_id,
279: import_mode,