eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 1109: FROM ahl_operations_b_kfv

1105: WHERE O.operation_id = RO.operation_id and
1106: RO.route_id = p_route_id and
1107: O.revision_status_code = 'COMPLETE' and
1108: O.revision_number in (SELECT max(revision_number)
1109: FROM ahl_operations_b_kfv
1110: WHERE concatenated_segments =
1111: O.concatenated_segments and
1112: trunc(sysdate) between
1113: trunc(start_date_active) and

Line 1138: FROM ahl_operations_b_kfv

1134: WHERE O.operation_id = RO.operation_id and
1135: RO.route_id = p_route_id and
1136: O.revision_status_code = 'COMPLETE' and
1137: O.revision_number in (SELECT max(revision_number)
1138: FROM ahl_operations_b_kfv
1139: WHERE concatenated_segments =
1140: O.concatenated_segments and
1141: trunc(sysdate) between
1142: trunc(start_date_active) and

Line 1167: FROM ahl_operations_b_kfv

1163: WHERE O.operation_id = RO.operation_id and
1164: RO.route_id = p_route_id and
1165: O.revision_status_code = 'COMPLETE' and
1166: O.revision_number in (SELECT max(revision_number)
1167: FROM ahl_operations_b_kfv
1168: WHERE concatenated_segments =
1169: O.concatenated_segments and
1170: trunc(sysdate) between
1171: trunc(start_date_active) and

Line 1192: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

1188: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1189: TO_NUMBER(NULL) AS 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 1197: FROM ahl_operations_b_kfv

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)
1197: FROM ahl_operations_b_kfv
1198: WHERE concatenated_segments = O.concatenated_segments
1199: -- manisaga : Bug# 9726667 : 22-Jun-2010
1200: -- added the below condition to fetch the latest revision of
1201: -- operations with only 'complete' status

Line 1224: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

1220: UOM_CODE AS PRIMARY_UOM_CODE,
1221: ITEM_GROUP_ID
1222: FROM AHL_RT_OPER_MATERIALS ROM
1223: WHERE OBJECT_ID in ( SELECT RO.operation_id
1224: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1225: WHERE O.operation_id = RO.operation_id and
1226: RO.route_id = p_route_id and
1227: O.revision_status_code = 'COMPLETE' and
1228: O.revision_number in (SELECT max(revision_number)

Line 1229: FROM ahl_operations_b_kfv

1225: WHERE O.operation_id = RO.operation_id and
1226: RO.route_id = p_route_id and
1227: O.revision_status_code = 'COMPLETE' and
1228: O.revision_number in (SELECT max(revision_number)
1229: FROM ahl_operations_b_kfv
1230: WHERE concatenated_segments = O.concatenated_segments
1231: -- manisaga : Bug# 9726667 : 22-Jun-2010
1232: and revision_status_code = 'COMPLETE'
1233: and

Line 1255: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

1251: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1252: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1253: FROM AHL_RT_OPER_MATERIALS ROM
1254: WHERE OBJECT_ID in ( SELECT RO.operation_id
1255: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1256: WHERE O.operation_id = RO.operation_id
1257: and RO.route_id = p_route_id
1258: and O.revision_status_code = 'COMPLETE'
1259: and O.revision_number in ( SELECT max(revision_number)

Line 1260: FROM ahl_operations_b_kfv

1256: WHERE O.operation_id = RO.operation_id
1257: and RO.route_id = p_route_id
1258: and O.revision_status_code = 'COMPLETE'
1259: and O.revision_number in ( SELECT max(revision_number)
1260: FROM ahl_operations_b_kfv
1261: WHERE concatenated_segments =O.concatenated_segments
1262: -- manisaga : Bug# 9726667 : 22-Jun-2010
1263: and revision_status_code = 'COMPLETE'
1264: and

Line 1286: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

1282: UOM_CODE AS PRIMARY_UOM_CODE,
1283: ITEM_GROUP_ID
1284: FROM AHL_RT_OPER_MATERIALS ROM
1285: WHERE OBJECT_ID in (SELECT RO.operation_id
1286: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1287: WHERE O.operation_id = RO.operation_id and
1288: RO.route_id = p_route_id and
1289: O.revision_status_code = 'COMPLETE' and
1290: O.revision_number in (SELECT max(revision_number)

Line 1291: FROM ahl_operations_b_kfv

1287: WHERE O.operation_id = RO.operation_id and
1288: RO.route_id = p_route_id and
1289: O.revision_status_code = 'COMPLETE' and
1290: O.revision_number in (SELECT max(revision_number)
1291: FROM ahl_operations_b_kfv
1292: WHERE concatenated_segments = O.concatenated_segments
1293: -- manisaga : Bug# 9726667 : 22-Jun-2010
1294: and revision_status_code = 'COMPLETE'
1295: and

Line 1315: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

1311: UOM_CODE,
1312: ITEM_GROUP_ID
1313: FROM AHL_RT_OPER_MATERIALS ROM
1314: WHERE OBJECT_ID in (SELECT RO.operation_id
1315: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO
1316: WHERE O.operation_id = RO.operation_id and
1317: RO.route_id = p_route_id and
1318: O.revision_status_code = 'COMPLETE' and
1319: O.revision_number in (SELECT max(revision_number)

Line 1320: FROM ahl_operations_b_kfv

1316: WHERE O.operation_id = RO.operation_id and
1317: RO.route_id = p_route_id and
1318: O.revision_status_code = 'COMPLETE' and
1319: O.revision_number in (SELECT max(revision_number)
1320: FROM ahl_operations_b_kfv
1321: WHERE concatenated_segments = O.concatenated_segments
1322: -- manisaga : Bug# 9726667 : 22-Jun-2010
1323: and revision_status_code = 'COMPLETE'
1324: and