APPS.AHL_VWP_PRICE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1245: FROM AHL_RT_OPER_RESOURCES AR

1241: -- For checking if Resource Requirements are defined for Route
1242: CURSOR check_rt_resources_csr(c_route_id NUMBER)
1243: IS
1244: SELECT AR.rt_oper_resource_id
1245: FROM AHL_RT_OPER_RESOURCES AR
1246: WHERE AR.association_type_code='ROUTE'
1247: AND AR.object_id=c_route_id;
1248:
1249: -- Bug # : 5532390, regression issues caused by fix for bug number 5258334

Line 1260: FROM AHL_RT_OPER_RESOURCES AR,

1256: SELECT sum(NVL(AR.duration,0)* NVL(AR.quantity,0)) duration,
1257: BR.BILLABLE_ITEM_ID,
1258: MSIV.concatenated_segments item_name,
1259: MSIV.primary_uom_code uom_code
1260: FROM AHL_RT_OPER_RESOURCES AR,
1261: BOM_RESOURCES BR,
1262: MTL_SYSTEM_ITEMS_VL MSIV,
1263: AHL_RESOURCE_MAPPINGS MAP
1264: WHERE AR.association_type_code='ROUTE'

Line 1287: FROM AHL_RT_OPER_RESOURCES AR,

1283: /* SELECT sum(NVL(AR.duration,0)* NVL(AR.quantity,0)) duration,
1284: MSIV.primary_uom_code uom_code,
1285: MSIV.concatenated_segments item_name,
1286: BR.BILLABLE_ITEM_ID
1287: FROM AHL_RT_OPER_RESOURCES AR,
1288: BOM_RESOURCES BR,
1289: MTL_SYSTEM_ITEMS_VL MSIV,
1290: AHL_RESOURCE_MAPPINGS MAP
1291: WHERE AR.association_type_code='OPERATION'

Line 1321: from ahl_rt_oper_resources ar,

1317: select sum(nvl(ar.duration,0)* nvl(ar.quantity,0)) duration,
1318: msiv.primary_uom_code uom_code,
1319: msiv.concatenated_segments item_name,
1320: br.billable_item_id
1321: from ahl_rt_oper_resources ar,
1322: bom_resources br,
1323: mtl_system_items_kfv msiv,
1324: ahl_resource_mappings map
1325: where ar.association_type_code='OPERATION'