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.

[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 1039: FROM ahl_operations_b_kfv

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)
1039: FROM ahl_operations_b_kfv
1040: WHERE concatenated_segments =
1041: O.concatenated_segments and
1042: trunc(sysdate) between
1043: trunc(start_date_active) and

Line 1068: FROM ahl_operations_b_kfv

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)
1068: FROM ahl_operations_b_kfv
1069: WHERE concatenated_segments =
1070: O.concatenated_segments and
1071: trunc(sysdate) between
1072: trunc(start_date_active) and

Line 1097: FROM ahl_operations_b_kfv

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)
1097: FROM ahl_operations_b_kfv
1098: WHERE concatenated_segments =
1099: O.concatenated_segments and
1100: trunc(sysdate) between
1101: trunc(start_date_active) and

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 1123: FROM ahl_operations_b_kfv

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)
1123: FROM ahl_operations_b_kfv
1124: WHERE concatenated_segments = O.concatenated_segments
1125: and trunc(sysdate) between
1126: trunc(start_date_active) and
1127: trunc(NVL(end_date_active,SYSDATE+1)))

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 1147: FROM ahl_operations_b_kfv

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)
1147: FROM ahl_operations_b_kfv
1148: WHERE concatenated_segments = O.concatenated_segments
1149: and
1150: trunc(sysdate) between
1151: trunc(start_date_active) and

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 1172: FROM ahl_operations_b_kfv

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)
1172: FROM ahl_operations_b_kfv
1173: WHERE concatenated_segments =O.concatenated_segments
1174: and
1175: trunc(sysdate) between
1176: trunc(start_date_active) and

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 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: and
1200: trunc(sysdate) between
1201: trunc(start_date_active) and

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)

Line 1222: FROM ahl_operations_b_kfv

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)
1222: FROM ahl_operations_b_kfv
1223: WHERE concatenated_segments = O.concatenated_segments
1224: and
1225: trunc(sysdate) between
1226: trunc(start_date_active) and