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.

[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

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 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 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 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 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 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 1489: FROM EAM_ORG_MAINT_DEFAULTS EOMD

1485: AND NVL(MEAA.tmpl_flag,'N') = 'N';
1486:
1487: SELECT EOMD.OWNING_DEPARTMENT_ID
1488: INTO x_owning_department_id
1489: FROM EAM_ORG_MAINT_DEFAULTS EOMD
1490: WHERE EOMD.organization_id = p_organization_id
1491: AND EOMD.OBJECT_ID = l_act_assoc_id
1492: AND EOMD.OBJECT_TYPE IN (40,60) ;
1493: EXCEPTION

Line 1506: FROM EAM_ORG_MAINT_DEFAULTS EOMD

1502: IF (x_owning_department_id IS NULL AND p_maintenance_object_type = 3) THEN
1503: BEGIN
1504: SELECT EOMD.OWNING_DEPARTMENT_ID
1505: INTO x_owning_department_id
1506: FROM EAM_ORG_MAINT_DEFAULTS EOMD
1507: WHERE EOMD.organization_id = p_organization_id
1508: AND EOMD.OBJECT_ID = p_maintenance_object_id
1509: AND EOMD.OBJECT_TYPE = 50 ;
1510: EXCEPTION

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