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 669: ',mtl_system_items_b_kfv msi ';

665: IF p_forecast_rec.activity_from IS NOT NULL AND
666: p_forecast_rec.activity_to IS NOT NULL
667: THEN
668: l_sql_from := l_sql_from ||
669: ',mtl_system_items_b_kfv msi ';
670: l_sql_where := l_sql_where ||
671: 'AND msi.organization_id = wdj.organization_id ' ||
672: 'AND msi.inventory_item_id = wdj.primary_item_id ' ||
673: 'AND msi.eam_item_type(+) = 2 ' ||

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

902: -- If asset group criteria is specified, join with msi kfv
903:
904: IF p_asset_group_from IS NOT NULL AND p_asset_group_to IS NOT NULL
905: THEN
906: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
907: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
908: ELSE
909: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
910: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';

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

903:
904: IF p_asset_group_from IS NOT NULL AND p_asset_group_to IS NOT NULL
905: THEN
906: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
907: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
908: ELSE
909: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
910: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
911: END IF;

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

905: THEN
906: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
907: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
908: ELSE
909: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
910: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
911: END IF;
912:
913: debug('Inside get_asset_query 1', 2);

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

906: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b_kfv msi ';
907: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b_kfv msi ';
908: ELSE
909: l_sql_cii_from := l_sql_cii_from || ',mtl_system_items_b msi ';
910: l_sql_msi_from := l_sql_msi_from || ',mtl_system_items_b msi ';
911: END IF;
912:
913: debug('Inside get_asset_query 1', 2);
914: -- Join with mtl_locations to get area if the area criteria is specified

Line 2857: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi

2853: msi.inventory_item_id, msi.eam_item_type, fw.scheduled_start_date,
2854: fw.scheduled_completion_date, fw.organization_id organization_id,
2855: fw.pm_base_meter_reading
2856: from eam_forecasted_work_orders fw, mtl_eam_asset_activities meaa,
2857: eam_wo_statuses_v ewsv, csi_item_instances cii, mtl_system_items_b msi
2858: where group_id = l_group_id and
2859: fw.activity_association_id = meaa.activity_association_id and
2860: ewsv.status_id=fw.wo_status and meaa.maintenance_object_type = 3 and
2861: meaa.maintenance_object_id = cii.instance_id and cii.inventory_item_id =