DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_ROUTES_APP_V

Line 2473: FROM AHL_ROUTES_APP_V --Changed from AHL_ROUTES_V for perf bug# 4949394.

2469: CURSOR get_route_inspection_type(c_route_id NUMBER)
2470: IS
2471: SELECT qa_inspection_type
2472: --FROM AHL_ROUTES_V --Changed from AHL_ROUTES_B for Application Usage Complaince.
2473: FROM AHL_ROUTES_APP_V --Changed from AHL_ROUTES_V for perf bug# 4949394.
2474: WHERE route_id=c_route_id;
2475:
2476: --Adithya added for bug# 6830028
2477: CURSOR get_route_acc_class_code(c_route_id NUMBER)

Line 2480: FROM AHL_ROUTES_APP_V

2476: --Adithya added for bug# 6830028
2477: CURSOR get_route_acc_class_code(c_route_id NUMBER)
2478: IS
2479: SELECT ACCOUNTING_CLASS_CODE
2480: FROM AHL_ROUTES_APP_V
2481: WHERE route_id=c_route_id;
2482:
2483: CURSOR validate_acc_class_code( c_wip_acc_class_code VARCHAR2, c_organization_id NUMBER)
2484: IS