eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_FORECAST_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 690: ',mtl_system_items_b_kfv msi ';

686: IF p_forecast_rec.activity_from IS NOT NULL AND
687: p_forecast_rec.activity_to IS NOT NULL
688: THEN
689: l_sql_from := l_sql_from ||
690: ',mtl_system_items_b_kfv msi ';
691: l_sql_where := l_sql_where ||
692: 'AND msi.organization_id = wdj.organization_id ' ||
693: 'AND msi.inventory_item_id = wdj.primary_item_id ' ||
694: 'AND msi.eam_item_type(+) = 2 ' ||

Line 927: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';

923: -- If asset group criteria is specified, join with msi kfv
924:
925: IF p_asset_group_from IS NOT NULL AND p_asset_group_to IS NOT NULL
926: THEN
927: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
928: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
929: ELSE
930: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
931: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';

Line 928: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';

924:
925: IF p_asset_group_from IS NOT NULL AND p_asset_group_to IS NOT NULL
926: THEN
927: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
928: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
929: ELSE
930: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
931: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
932: END IF;

Line 930: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';

926: THEN
927: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
928: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
929: ELSE
930: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
931: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
932: END IF;
933:
934: debug('Inside get_asset_query 1', 2);

Line 931: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';

927: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
928: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
929: ELSE
930: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
931: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
932: END IF;
933:
934: debug('Inside get_asset_query 1', 2);
935: -- Join with mtl_locations to get area if the area criteria is specified

Line 3195: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi

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 =