APPS.EAM_WORKORDERS_JSP dependencies on MTL_SYSTEM_ITEMS_B

Line 622: select 1 into l_Dummy from mtl_system_items_b msi

618: if(p_subinventory IS NOT NULL) then
619:
620: if (p_serial is null) then
621: begin
622: select 1 into l_Dummy from mtl_system_items_b msi
623: where msi.inventory_item_id = p_item_id
624: and msi.organization_id = p_org_id;
625:
626: exception

Line 651: mtl_system_items_b

647:
648: select
649: lot_control_code into l_lot_ctrl_code
650: from
651: mtl_system_items_b
652: where
653: inventory_item_id = p_item_id
654: and organization_id = p_org_id ;
655:

Line 1262: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp

1258: if(p_asset_number is not null) then
1259: select nvl(cii.active_start_date, sysdate-1),
1260: nvl(cii.active_start_date, sysdate-1),msikfv.eam_item_type
1261: into l_start_date, l_end_date, l_eam_item_type
1262: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp
1263: where cii.inventory_item_id =msikfv.inventory_item_id
1264: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1265: and cii.last_vld_organization_id = mp.organization_id
1266: and mp.maint_organization_id = p_organization_id

Line 1298: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,

1294: if (p_asset_number is not null) then
1295: select cii.inventory_item_id , eomd.ACCOUNTING_CLASS_CODE,
1296: cii.instance_id, msikfv.eam_item_type , eomd.area_id
1297: into l_asset_group_id, l_asset_class, l_maintenance_object_id, l_eam_item_type , l_eam_location_id
1298: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,
1299: mtl_parameters mp, eam_org_maint_defaults eomd
1300: where cii.inventory_item_id =msikfv.inventory_item_id
1301: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1302: and cii.last_vld_organization_id = mp.organization_id

Line 1318: from mtl_system_items_b_kfv msikfv, mtl_parameters mp

1314: begin
1315: -- Changes by amondal for New Work Order API
1316: select msikfv.inventory_item_id, msikfv.eam_item_type, msikfv.serial_number_control_code
1317: into l_asset_group_id, l_eam_item_type, l_serial_number_control
1318: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
1319: where msikfv.organization_id=mp.organization_id
1320: and mp.maint_organization_id = p_organization_id
1321: and msikfv.CONCATENATED_SEGMENTS = p_asset_group
1322: and rownum = 1;

Line 1434: from mtl_system_items_b_kfv

1430: if p_asset_activity is not null then
1431: -- See whether it is a valid asset activity
1432:
1433: select inventory_item_id into l_asset_activity_id
1434: from mtl_system_items_b_kfv
1435: where concatenated_segments = p_asset_activity
1436: and eam_item_type = 2
1437: and organization_id = p_organization_id;
1438: end if;