DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on MTL_PARAMETERS

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 1299: mtl_parameters mp, eam_org_maint_defaults eomd

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
1303: and mp.maint_organization_id = p_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;