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 263: FROM mtl_serial_numbers

259: if p_parent_in_eam = 'Y' then
260:
261: SELECT current_status, gen_object_id
262: INTO l_msn_status, l_gen_object_id
263: FROM mtl_serial_numbers
264: WHERE serial_number = p_serial_number
265: and current_organization_id = p_current_organization_id
266: and inventory_item_id = p_inventory_item_id;
267:

Line 269: FROM mtl_serial_numbers

265: and current_organization_id = p_current_organization_id
266: and inventory_item_id = p_inventory_item_id;
267:
268: SELECT gen_object_id INTO l_parent_object_id
269: FROM mtl_serial_numbers
270: WHERE serial_number = p_parent_serial_number
271: and inventory_item_id = p_parent_inventory_item_id;
272:
273:

Line 299: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

295: SELECT mog.start_date_active start_date_active,
296: mog.end_date_active
297: end_date_active, msn.serial_number
298: parent_serial_number
299: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
300: WHERE mog.object_id = l_gen_object_id
301: and msn.gen_object_id = mog.parent_object_id
302: and mog.genealogy_type = 5;
303: