DBA Data[Home] [Help]

APPS.EAM_ASSET_ROUTES_PUB dependencies on MTL_SYSTEM_ITEMS

Line 71: FROM mtl_system_items MSI , mtl_serial_numbers MSN

67: BEGIN
68: IF (p_maintenance_object_type = 1) THEN
69: IF ( p_asset_number IS NOT NULL ) THEN
70: SELECT count(*) INTO l_count_rec
71: FROM mtl_system_items MSI , mtl_serial_numbers MSN
72: WHERE MSN.serial_number = p_asset_number
73: AND MSN.gen_object_id = p_maintenance_object_id
74: AND MSN.inventory_item_id = MSI.inventory_item_id
75: AND MSI.inventory_item_id = p_asset_group_id

Line 83: FROM mtl_system_items

79: ELSIF (p_maintenance_object_type = 2) THEN
80: IF ((p_asset_number IS NULL) AND
81: (p_maintenance_object_id = p_asset_group_id)) THEN
82: SELECT count(*) INTO l_count_rec
83: FROM mtl_system_items
84: WHERE inventory_item_id = p_asset_group_id
85: AND organization_id = p_creation_organization_id;
86: END IF;
87:

Line 129: mtl_system_items_b msi

125: SELECT
126: msn.gen_object_id
127: FROM
128: mtl_serial_numbers msn,
129: mtl_system_items_b msi
130: WHERE
131: msn.inventory_item_id = p_inventory_item_id and
132: msn.serial_number= p_serial_number and
133: msn.current_organization_id = p_organization_id and