APPS.AHL_PRD_PRINT_PVT dependencies on AHL_WORKORDERS

Line 180: AHL_WORKORDERS WO,

176: DOC.PAGE,
177: DOC.FIGURE,
178: DOC.NOTE
179: FROM
180: AHL_WORKORDERS WO,
181: AHL_DOCUMENT_ASSOS_V DOC
182: WHERE
183: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
184: AND DOC.ASO_OBJECT_TYPE_CODE = ''ROUTE''

Line 224: AHL_WORKORDERS WO,

220: DOC.PAGE,
221: DOC.FIGURE,
222: DOC.NOTE
223: FROM
224: AHL_WORKORDERS WO,
225: AHL_VISIT_TASKS_B VST,
226: AHL_DOCUMENT_ASSOS_V DOC
227: WHERE
228: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID

Line 249: AHL_WORKORDERS WO,

245: DOC.PAGE,
246: DOC.FIGURE,
247: DOC.NOTE
248: FROM
249: AHL_WORKORDERS WO,
250: CSI_II_RELATIONSHIPS CSI,
251: AHL_VISIT_TASKS_B VTS,
252: AHL_DOCUMENT_ASSOS_V DOC
253: WHERE

Line 277: AHL_WORKORDERS WO,

273: DOC.PAGE,
274: DOC.FIGURE,
275: DOC.NOTE
276: FROM
277: AHL_WORKORDERS WO,
278: AHL_PC_ASSOCIATIONS PCA,
279: AHL_VISIT_TASKS_B VTS,
280: AHL_DOCUMENT_ASSOS_V DOC
281: WHERE

Line 326: AHL_WORKORDERS

322: SELECT
323: PLAN_ID,
324: COLLECTION_ID
325: FROM
326: AHL_WORKORDERS
327: WHERE
328: workorder_id = p_workorder_id;
329:
330: --Cursor for getting workorder operation plan_id and collection id

Line 1262: ahl_workorders wo,

1258:
1259: l_query_string := ' select
1260: wo.workorder_id
1261: from
1262: ahl_workorders wo,
1263: wip_discrete_jobs wipd,
1264: ahl_visits_b vst,
1265: ahl_visit_tasks_b vtsk
1266: where