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 102: FROM mtl_eam_asset_activities_v meaa

98: meaa.Attribute15,
99: meaa.Activity_Association_Id, meaa.organization_id, meaa.accounting_class_code,
100: meaa.owning_department_id, meaa.Activity_Cause_Code, meaa.Activity_Type_Code,
101: meaa.Activity_Source_Code, meaa.Tagging_Required_Flag, meaa.Shutdown_Type_Code
102: FROM mtl_eam_asset_activities_v meaa
103: WHERE meaa.asset_activity_id = p_source_activity_id
104: AND (p_maintenance_object_type IS NULL OR meaa.maintenance_object_type = p_maintenance_object_type)
105: AND (p_maintenance_object_id IS NULL OR meaa.maintenance_object_id = p_maintenance_object_id)
106: AND (p_tmpl_flag IS NULL OR NVL(meaa.template_flag, 'N') = p_tmpl_flag)

Line 491: UPDATE mtl_eam_asset_activities

487: INTO l_wo_dept_id, l_wo_wac, l_cur_maintenance_object_id, l_cur_maintenance_object_type, l_wo_priority, l_wo_tagout
488: FROM wip_discrete_jobs
489: WHERE wip_entity_id = p_wip_entity_id;
490:
491: UPDATE mtl_eam_asset_activities
492: SET priority_code = nvl(l_wo_priority, priority_code)
493: WHERE asset_activity_id = p_target_activity_id AND maintenance_object_id = l_cur_maintenance_object_id
494: AND maintenance_object_type = l_cur_maintenance_object_type;
495:

Line 501: FROM mtl_eam_asset_activities

497: SET accounting_class_code = nvl(l_wo_wac, accounting_class_code),
498: owning_department_id = nvl(l_wo_dept_id, owning_department_id),
499: tagging_required_flag = nvl(l_wo_tagout, tagging_required_flag)
500: WHERE object_id in (SELECT activity_association_id
501: FROM mtl_eam_asset_activities
502: WHERE asset_activity_id = p_target_activity_id
503: AND maintenance_object_id = l_cur_maintenance_object_id
504: AND maintenance_object_type = l_cur_maintenance_object_type)
505: AND object_type in (40, 60) AND organization_id = p_target_org_id;

Line 1181: from mtl_eam_asset_activities

1177: END IF;
1178:
1179: -- Check Unique
1180: select count(1) into l_count
1181: from mtl_eam_asset_activities
1182: where asset_activity_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
1183: and maintenance_object_id = l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_id
1184: and maintenance_object_type = l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_type;
1185: /*

Line 1232: SELECT mtl_eam_asset_activities_s.nextval

1228: -- Insert into database table
1229:
1230: BEGIN
1231: -- Get activity_association_id from sequence
1232: SELECT mtl_eam_asset_activities_s.nextval
1233: INTO l_act_assoc_tbl(l_act_assoc_tbl_index).activity_association_id
1234: FROM dual;
1235: EXCEPTION
1236: WHEN OTHERS THEN

Line 1252: -- Insert into Database Table mtl_eam_asset_activities

1248: GOTO next_in_loop;
1249: END;
1250:
1251: BEGIN
1252: -- Insert into Database Table mtl_eam_asset_activities
1253: INSERT INTO mtl_eam_asset_activities (
1254: Asset_Activity_Id,
1255: Start_Date_Active,
1256: End_Date_Active,

Line 1253: INSERT INTO mtl_eam_asset_activities (

1249: END;
1250:
1251: BEGIN
1252: -- Insert into Database Table mtl_eam_asset_activities
1253: INSERT INTO mtl_eam_asset_activities (
1254: Asset_Activity_Id,
1255: Start_Date_Active,
1256: End_Date_Active,
1257: Priority_Code,

Line 1504: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

1500: meaa.Prev_Scheduled_Start_Date, meaa.Prev_Scheduled_End_Date,
1501: meaa.Activity_Association_Id, eomd.organization_id, eomd.accounting_class_code, eomd.owning_department_id,
1502: eomd.Activity_Cause_Code, eomd.Activity_Type_Code, eomd.Activity_Source_Code,
1503: eomd.Tagging_Required_Flag, eomd.Shutdown_Type_Code
1504: FROM mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
1505: WHERE maintenance_object_id = p_maintenance_object_id AND maintenance_object_type = 2
1506: AND tmpl_flag = 'Y' AND meaa.Activity_Association_Id = eomd.object_id(+) AND eomd.object_type(+) = 40
1507: AND eomd.organization_id(+) = p_organization_id;
1508: -- 2735563: Simply pick up ALL templates and copy the start and end dates to the association records

Line 1587: SELECT mtl_eam_asset_activities_s.nextval

1583: LOOP
1584: -- 1: Get activity_association_id from sequence
1585: BEGIN
1586: -- Get activity_association_id from sequence
1587: SELECT mtl_eam_asset_activities_s.nextval
1588: INTO l_next_association_id
1589: FROM dual;
1590: EXCEPTION
1591: WHEN OTHERS THEN

Line 1623: -- 2: Insert row into mtl_eam_asset_activities

1619: -- if present, else default from template
1620: l_class_code := nvl(p_class_code,l_asset_activity_row.accounting_class_code);
1621: l_owning_department_id := nvl(p_owning_department_id,l_asset_activity_row.Owning_Department_Id);
1622:
1623: -- 2: Insert row into mtl_eam_asset_activities
1624: BEGIN
1625: -- Insert into Database Table mtl_eam_asset_activities
1626: INSERT INTO mtl_eam_asset_activities (
1627: Asset_Activity_Id,

Line 1625: -- Insert into Database Table mtl_eam_asset_activities

1621: l_owning_department_id := nvl(p_owning_department_id,l_asset_activity_row.Owning_Department_Id);
1622:
1623: -- 2: Insert row into mtl_eam_asset_activities
1624: BEGIN
1625: -- Insert into Database Table mtl_eam_asset_activities
1626: INSERT INTO mtl_eam_asset_activities (
1627: Asset_Activity_Id,
1628: Start_Date_Active,
1629: End_Date_Active,

Line 1626: INSERT INTO mtl_eam_asset_activities (

1622:
1623: -- 2: Insert row into mtl_eam_asset_activities
1624: BEGIN
1625: -- Insert into Database Table mtl_eam_asset_activities
1626: INSERT INTO mtl_eam_asset_activities (
1627: Asset_Activity_Id,
1628: Start_Date_Active,
1629: End_Date_Active,
1630: Priority_Code,