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.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 1841: DELETE AHL_RT_OPER_MATERIALS

1837:
1838: -- Delete all the associations
1839:
1840: -- 1.Delete Material Requirements
1841: DELETE AHL_RT_OPER_MATERIALS
1842: WHERE OBJECT_ID = p_operation_id
1843: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
1844:
1845: -- If no records exist, then, Continue.

Line 2273: INSERT INTO AHL_RT_OPER_MATERIALS

2269:
2270: -- Create copies of the operation associations
2271:
2272: -- 1.Copy Material Requirements
2273: INSERT INTO AHL_RT_OPER_MATERIALS
2274: (
2275: RT_OPER_MATERIAL_ID,
2276: OBJECT_VERSION_NUMBER,
2277: OBJECT_ID,

Line 2309: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

2305: LAST_UPDATE_LOGIN,
2306: IN_SERVICE --pdoki added for OGMA 105 issue
2307: )
2308: SELECT
2309: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
2310: 1,
2311: l_operation_id,
2312: ASSOCIATION_TYPE_CODE,
2313: ITEM_GROUP_ID,

Line 2341: FROM AHL_RT_OPER_MATERIALS

2337: G_CREATION_DATE,
2338: G_CREATED_BY,
2339: G_LAST_UPDATE_LOGIN,
2340: IN_SERVICE --pdoki added for OGMA 105 issue
2341: FROM AHL_RT_OPER_MATERIALS
2342: WHERE object_id = p_operation_id
2343: AND association_type_code = 'OPERATION';
2344:
2345: -- 2.Copy Resource Requirements and Alternate Resources