APPS.AHL_PRD_PRINT_PVT dependencies on AHL_ROUTES_B

Line 2121: AHL_ROUTES_B RO ,

2117: DECODE(W.PLAN_ID,NULL,'F','T') ISQUALITYENABLED,
2118: WO.ROUTE_ID
2119: FROM AHL_WORKORDER_TASKS_V WO ,
2120: WIP_DISCRETE_JOBS WIP ,
2121: AHL_ROUTES_B RO ,
2122: AHL_UNIT_EFFECTIVITIES_B UE ,
2123: --HZ_PARTIES HZ ,
2124: CSI_ITEM_INSTANCES CSI ,
2125: --CS_INCIDENTS_ALL_B CSIN ,

Line 2274: FROM AHL_ROUTES_B R ,

2270: PROCESS.MEANING process ,
2271: JOBCARDLYT.MEANING job_card_lyt_meaning ,
2272: R.model_code ,
2273: R.last_update_date
2274: FROM AHL_ROUTES_B R ,
2275: AHL_ROUTES_TL T ,
2276: (SELECT LOOKUP_CODE ,
2277: MEANING
2278: FROM FND_LOOKUP_VALUES

Line 2487: FROM ahl_routes_b

2483: attribute12 ,
2484: attribute13 ,
2485: attribute14 ,
2486: attribute15
2487: FROM ahl_routes_b
2488: WHERE route_id = c_route_id;
2489:
2490: CURSOR panel_details_csr (c_route_id IN NUMBER)
2491: IS

Line 7889: AHL_ROUTES_B RO ,

7885: DECODE(W.PLAN_ID,NULL,'F','T') ISQUALITYENABLED,
7886: WO.ROUTE_ID
7887: FROM AHL_WORKORDER_TASKS_V WO ,
7888: WIP_DISCRETE_JOBS WIP ,
7889: AHL_ROUTES_B RO ,
7890: AHL_UNIT_EFFECTIVITIES_B UE ,
7891: --HZ_PARTIES HZ ,
7892: CSI_ITEM_INSTANCES CSI ,
7893: --CS_INCIDENTS_ALL_B CSIN ,

Line 8024: FROM AHL_ROUTES_B R ,

8020: PROCESS.MEANING process ,
8021: JOBCARDLYT.MEANING job_card_lyt_meaning ,
8022: R.model_code ,
8023: R.last_update_date
8024: FROM AHL_ROUTES_B R ,
8025: AHL_ROUTES_TL T ,
8026: (SELECT LOOKUP_CODE ,
8027: MEANING
8028: FROM FND_LOOKUP_VALUES

Line 8174: FROM ahl_routes_b

8170: attribute12 ,
8171: attribute13 ,
8172: attribute14 ,
8173: attribute15
8174: FROM ahl_routes_b
8175: WHERE route_id = c_route_id;
8176:
8177: CURSOR panel_details_csr (c_route_id IN NUMBER)
8178: IS

Line 8879: from ahl_routes_b_kfv

8875: END IF;
8876:
8877: BEGIN
8878: select concatenated_segments into l_concat_segment
8879: from ahl_routes_b_kfv
8880: where route_id = l_route_id;
8881: EXCEPTION
8882: WHEN OTHERS THEN
8883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;