DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_ROUTES_VL

Line 1176: FROM ahl_routes_vl ar, ahl_mr_routes mrr

1172: CURSOR c_route_details(c_mr_route_id IN NUMBER) IS
1173: SELECT substrb(ar.title,1,80), ar.remarks,
1174: -- SKPATHAK :: 02-MAY-2011 :: VWPE :: Added below two more columns
1175: mrr.stage_type_code, ar.return_to_supply_flag
1176: FROM ahl_routes_vl ar, ahl_mr_routes mrr
1177: WHERE mrr.mr_route_id = c_mr_route_id
1178: AND mrr.route_id = ar.route_id;
1179:
1180: --VWP ER-12424063:: tchimira :: 17-FEB -2011 :: start

Line 1241: l_description ahl_routes_vl.remarks%TYPE; --Bug 5758813

1237: l_item_org_id NUMBER;
1238: l_serial_id NUMBER;
1239: l_mr_id NUMBER;
1240: l_mr_route_id NUMBER;
1241: l_description ahl_routes_vl.remarks%TYPE; --Bug 5758813
1242: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
1243: l_stage_id NUMBER; --VWP ER-12424063 tchimira :: 17-FEB -2011
1244: -- SKPATHAK :: 02-MAY-2011 :: VWPE
1245: l_stage_type_code VARCHAR2(30);