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.WIP_EAMWORKORDER_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 446: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

442: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
443: BEGIN
444: SELECT MEAA.activity_cause_code
445: INTO x_activity_cause_code
446: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
447: WHERE MEAA.organization_id = p_organization_id
448: AND MEAA.asset_activity_id = p_primary_item_id
449: AND MEAA.maintenance_object_id = p_maintenance_object_id
450: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 462: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

458: IF (p_maintenance_object_type = 3) THEN -- 'CII'
459: BEGIN
460: SELECT MEAA.activity_cause_code
461: INTO x_activity_cause_code
462: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
463: WHERE MEAA.organization_id = p_organization_id
464: AND MEAA.asset_activity_id = p_primary_item_id
465: AND MEAA.maintenance_object_id = p_rebuild_item_id
466: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 662: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

658: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
659: BEGIN
660: SELECT MEAA.activity_type_code
661: INTO x_activity_type_code
662: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
663: WHERE MEAA.organization_id = p_organization_id
664: AND MEAA.asset_activity_id = p_primary_item_id
665: AND MEAA.maintenance_object_id = p_maintenance_object_id
666: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 678: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

674: IF (p_maintenance_object_type = 3) THEN -- 'CII'
675: BEGIN
676: SELECT MEAA.activity_type_code
677: INTO x_activity_type_code
678: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
679: WHERE MEAA.organization_id = p_organization_id
680: AND MEAA.asset_activity_id = p_primary_item_id
681: AND MEAA.maintenance_object_id = p_rebuild_item_id
682: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 802: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

798: IF (p_maintenance_object_type IN (1, 2) ) THEN -- 'MSN', 'MSI'
799: BEGIN
800: SELECT MEAA.activity_source_code
801: INTO x_activity_source_code
802: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
803: WHERE MEAA.organization_id = p_organization_id
804: AND MEAA.asset_activity_id = p_primary_item_id
805: AND MEAA.maintenance_object_id = p_maintenance_object_id
806: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 818: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

814: IF (p_maintenance_object_type = 3) THEN -- 'CII'
815: BEGIN
816: SELECT MEAA.activity_source_code
817: INTO x_activity_source_code
818: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
819: WHERE MEAA.organization_id = p_organization_id
820: AND MEAA.asset_activity_id = p_primary_item_id
821: AND MEAA.maintenance_object_id = p_rebuild_item_id
822: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 941: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

937: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
938: BEGIN
939: SELECT MEAA.shutdown_type_code
940: INTO x_shutdown_type_code
941: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
942: WHERE MEAA.organization_id = p_organization_id
943: AND MEAA.asset_activity_id = p_primary_item_id
944: AND MEAA.maintenance_object_id = p_maintenance_object_id
945: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 957: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

953: IF (p_maintenance_object_type = 3) THEN -- 'CII'
954: BEGIN
955: SELECT MEAA.shutdown_type_code
956: INTO x_shutdown_type_code
957: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
958: WHERE MEAA.organization_id = p_organization_id
959: AND MEAA.asset_activity_id = p_primary_item_id
960: AND MEAA.maintenance_object_id = p_rebuild_item_id
961: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 1081: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1077: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
1078: BEGIN
1079: SELECT MEAA.notification_required
1080: INTO x_notification_flag
1081: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1082: WHERE MEAA.organization_id = p_organization_id
1083: AND MEAA.asset_activity_id = p_primary_item_id
1084: AND MEAA.maintenance_object_id = p_maintenance_object_id
1085: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 1097: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1093: IF (p_maintenance_object_type = 3) THEN -- 'CII'
1094: BEGIN
1095: SELECT MEAA.notification_required
1096: INTO x_notification_flag
1097: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1098: WHERE MEAA.organization_id = p_organization_id
1099: AND MEAA.asset_activity_id = p_primary_item_id
1100: AND MEAA.maintenance_object_id = p_rebuild_item_id
1101: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 1221: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1217: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
1218: BEGIN
1219: SELECT MEAA.tagging_required_flag
1220: INTO x_tagout_required
1221: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1222: WHERE MEAA.organization_id = p_organization_id
1223: AND MEAA.asset_activity_id = p_primary_item_id
1224: AND MEAA.maintenance_object_id = p_maintenance_object_id
1225: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 1237: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1233: IF (p_maintenance_object_type = 3) THEN -- 'CII'
1234: BEGIN
1235: SELECT MEAA.tagging_required_flag
1236: INTO x_tagout_required
1237: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1238: WHERE MEAA.organization_id = p_organization_id
1239: AND MEAA.asset_activity_id = p_primary_item_id
1240: AND MEAA.maintenance_object_id = p_rebuild_item_id
1241: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 1346: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1342: IF (p_maintenance_object_type = 1 ) THEN -- 'MSN', 'MSI'
1343: BEGIN
1344: SELECT MEAA.owning_department_id
1345: INTO x_owning_department_id
1346: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1347: WHERE MEAA.asset_activity_id = p_primary_item_id
1348: AND MEAA.maintenance_object_id = p_maintenance_object_id
1349: AND MEAA.maintenance_object_type = p_maintenance_object_type
1350: AND NVL(MEAA.tmpl_flag,'N') = 'N';

Line 1361: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1357: IF (p_maintenance_object_type IN( 2,3) ) THEN -- 'CII'
1358: BEGIN
1359: SELECT MEAA.activity_association_id
1360: INTO l_act_assoc_id
1361: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1362: WHERE MEAA.asset_activity_id = p_primary_item_id
1363: AND MEAA.maintenance_object_id = p_maintenance_object_id
1364: AND MEAA.maintenance_object_type = p_maintenance_object_type
1365: AND NVL(MEAA.tmpl_flag,'N') = 'N';