APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 1034: FROM ahl_operations_vl O, ahl_route_operations RO

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
1037: O.revision_status_code = 'COMPLETE' and
1038: O.revision_number in (SELECT max(revision_number)

Line 1063: FROM ahl_operations_vl O, ahl_route_operations RO

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
1066: O.revision_status_code = 'COMPLETE' and
1067: O.revision_number in (SELECT max(revision_number)

Line 1092: FROM ahl_operations_vl O, ahl_route_operations RO

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
1095: O.revision_status_code = 'COMPLETE' and
1096: O.revision_number in (SELECT max(revision_number)

Line 1118: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

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
1121: O.revision_status_code = 'COMPLETE' and
1122: O.revision_number in ( SELECT max(revision_number)

Line 1142: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

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
1145: O.revision_status_code = 'COMPLETE' and
1146: O.revision_number in (SELECT max(revision_number)

Line 1167: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

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
1170: and O.revision_status_code = 'COMPLETE'
1171: and O.revision_number in ( SELECT max(revision_number)

Line 1192: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

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
1195: O.revision_status_code = 'COMPLETE' and
1196: O.revision_number in (SELECT max(revision_number)

Line 1217: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

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
1220: O.revision_status_code = 'COMPLETE' and
1221: O.revision_number in (SELECT max(revision_number)