DBA Data[Home] [Help]

APPS.AHL_VWP_PRICE_PVT dependencies on AHL_OPERATIONS_VL

Line 1087: FROM AHL_OPERATIONS_VL OP,

1083: AND VT.visit_task_id = c_visit_task_id
1084: AND MSIV.inventory_item_id = MAT.inventory_item_id
1085: AND MAT.object_id in
1086: ( SELECT RO.operation_id
1087: FROM AHL_OPERATIONS_VL OP,
1088: AHL_ROUTE_OPERATIONS RO
1089: WHERE OP.operation_id=RO.operation_id
1090: AND OP.revision_status_code='COMPLETE'
1091: AND RO.route_id=c_route_id

Line 1300: FROM AHL_OPERATIONS_VL OP,

1296: AND MSIV.inventory_item_id = BR.BILLABLE_ITEM_ID
1297: AND MSIV.organization_id = c_org_id
1298: AND AR.object_id in
1299: ( SELECT RO.operation_id
1300: FROM AHL_OPERATIONS_VL OP,
1301: AHL_ROUTE_OPERATIONS RO
1302: WHERE OP.operation_id=RO.operation_id
1303: AND OP.revision_status_code='COMPLETE'
1304: AND RO.route_id=c_route_id