DBA Data[Home] [Help]

APPS.AHL_VWP_PRICE_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 1088: AHL_ROUTE_OPERATIONS RO

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
1092: AND OP.revision_number IN

Line 1301: AHL_ROUTE_OPERATIONS RO

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
1305: AND OP.revision_number IN

Line 1335: ahl_route_operations ro

1331: and msiv.organization_id = c_org_id
1332: and ar.object_id in
1333: ( select ro.operation_id
1334: from ahl_operations_b_kfv op,
1335: ahl_route_operations ro
1336: where op.operation_id=ro.operation_id
1337: and op.revision_status_code='COMPLETE'
1338: and ro.route_id=c_route_id
1339: and op.revision_number in