DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on AHL_WORKORDER_OPERATIONS

Line 2655: from ahl_operations_b_kfv op, ahl_workorders awo, ahl_workorder_operations awop

2651: p_op_code VARCHAR2(200);
2652: BEGIN
2653: select op.concatenated_segments
2654: into p_op_code
2655: from ahl_operations_b_kfv op, ahl_workorders awo, ahl_workorder_operations awop
2656: where awo.workorder_id = awop.workorder_id
2657: and awop.operation_id = op.operation_id
2658: and awo.wip_entity_id = p_wip_entity_id
2659: and awop.operation_sequence_num = p_op_seq_num;

Line 2690: from ahl_workorders aw, ahl_workorder_operations awop

2686:
2687: ELSIF p_maint_obj_src = 2 THEN
2688: select to_char(awop.actual_start_date,'DD-MON-YYYY')||'#'||to_char(awop.actual_end_date,'DD-MON-YYYY')
2689: into p_actual_dates
2690: from ahl_workorders aw, ahl_workorder_operations awop
2691: where aw.workorder_id = awop.workorder_id
2692: and aw.wip_entity_id = p_wip_entity_id
2693: and awop.operation_sequence_num = p_op_seq_num;
2694: