DBA Data[Home] [Help]

APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 272: FROM MTL_SYSTEM_ITEMS_B_KFV

268: IF p_organization_id IS NULL OR p_inventory_item_id IS NULL THEN
269: RETURN NULL;
270: ELSE
271: SELECT concatenated_segments INTO l_item_concatenated_segments
272: FROM MTL_SYSTEM_ITEMS_B_KFV
273: WHERE organization_id = p_organization_id
274: AND inventory_item_id = p_inventory_item_id;
275:
276: RETURN l_item_concatenated_segments;

Line 792: from mtl_system_items

788: l_count number;
789: begin
790:
791: select count(*) into l_count
792: from mtl_system_items
793: where inventory_item_id = p_inventory_item_id;
794:
795: if l_count >= 1 then
796: x_maintenance_object_id := p_inventory_item_id;

Line 1241: FROM mtl_system_items msi, mtl_parameters mp

1237: RETURN NULL;
1238: ELSE
1239: SELECT msi.serial_number_control_code
1240: INTO l_serial_number_control_code
1241: FROM mtl_system_items msi, mtl_parameters mp
1242: WHERE mp.maint_organization_id = p_organization_id
1243: AND mp.organization_id = msi.organization_id
1244: AND msi.inventory_item_id = p_maint_id
1245: AND ROWNUM = 1;

Line 1666: SELECT count(inventory_item_id) into l_count FROM mtl_system_items_b

1662: )
1663: RETURN BOOLEAN IS
1664: l_count number;
1665: BEGIN
1666: SELECT count(inventory_item_id) into l_count FROM mtl_system_items_b
1667: WHERE organization_id = p_org_id AND inventory_item_id = p_activity_id
1668: AND eam_item_type = 2;
1669:
1670: IF l_count = 0 THEN