APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 676: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP

672: ITEM_COMP_DETAIL_ID,
673: POSITION_PATH_ID,
674: PP.PATH_POS_COMMON_ID,
675: PP.VER_SPEC_SCORE
676: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP
677: WHERE OBJECT_ID in (NVL(c_mc_route_eff_id, -1), NVL(c_item_route_eff_id, -1)) AND
678: ROM.POSITION_PATH_ID = PP.PATH_POSITION_ID (+) AND
679: ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_DISPOSITION AND
680: ((REPLACE_PERCENT = 100 AND p_request_type = G_REQ_TYPE_FORECAST) OR

Line 1012: FROM AHL_RT_OPER_MATERIALS ROM

1008: ROM.UOM_CODE,
1009: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
1010: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1011: ROM.ITEM_GROUP_ID
1012: FROM AHL_RT_OPER_MATERIALS ROM
1013: WHERE OBJECT_ID = p_route_id
1014: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_ROUTE;
1015:
1016: -- AnRaj : Start for fixing perf bug 4919527

Line 1032: FROM AHL_RT_OPER_MATERIALS ROM

1028: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1029: -- support for Oracle 8
1030: --NULL AS ITEM_GROUP_ID
1031: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1032: FROM AHL_RT_OPER_MATERIALS ROM
1033: WHERE OBJECT_ID in (SELECT RO.operation_id
1034: FROM ahl_operations_vl O, ahl_route_operations RO
1035: WHERE O.operation_id = RO.operation_id and
1036: RO.route_id = p_route_id and

Line 1061: FROM AHL_RT_OPER_MATERIALS ROM

1057: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1058: --NULL AS ITEM_GROUP_ID
1059: -- support for Oracle 8
1060: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1061: FROM AHL_RT_OPER_MATERIALS ROM
1062: WHERE OBJECT_ID in (SELECT RO.operation_id
1063: FROM ahl_operations_vl O, ahl_route_operations RO
1064: WHERE O.operation_id = RO.operation_id and
1065: RO.route_id = p_route_id and

Line 1090: FROM AHL_RT_OPER_MATERIALS ROM

1086: TO_NUMBER(NULL) AS INVENTORY_ORG_ID,
1087: QUANTITY,
1088: UOM_CODE,
1089: ITEM_GROUP_ID
1090: FROM AHL_RT_OPER_MATERIALS ROM
1091: WHERE OBJECT_ID in (SELECT RO.operation_id
1092: FROM ahl_operations_vl O, ahl_route_operations RO
1093: WHERE O.operation_id = RO.operation_id and
1094: RO.route_id = p_route_id and

Line 1116: FROM AHL_RT_OPER_MATERIALS ROM

1112: -- Aggregate item quantities across operations when forecasting
1113: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, /*Total Primary Qty */
1114: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1115: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1116: FROM AHL_RT_OPER_MATERIALS ROM
1117: WHERE OBJECT_ID in ( SELECT RO.operation_id
1118: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1119: WHERE O.operation_id = RO.operation_id and
1120: RO.route_id = p_route_id and

Line 1140: FROM AHL_RT_OPER_MATERIALS ROM

1136: TO_NUMBER(NULL) AS INVENTORY_ORG_ID,
1137: QUANTITY,
1138: UOM_CODE,
1139: ITEM_GROUP_ID
1140: FROM AHL_RT_OPER_MATERIALS ROM
1141: WHERE OBJECT_ID in ( SELECT RO.operation_id
1142: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1143: WHERE O.operation_id = RO.operation_id and
1144: RO.route_id = p_route_id and

Line 1165: FROM AHL_RT_OPER_MATERIALS ROM

1161: INVENTORY_ORG_ID,
1162: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, /* Primary Qty */
1163: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1164: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1165: FROM AHL_RT_OPER_MATERIALS ROM
1166: WHERE OBJECT_ID in ( SELECT RO.operation_id
1167: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1168: WHERE O.operation_id = RO.operation_id
1169: and RO.route_id = p_route_id

Line 1190: FROM AHL_RT_OPER_MATERIALS ROM

1186: TO_NUMBER(NULL) AS INVENTORY_ORG_ID,
1187: QUANTITY,
1188: UOM_CODE,
1189: ITEM_GROUP_ID
1190: FROM AHL_RT_OPER_MATERIALS ROM
1191: WHERE OBJECT_ID in (SELECT RO.operation_id
1192: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1193: WHERE O.operation_id = RO.operation_id and
1194: RO.route_id = p_route_id and

Line 1215: FROM AHL_RT_OPER_MATERIALS ROM

1211: TO_NUMBER(NULL) AS INVENTORY_ORG_ID,
1212: QUANTITY,
1213: UOM_CODE,
1214: ITEM_GROUP_ID
1215: FROM AHL_RT_OPER_MATERIALS ROM
1216: WHERE OBJECT_ID in (SELECT RO.operation_id
1217: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1218: WHERE O.operation_id = RO.operation_id and
1219: RO.route_id = p_route_id and