APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 733: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP

729: ITEM_COMP_DETAIL_ID,
730: POSITION_PATH_ID,
731: PP.PATH_POS_COMMON_ID,
732: PP.VER_SPEC_SCORE
733: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP
734: WHERE OBJECT_ID in (NVL(c_mc_route_eff_id, -1), NVL(c_item_route_eff_id, -1)) AND
735: ROM.POSITION_PATH_ID = PP.PATH_POSITION_ID (+) AND
736: ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_DISPOSITION AND
737: ((REPLACE_PERCENT = 100 AND p_request_type = G_REQ_TYPE_FORECAST) OR

Line 1067: -- like MC_ID, POSITION_KEY, QUANTITY and UOM_CODE from AHL_RT_OPER_MATERIALS table.

1063: x_route_req_list OUT NOCOPY Route_Mtl_Req_Tbl_Type) IS
1064:
1065: -- SURRKUMA :: Service Bulletin :: 07-Jun-2011
1066: -- Modified the cursor to fetch details required for position level requirements
1067: -- like MC_ID, POSITION_KEY, QUANTITY and UOM_CODE from AHL_RT_OPER_MATERIALS table.
1068: -- NOTE: The same modifications are done for the rest of the cursors too, listing the cursor names.
1069: -- get_op_level_reqs_forecast_csr, get_op_level_reqs_planned_csr and l_op_requirement_neither_csr
1070: CURSOR get_route_level_reqs_csr IS
1071: SELECT ROM.RT_OPER_MATERIAL_ID,

Line 1082: FROM AHL_RT_OPER_MATERIALS ROM

1078: ROM.UOM_CODE,
1079: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
1080: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1081: ROM.ITEM_GROUP_ID
1082: FROM AHL_RT_OPER_MATERIALS ROM
1083: WHERE OBJECT_ID = p_route_id
1084: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_ROUTE;
1085:
1086: -- AnRaj : Start for fixing perf bug 4919527

Line 1102: FROM AHL_RT_OPER_MATERIALS ROM

1098: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1099: -- support for Oracle 8
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

Line 1131: FROM AHL_RT_OPER_MATERIALS ROM

1127: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1128: --NULL AS ITEM_GROUP_ID
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

Line 1160: FROM AHL_RT_OPER_MATERIALS ROM

1156: TO_NUMBER(NULL) AS INVENTORY_ORG_ID,
1157: QUANTITY,
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

Line 1190: FROM AHL_RT_OPER_MATERIALS ROM

1186: -- Aggregate item quantities across operations when forecasting
1187: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS PRIMARY_QUANTITY, /*Total Primary Qty */
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

Line 1222: FROM AHL_RT_OPER_MATERIALS ROM

1218: UOM_CODE,
1219: QUANTITY AS PRIMARY_QUANTITY,
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

Line 1253: FROM AHL_RT_OPER_MATERIALS ROM

1249: UOM_CODE,
1250: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY, /* Primary Qty */
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

Line 1284: FROM AHL_RT_OPER_MATERIALS ROM

1280: UOM_CODE,
1281: QUANTITY AS PRIMARY_QUANTITY,
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

Line 1313: FROM AHL_RT_OPER_MATERIALS ROM

1309: POSITION_KEY,
1310: QUANTITY,
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

Line 1337: FROM AHL_RT_OPER_MATERIALS ROM, AHL_ROUTE_OPERATIONS RO

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;