[Home] [Help]
1100: --NULL AS ITEM_GROUP_ID
1101: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1102: FROM AHL_RT_OPER_MATERIALS ROM
1103: WHERE OBJECT_ID in (SELECT RO.operation_id
1104: FROM ahl_operations_vl O, ahl_route_operations RO
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)
1129: -- support for Oracle 8
1130: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1131: FROM AHL_RT_OPER_MATERIALS ROM
1132: WHERE OBJECT_ID in (SELECT RO.operation_id
1133: FROM ahl_operations_vl O, ahl_route_operations RO
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)
1158: UOM_CODE,
1159: ITEM_GROUP_ID
1160: FROM AHL_RT_OPER_MATERIALS ROM
1161: WHERE OBJECT_ID in (SELECT RO.operation_id
1162: FROM ahl_operations_vl O, ahl_route_operations RO
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)
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)
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)
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)
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)
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)
1333: -- Added by jaramana on 22-OCT-2009 for bug 9037150
1334: -- Use the following cursor to do a high level check for presence of operation level mtl requirements
1335: CURSOR op_level_planned_reqs_exist IS
1336: SELECT ROM.RT_OPER_MATERIAL_ID
1337: FROM AHL_RT_OPER_MATERIALS ROM, AHL_ROUTE_OPERATIONS RO
1338: WHERE ROM.OBJECT_ID = RO.operation_id
1339: AND RO.route_id = p_route_id
1340: AND ROM.ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_OPERATION;
1341: l_dummy op_level_planned_reqs_exist%ROWTYPE;