APPS.MRP_CL_FUNCTION dependencies on AHL_WORKORDERS

Line 1671: ' from AHL_WORKORDERS_SN ' ||

1667: EXECUTE IMMEDIATE lv_trunc_stmt;
1668:
1669: lv_sql_stmt :=
1670: 'select WIP_ENTITY_ID, ORGANIZATION_ID ' ||
1671: ' from AHL_WORKORDERS_SN ' ||
1672: ' where ITEM_ALTERNATES_EXIST = ''Y''';
1673:
1674: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Cursor lv_sql_stmt : '|| lv_sql_stmt );
1675:

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: