APPS.AHL_PRD_PRINT_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 143: ahl_workorder_operations_v

139: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,
140: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,
141: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE
142: FROM
143: ahl_workorder_operations_v
144: WHERE
145: workorder_operation_id = ';
146:
147:

Line 202: AHL_WORKORDER_OPERATIONS WOP,

198: DOC.PAGE,
199: DOC.FIGURE,
200: DOC.NOTE
201: FROM
202: AHL_WORKORDER_OPERATIONS WOP,
203: AHL_DOCUMENT_ASSOS_V DOC
204: WHERE
205: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
206: AND DOC.ASO_OBJECT_TYPE_CODE = ''OPERATION''

Line 296: ahl_Workorder_Operations wop,

292: pf.full_name employee_name
293: FROM
294: ahl_Work_Assignments wass,
295: ahl_Operation_Resources opr,
296: ahl_Workorder_Operations wop,
297: per_people_f pf,
298: per_Person_Types Pt
299: WHERE
300: wass.Operation_Resource_Id = opr.operation_resource_id and

Line 316: ahl_workorder_operations

312: SELECT
313: workorder_operation_id,
314: operation_sequence_num
315: FROM
316: ahl_workorder_operations
317: WHERE
318: workorder_id = p_workorder_id;
319:
320: --Cursor for getting workorder plan_id and collection id

Line 337: AHL_WORKORDER_OPERATIONS

333: OPERATION_SEQUENCE_NUM, --balaji added for Bug 6777371
334: PLAN_ID,
335: COLLECTION_ID
336: FROM
337: AHL_WORKORDER_OPERATIONS
338: WHERE
339: workorder_id = p_wo_id;
340:
341: --declare all local variables here.

Line 580: AHL_WORKORDER_OPERATIONS WOP

576: ,wop.operation_sequence_num
577: ,''LINE'')),
578: ''YYYY-MM-DD hh:mm:ss+HH:MM'') Assigned_End_Date
579: FROM
580: AHL_WORKORDER_OPERATIONS WOP
581: GROUP BY workorder_id
582: ) WODE ';
583:
584: l_wo_con_query := l_wo_con_query || l_wo_details_where;