APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 326: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC

322: FROM AHL_ITEM_COMP_DETAILS
323: WHERE ITEM_GROUP_ID = P_ITEM_GROUP_ID AND
324: ITEM_COMPOSITION_ID = (
325: SELECT IC.ITEM_COMPOSITION_ID FROM
326: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC
327: WHERE RE.INVENTORY_ITEM_ID=IC.INVENTORY_ITEM_ID(+) AND
328: RE.INVENTORY_MASTER_ORG_ID=IC.INVENTORY_MASTER_ORG_ID(+) AND
329: IC.APPROVAL_STATUS_CODE(+)='COMPLETE' AND
330: ROUTE_EFFECTIVITY_ID = P_ROUTE_EFFECITIVITY_ID ) AND

Line 336: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V

332: /*SELECT item_comp_detail_id
333: FROM AHL_ITEM_COMP_DETAILS
334: WHERE item_group_id = p_item_group_id AND
335: item_composition_id = (
336: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
337: WHERE route_effectivity_id = p_route_effecitivity_id
338: ) AND
339: effective_end_date IS NULL;*/
340: l_return_status VARCHAR2(1);

Line 1156: from ahl_route_effectivities_v

1152: , attribute12
1153: , attribute13
1154: , attribute14
1155: , attribute15
1156: from ahl_route_effectivities_v
1157: WHERE ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
1158: ;
1159: BEGIN
1160: -- Get the old record from AHL_RT_OPER_MATERIALS.

Line 1941: FROM AHL_ROUTE_EFFECTIVITIES_V

1937: inventory_item_id,
1938: inventory_master_org_id,
1939: CONCATENATED_SEGMENTS,
1940: item_description
1941: FROM AHL_ROUTE_EFFECTIVITIES_V
1942: WHERE ROUTE_ID = c_object_id
1943: GROUP BY
1944: mc_id,
1945: mc_name,

Line 1961: FROM AHL_ROUTE_EFFECTIVITIES

1957: SELECT mc_id,
1958: mc_header_id,
1959: inventory_item_id,
1960: inventory_master_org_id
1961: FROM AHL_ROUTE_EFFECTIVITIES
1962: WHERE ROUTE_ID = c_object_id
1963: GROUP BY
1964: mc_id,
1965: mc_header_id,

Line 2067: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM

2063: where operation_id = p_operation_id;
2064: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2065: IS
2066: SELECT RM.ROUTE_ID
2067: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM
2068: WHERE refct.ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
2069: AND RM.ROUTE_ID = refct.ROUTE_ID;
2070: l_api_version CONSTANT NUMBER := 1.0;
2071: l_return_status VARCHAR2(1);

Line 2846: INSERT INTO ahl_route_effectivities

2842: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
2843: END IF;
2844: -- Insert the record
2845: p_x_route_efct_tbl(i).object_version_number := 1;
2846: INSERT INTO ahl_route_effectivities
2847: (
2848: route_effectivity_id
2849: , route_id
2850: , inventory_item_id

Line 2879: ahl_route_effectivities_s.nextval,

2875: ATTRIBUTE14,
2876: ATTRIBUTE15
2877: ) VALUES
2878: (
2879: ahl_route_effectivities_s.nextval,
2880: p_object_id,
2881: p_x_route_efct_tbl(i).INVENTORY_ITEM_ID,
2882: p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID,
2883: p_x_route_efct_tbl(i).MC_ID,

Line 2920: UPDATE ahl_route_effectivities

2916: -- Set OUT values
2917: p_x_route_efct_tbl(i).route_effectivity_id := l_route_effectivitiy_id;
2918: ELSIF ( p_x_route_efct_tbl(i).dml_operation = 'U' ) THEN
2919: -- Update the record
2920: UPDATE ahl_route_effectivities
2921: SET
2922: object_version_number = object_version_number + 1,
2923: last_update_date = SYSDATE,
2924: last_updated_by = FND_GLOBAL.USER_ID,

Line 2963: DELETE FROM ahl_route_effectivities

2959: IF ( SQL%ROWCOUNT = 0 ) THEN
2960: -- Ignore the Exception
2961: NULL;
2962: END IF;
2963: DELETE FROM ahl_route_effectivities
2964: WHERE route_effectivity_id = p_x_route_efct_tbl(i).route_effectivity_id
2965: AND object_version_number = p_x_route_efct_tbl(i).object_version_number;
2966: -- If the record does not exist, then, abort API.
2967: IF ( SQL%ROWCOUNT = 0 ) THEN