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 489: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

485: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
486: BEGIN
487: SELECT MEAA.activity_cause_code
488: INTO x_activity_cause_code
489: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
490: WHERE MEAA.organization_id = p_organization_id
491: AND MEAA.asset_activity_id = p_primary_item_id
492: AND MEAA.maintenance_object_id = p_maintenance_object_id
493: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 506: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

502: BEGIN
503: --Begin bug fix 7343758
504: /*SELECT MEAA.activity_cause_code
505: INTO x_activity_cause_code
506: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
507: WHERE MEAA.organization_id = p_organization_id
508: AND MEAA.asset_activity_id = p_primary_item_id
509: AND MEAA.maintenance_object_id = p_rebuild_item_id
510: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line 513: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

509: AND MEAA.maintenance_object_id = p_rebuild_item_id
510: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/
511: SELECT eomd.activity_cause_code
512: INTO x_activity_cause_code
513: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
514: WHERE eomd.organization_id=p_organization_id
515: AND eomd.object_type = 60
516: AND eomd.object_id = meaa.activity_association_id
517: AND MEAA.asset_activity_id = p_primary_item_id

Line 716: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

712: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
713: BEGIN
714: SELECT MEAA.activity_type_code
715: INTO x_activity_type_code
716: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
717: WHERE MEAA.organization_id = p_organization_id
718: AND MEAA.asset_activity_id = p_primary_item_id
719: AND MEAA.maintenance_object_id = p_maintenance_object_id
720: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 733: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

729: BEGIN
730: --Begin bug fix 7343758
731: /*SELECT MEAA.activity_type_code
732: INTO x_activity_type_code
733: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
734: WHERE MEAA.organization_id = p_organization_id
735: AND MEAA.asset_activity_id = p_primary_item_id
736: AND MEAA.maintenance_object_id = p_rebuild_item_id
737: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line 740: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

736: AND MEAA.maintenance_object_id = p_rebuild_item_id
737: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/
738: SELECT eomd.activity_type_code
739: INTO x_activity_type_code
740: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
741: WHERE eomd.organization_id=p_organization_id
742: AND eomd.object_type = 60
743: AND eomd.object_id = meaa.activity_association_id
744: AND MEAA.asset_activity_id = p_primary_item_id

Line 867: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

863: IF (p_maintenance_object_type IN (1, 2) ) THEN -- 'MSN', 'MSI'
864: BEGIN
865: SELECT MEAA.activity_source_code
866: INTO x_activity_source_code
867: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
868: WHERE MEAA.organization_id = p_organization_id
869: AND MEAA.asset_activity_id = p_primary_item_id
870: AND MEAA.maintenance_object_id = p_maintenance_object_id
871: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 884: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

880: BEGIN
881: --Begin bug fix 7343758
882: /* SELECT MEAA.activity_source_code
883: INTO x_activity_source_code
884: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
885: WHERE MEAA.organization_id = p_organization_id
886: AND MEAA.asset_activity_id = p_primary_item_id
887: AND MEAA.maintenance_object_id = p_rebuild_item_id
888: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line 891: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

887: AND MEAA.maintenance_object_id = p_rebuild_item_id
888: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/
889: SELECT eomd.activity_source_code
890: INTO x_activity_source_code
891: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
892: WHERE eomd.organization_id=p_organization_id
893: AND eomd.object_type = 60
894: AND eomd.object_id = meaa.activity_association_id
895: AND MEAA.asset_activity_id = p_primary_item_id

Line 1017: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1013: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
1014: BEGIN
1015: SELECT MEAA.shutdown_type_code
1016: INTO x_shutdown_type_code
1017: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1018: WHERE MEAA.organization_id = p_organization_id
1019: AND MEAA.asset_activity_id = p_primary_item_id
1020: AND MEAA.maintenance_object_id = p_maintenance_object_id
1021: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 1034: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1030: BEGIN
1031: --Begin bug fix 7343758
1032: /* SELECT MEAA.shutdown_type_code
1033: INTO x_shutdown_type_code
1034: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1035: WHERE MEAA.organization_id = p_organization_id
1036: AND MEAA.asset_activity_id = p_primary_item_id
1037: AND MEAA.maintenance_object_id = p_rebuild_item_id
1038: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line 1042: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1038: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/
1039:
1040: SELECT eomd.shutdown_type_code
1041: INTO x_shutdown_type_code
1042: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1043: WHERE eomd.organization_id=p_organization_id
1044: AND eomd.object_type = 60
1045: AND eomd.object_id = meaa.activity_association_id
1046: AND MEAA.asset_activity_id = p_primary_item_id

Line 1170: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1166: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
1167: BEGIN
1168: SELECT MEAA.notification_required
1169: INTO x_notification_flag
1170: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1171: WHERE MEAA.organization_id = p_organization_id
1172: AND MEAA.asset_activity_id = p_primary_item_id
1173: AND MEAA.maintenance_object_id = p_maintenance_object_id
1174: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 1186: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1182: IF (p_maintenance_object_type = 3) THEN -- 'CII'
1183: BEGIN
1184: SELECT MEAA.notification_required
1185: INTO x_notification_flag
1186: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1187: WHERE MEAA.organization_id = p_organization_id
1188: AND MEAA.asset_activity_id = p_primary_item_id
1189: AND MEAA.maintenance_object_id = p_rebuild_item_id
1190: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'

Line 1204: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1200: /*WO Defaults ER*/
1201: BEGIN
1202: SELECT eomd.notification_required
1203: INTO x_notification_flag
1204: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1205: WHERE eomd.organization_id=p_organization_id
1206: AND eomd.object_type = 60
1207: AND eomd.object_id = meaa.activity_association_id
1208: AND MEAA.asset_activity_id = p_primary_item_id

