APPS.AHL_VWP_PRICE_PVT dependencies on BOM_RESOURCES

Line 935: BOM_RESOURCES BR

931: FROM AHL_PP_REQUIREMENT_V AR,
932: MTL_SYSTEM_ITEMS_VL MSIV,
933: AHL_VISITS_B V,
934: AHL_VISIT_TASKS_B VT,
935: BOM_RESOURCES BR
936: WHERE BR.resource_id=AR.resource_id
937: AND BR.BILLABLE_ITEM_ID is not null
938: AND AR.visit_task_id = c_visit_task_id
939: AND V.visit_id = VT.visit_id

Line 1261: BOM_RESOURCES BR,

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'
1265: AND BR.resource_id=MAP.bom_resource_id

Line 1288: BOM_RESOURCES BR,

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'
1292: AND BR.resource_id=MAP.bom_resource_id

Line 1322: bom_resources br,

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'
1326: and br.resource_id=map.bom_resource_id

Line 1531: BOM_RESOURCES BR

1527: FROM AHL_WIP_RESOURCE_TXNS_V AR,
1528: MTL_SYSTEM_ITEMS_VL MSIV,
1529: AHL_VISITS_B V,
1530: AHL_VISIT_TASKS_B VT,
1531: BOM_RESOURCES BR
1532: WHERE BR.resource_id=AR.resource_id
1533: AND BR.BILLABLE_ITEM_ID is not null
1534: AND AR.visit_task_id = c_visit_task_id
1535: AND MSIV.organization_id = V.organization_id