[Home] [Help]
913:
914: l_sql_msi_select := 'SELECT msi.inventory_item_id as asset_id, 2 as asset_type ';
915:
916:
917: l_sql_cii_from := 'FROM csi_item_instances cii,' ||
918: 'eam_org_maint_defaults eomd,' ||
919: 'mtl_parameters mp ';
920:
921: l_sql_msi_from := 'FROM mtl_parameters mp ';
3073: WHERE cebba.forecast_id = :6) efc,
3074: eam_forecast_wdj job, mtl_system_items_kfv msi,
3075: eam_forecasts ef, wip_entities entity,
3076: mtl_serial_numbers msn,
3077: csi_item_instances cii,
3078: mtl_eam_locations loc, mtl_system_items_kfv msi2,
3079: bom_departments bd, hr_organization_units hou,
3080: gl_code_combinations_kfv glcc,mfg_lookups mlWOtype
3081:
3191: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
3192: fw.scheduled_completion_date, fw.organization_id organization_id,
3193: fw.pm_base_meter_reading
3194: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
3195: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
3196: where group_id = l_group_id and
3197: fw.activity_association_id = meaa.activity_association_id and
3198: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
3199: meaa.maintenance_object_id = cii.instance_id and cii.inventory_item_id =