Line 1328: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1324: IF (p_maintenance_object_type IN (1,2) ) THEN -- 'MSN', 'MSI'
1325: BEGIN
1326: SELECT MEAA.tagging_required_flag
1327: INTO x_tagout_required
1328: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1329: WHERE MEAA.organization_id = p_organization_id
1330: AND MEAA.asset_activity_id = p_primary_item_id
1331: AND MEAA.maintenance_object_id = p_maintenance_object_id
1332: AND MEAA.maintenance_object_type = p_maintenance_object_type

Line 1345: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1341: BEGIN
1342: /*Begin fix for 8287895*
1343: SELECT MEAA.tagging_required_flag
1344: INTO x_tagout_required
1345: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1346: WHERE MEAA.organization_id = p_organization_id
1347: AND MEAA.asset_activity_id = p_primary_item_id
1348: AND MEAA.maintenance_object_id = p_rebuild_item_id
1349: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/

Line 1353: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1349: AND MEAA.maintenance_object_type = 2 ;-- 'MSI'*/
1350:
1351: SELECT eomd.tagging_required_flag
1352: INTO x_tagout_required
1353: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1354: WHERE eomd.organization_id=p_organization_id
1355: AND eomd.object_type = 60
1356: AND eomd.object_id = meaa.activity_association_id
1357: AND MEAA.asset_activity_id = p_primary_item_id

Line 1466: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1462: IF (p_maintenance_object_type = 1 ) THEN -- 'MSN', 'MSI'
1463: BEGIN
1464: SELECT MEAA.owning_department_id
1465: INTO x_owning_department_id
1466: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1467: WHERE MEAA.asset_activity_id = p_primary_item_id
1468: AND MEAA.maintenance_object_id = p_maintenance_object_id
1469: AND MEAA.maintenance_object_type = p_maintenance_object_type
1470: AND NVL(MEAA.tmpl_flag,'N') = 'N';

Line 1481: FROM MTL_EAM_ASSET_ACTIVITIES MEAA

1477: IF (p_maintenance_object_type IN( 2,3) ) THEN -- 'CII'
1478: BEGIN
1479: SELECT MEAA.activity_association_id
1480: INTO l_act_assoc_id
1481: FROM MTL_EAM_ASSET_ACTIVITIES MEAA
1482: WHERE MEAA.asset_activity_id = p_primary_item_id
1483: AND MEAA.maintenance_object_id = p_maintenance_object_id
1484: AND MEAA.maintenance_object_type = p_maintenance_object_type
1485: AND NVL(MEAA.tmpl_flag,'N') = 'N';

Line 1625: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1621: -- IF (p_maintenance_object_type IN( 2,3) ) THEN -- 'CII'
1622: BEGIN
1623: SELECT eomd.work_order_type
1624: INTO x_ACT_WO_Type
1625: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1626: WHERE eomd.organization_id=p_organization_id
1627: AND eomd.object_type = 60
1628: AND eomd.object_id = meaa.activity_association_id
1629: AND MEAA.asset_activity_id = p_primary_item_id

Line 1727: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1723:
1724: BEGIN
1725: SELECT eomd.planner_maintenance
1726: INTO x_ACT_Planner
1727: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1728: WHERE eomd.organization_id=p_organization_id
1729: AND eomd.object_type = 60
1730: AND eomd.object_id = meaa.activity_association_id
1731: AND MEAA.asset_activity_id = p_primary_item_id

Line 1828: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1824:
1825: BEGIN
1826: SELECT eomd.firm_planned_flag
1827: INTO x_ACT_Firm
1828: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1829: WHERE eomd.organization_id=p_organization_id
1830: AND eomd.object_type = 60
1831: AND eomd.object_id = meaa.activity_association_id
1832: AND MEAA.asset_activity_id = p_primary_item_id

Line 1929: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA

1925:
1926: BEGIN
1927: SELECT eomd.plan_maintenance
1928: INTO x_ACT_Planned
1929: FROM eam_org_maint_defaults eomd, mtl_eam_asset_activities MEAA
1930: WHERE eomd.organization_id=p_organization_id
1931: AND eomd.object_type = 60
1932: AND eomd.object_id = meaa.activity_association_id
1933: AND MEAA.asset_activity_id = p_primary_item_id