APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on MTL_SERIAL_NUMBERS

Line 11: -- assets and their extensible attributes into MTL_SERIAL_NUMBERS and

7: -- Pre-reqs : None.
8: -- FILENAME : EAMPANIB.pls
9: -- DESCRIPTION
10: -- PL/SQL body for package EAM_ASSET_NUM_IMPORT_PUB. This public API imports
11: -- assets and their extensible attributes into MTL_SERIAL_NUMBERS and
12: -- MTL_EAM_ASSET_ATTR_VALUES. The import process is controlled by two
13: -- fields: SCOPE and MODE. These fields exist at the row level.
14: -- SCOPE implies what you want to import:
15: -- 0: Import both ASSETS and their EXTENSIBLE ATTRIBUTES

Line 257: FROM mtl_serial_numbers

253: if p_parent_in_eam = 'Y' then
254:
255: SELECT current_status, gen_object_id
256: INTO l_msn_status, l_gen_object_id
257: FROM mtl_serial_numbers
258: WHERE serial_number = p_serial_number
259: and current_organization_id = p_current_organization_id
260: and inventory_item_id = p_inventory_item_id;
261:

Line 263: FROM mtl_serial_numbers

259: and current_organization_id = p_current_organization_id
260: and inventory_item_id = p_inventory_item_id;
261:
262: SELECT gen_object_id INTO l_parent_object_id
263: FROM mtl_serial_numbers
264: WHERE serial_number = p_parent_serial_number
265: and inventory_item_id = p_parent_inventory_item_id;
266:
267:

Line 293: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

289: SELECT mog.start_date_active start_date_active,
290: mog.end_date_active
291: end_date_active, msn.serial_number
292: parent_serial_number
293: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
294: WHERE mog.object_id = l_gen_object_id
295: and msn.gen_object_id = mog.parent_object_id
296: and mog.genealogy_type = 5;
297: