APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 368: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC

364: FROM AHL_ITEM_COMP_DETAILS
365: WHERE ITEM_GROUP_ID = P_ITEM_GROUP_ID AND
366: ITEM_COMPOSITION_ID = (
367: SELECT IC.ITEM_COMPOSITION_ID FROM
368: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC
369: WHERE RE.INVENTORY_ITEM_ID=IC.INVENTORY_ITEM_ID(+) AND
370: RE.INVENTORY_MASTER_ORG_ID=IC.INVENTORY_MASTER_ORG_ID(+) AND
371: IC.APPROVAL_STATUS_CODE(+)='COMPLETE' AND
372: ROUTE_EFFECTIVITY_ID = P_ROUTE_EFFECITIVITY_ID ) AND

Line 379: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V

375: /*SELECT item_comp_detail_id
376: FROM AHL_ITEM_COMP_DETAILS
377: WHERE item_group_id = p_item_group_id AND
378: item_composition_id = (
379: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
380: WHERE route_effectivity_id = p_route_effecitivity_id
381: ) AND
382: effective_end_date IS NULL;*/
383:

Line 1258: from ahl_route_effectivities_v

1254: , attribute12
1255: , attribute13
1256: , attribute14
1257: , attribute15
1258: from ahl_route_effectivities_v
1259: WHERE ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
1260: ;
1261:
1262: BEGIN

Line 1994: FROM AHL_ROUTE_EFFECTIVITIES_V

1990: inventory_item_id,
1991: inventory_master_org_id,
1992: CONCATENATED_SEGMENTS,
1993: item_description
1994: FROM AHL_ROUTE_EFFECTIVITIES_V
1995: WHERE ROUTE_ID = c_object_id
1996: GROUP BY
1997: mc_id,
1998: mc_name,

Line 2015: FROM AHL_ROUTE_EFFECTIVITIES

2011: SELECT mc_id,
2012: mc_header_id,
2013: inventory_item_id,
2014: inventory_master_org_id
2015: FROM AHL_ROUTE_EFFECTIVITIES
2016: WHERE ROUTE_ID = c_object_id
2017: GROUP BY
2018: mc_id,
2019: mc_header_id,

Line 2143: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM

2139:
2140: CURSOR get_efct_rec ( C_ROUTE_EFFECTIVITY_ID NUMBER )
2141: IS
2142: SELECT RM.ROUTE_ID
2143: FROM ahl_route_effectivities refct, AHL_ROUTES_APP_V RM
2144: WHERE refct.ROUTE_EFFECTIVITY_ID = C_ROUTE_EFFECTIVITY_ID
2145: AND RM.ROUTE_ID = refct.ROUTE_ID;
2146:
2147: l_api_version CONSTANT NUMBER := 1.0;

Line 3005: INSERT INTO ahl_route_effectivities

3001: END IF;
3002: -- Insert the record
3003: p_x_route_efct_tbl(i).object_version_number := 1;
3004:
3005: INSERT INTO ahl_route_effectivities
3006: (
3007: route_effectivity_id
3008: , route_id
3009: , inventory_item_id

Line 3038: ahl_route_effectivities_s.nextval,

3034: ATTRIBUTE14,
3035: ATTRIBUTE15
3036: ) VALUES
3037: (
3038: ahl_route_effectivities_s.nextval,
3039: p_object_id,
3040: p_x_route_efct_tbl(i).INVENTORY_ITEM_ID,
3041: p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID,
3042: p_x_route_efct_tbl(i).MC_ID,

Line 3083: UPDATE ahl_route_effectivities

3079:
3080: ELSIF ( p_x_route_efct_tbl(i).dml_operation = 'U' ) THEN
3081:
3082: -- Update the record
3083: UPDATE ahl_route_effectivities
3084: SET
3085: object_version_number = object_version_number + 1,
3086: last_update_date = SYSDATE,
3087: last_updated_by = FND_GLOBAL.USER_ID,

Line 3133: DELETE FROM ahl_route_effectivities

3129: NULL;
3130: END IF;
3131:
3132:
3133: DELETE FROM ahl_route_effectivities
3134: WHERE route_effectivity_id = p_x_route_efct_tbl(i).route_effectivity_id
3135: AND object_version_number = p_x_route_efct_tbl(i).object_version_number;
3136:
3137: