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_ACTIVITYASSOCIATION_PVT dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 118: FROM mtl_eam_asset_activities_v meaa

114: meaa.owning_department_id, meaa.Activity_Cause_Code, meaa.Activity_Type_Code,
115: meaa.Activity_Source_Code, meaa.Tagging_Required_Flag, meaa.Shutdown_Type_Code
116: , meaa.Work_Order_Type, meaa.Planner_Maintenance AS planner, meaa.Plan_Maintenance AS planned -- added for 16525236
117: , meaa.Firm_Planned_Flag as firm, meaa.Notification_Required -- ended for 16525236
118: FROM mtl_eam_asset_activities_v meaa
119: WHERE meaa.asset_activity_id = p_source_activity_id
120: AND (p_maintenance_object_type IS NULL OR meaa.maintenance_object_type = p_maintenance_object_type)
121: AND (p_maintenance_object_id IS NULL OR meaa.maintenance_object_id = p_maintenance_object_id)
122: AND (p_tmpl_flag IS NULL OR NVL(meaa.template_flag, 'N') = p_tmpl_flag)

Line 516: UPDATE mtl_eam_asset_activities

512: INTO l_wo_dept_id, l_wo_wac, l_cur_maintenance_object_id, l_cur_maintenance_object_type, l_wo_priority, l_wo_tagout
513: FROM wip_discrete_jobs
514: WHERE wip_entity_id = p_wip_entity_id;
515:
516: UPDATE mtl_eam_asset_activities
517: SET priority_code = nvl(l_wo_priority, priority_code)
518: WHERE asset_activity_id = p_target_activity_id AND maintenance_object_id = l_cur_maintenance_object_id
519: AND maintenance_object_type = l_cur_maintenance_object_type;
520:

Line 526: FROM mtl_eam_asset_activities

522: SET accounting_class_code = nvl(l_wo_wac, accounting_class_code),
523: owning_department_id = nvl(l_wo_dept_id, owning_department_id),
524: tagging_required_flag = nvl(l_wo_tagout, tagging_required_flag)
525: WHERE object_id in (SELECT activity_association_id
526: FROM mtl_eam_asset_activities
527: WHERE asset_activity_id = p_target_activity_id
528: AND maintenance_object_id = l_cur_maintenance_object_id
529: AND maintenance_object_type = l_cur_maintenance_object_type)
530: AND object_type in (40, 60) AND organization_id = p_target_org_id;

Line 1262: from mtl_eam_asset_activities

1258: END IF;
1259:
1260: -- Check Unique
1261: select count(1) into l_count
1262: from mtl_eam_asset_activities
1263: where asset_activity_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
1264: and maintenance_object_id = l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_id
1265: and maintenance_object_type = l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_type;
1266: /*

Line 1313: SELECT mtl_eam_asset_activities_s.nextval

1309: -- Insert into database table
1310:
1311: BEGIN
1312: -- Get activity_association_id from sequence
1313: SELECT mtl_eam_asset_activities_s.nextval
1314: INTO l_act_assoc_tbl(l_act_assoc_tbl_index).activity_association_id
1315: FROM dual;
1316: EXCEPTION
1317: WHEN OTHERS THEN

Line 1333: -- Insert into Database Table mtl_eam_asset_activities

1329: GOTO next_in_loop;
1330: END;
1331:
1332: BEGIN
1333: -- Insert into Database Table mtl_eam_asset_activities
1334: INSERT INTO mtl_eam_asset_activities (
1335: Asset_Activity_Id,
1336: Start_Date_Active,
1337: End_Date_Active,

Line 1334: INSERT INTO mtl_eam_asset_activities (

1330: END;
1331:
1332: BEGIN
1333: -- Insert into Database Table mtl_eam_asset_activities
1334: INSERT INTO mtl_eam_asset_activities (
1335: Asset_Activity_Id,
1336: Start_Date_Active,
1337: End_Date_Active,
1338: Priority_Code,

Line 1592: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

1588: eomd.Activity_Cause_Code, eomd.Activity_Type_Code, eomd.Activity_Source_Code,
1589: eomd.Tagging_Required_Flag, eomd.Shutdown_Type_Code
1590: , eomd.Work_Order_Type, eomd.Planner_Maintenance AS planner, eomd.Plan_Maintenance AS planned -- added for 16525236
1591: , eomd.Firm_Planned_Flag as firm, eomd.Notification_Required -- ended for 16525236
1592: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
1593: WHERE maintenance_object_id = p_maintenance_object_id AND maintenance_object_type = 2
1594: AND tmpl_flag = 'Y' AND meaa.Activity_Association_Id = eomd.object_id(+) AND eomd.object_type(+) = 40
1595: AND eomd.organization_id(+) = p_organization_id;
1596: -- 2735563: Simply pick up ALL templates and copy the start and end dates to the association records

Line 1675: SELECT mtl_eam_asset_activities_s.nextval

1671: LOOP
1672: -- 1: Get activity_association_id from sequence
1673: BEGIN
1674: -- Get activity_association_id from sequence
1675: SELECT mtl_eam_asset_activities_s.nextval
1676: INTO l_next_association_id
1677: FROM dual;
1678: EXCEPTION
1679: WHEN OTHERS THEN

Line 1711: -- 2: Insert row into mtl_eam_asset_activities

1707: -- if present, else default from template
1708: l_class_code := nvl(p_class_code,l_asset_activity_row.accounting_class_code);
1709: l_owning_department_id := nvl(p_owning_department_id,l_asset_activity_row.Owning_Department_Id);
1710:
1711: -- 2: Insert row into mtl_eam_asset_activities
1712: BEGIN
1713: -- Insert into Database Table mtl_eam_asset_activities
1714: INSERT INTO mtl_eam_asset_activities (
1715: Asset_Activity_Id,

Line 1713: -- Insert into Database Table mtl_eam_asset_activities

1709: l_owning_department_id := nvl(p_owning_department_id,l_asset_activity_row.Owning_Department_Id);
1710:
1711: -- 2: Insert row into mtl_eam_asset_activities
1712: BEGIN
1713: -- Insert into Database Table mtl_eam_asset_activities
1714: INSERT INTO mtl_eam_asset_activities (
1715: Asset_Activity_Id,
1716: Start_Date_Active,
1717: End_Date_Active,

Line 1714: INSERT INTO mtl_eam_asset_activities (

1710:
1711: -- 2: Insert row into mtl_eam_asset_activities
1712: BEGIN
1713: -- Insert into Database Table mtl_eam_asset_activities
1714: INSERT INTO mtl_eam_asset_activities (
1715: Asset_Activity_Id,
1716: Start_Date_Active,
1717: End_Date_Active,
1718: Priority_Code,