APPS.AHL_RM_OPERATION_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 2045: DELETE AHL_RT_OPER_MATERIALS

2041:
2042: -- Delete all the associations
2043:
2044: -- 1.Delete Material Requirements
2045: DELETE AHL_RT_OPER_MATERIALS
2046: WHERE OBJECT_ID = p_operation_id
2047: AND ASSOCIATION_TYPE_CODE = 'OPERATION';
2048:
2049: -- If no records exist, then, Continue.

Line 2481: INSERT INTO AHL_RT_OPER_MATERIALS

2477:
2478: -- Create copies of the operation associations
2479:
2480: -- 1.Copy Material Requirements
2481: INSERT INTO AHL_RT_OPER_MATERIALS
2482: (
2483: RT_OPER_MATERIAL_ID,
2484: OBJECT_VERSION_NUMBER,
2485: OBJECT_ID,

Line 2520: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

2516: MC_ID,
2517: POSITION_KEY
2518: )
2519: SELECT
2520: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
2521: 1,
2522: l_operation_id,
2523: ASSOCIATION_TYPE_CODE,
2524: ITEM_GROUP_ID,

Line 2555: FROM AHL_RT_OPER_MATERIALS

2551: IN_SERVICE, --pdoki added for OGMA 105 issue
2552: --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
2553: MC_ID,
2554: POSITION_KEY
2555: FROM AHL_RT_OPER_MATERIALS
2556: WHERE object_id = p_operation_id
2557: AND association_type_code = 'OPERATION';
2558:
2559: -- 2.Copy Resource Requirements and Alternate Resources