24: p_department_code,
25: p_department_id,
26: p_prev_op_seq_num,
27: p_next_op_seq_num
28: from bom_standard_operations bso,
29: bom_departments bd,
30: wip_operations wo
31: where wo.organization_id = p_org_id
32: /* %cfm Ignore cfm ops. */
106: bd.department_code,
107: wo.minimum_transfer_quantity,
108: wo.quantity_waiting_to_move,
109: WIP_CONSTANTS.YES allow_moves
110: from bom_standard_operations bso,
111: bom_departments bd,
112: wip_operations wo
113: where wo.operation_seq_num =
114: (select max(operation_seq_num)
157: bd.department_code,
158: wo.minimum_transfer_quantity,
159: wo.quantity_waiting_to_move,
160: WIP_CONSTANTS.NO allow_moves
161: from bom_standard_operations bso,
162: bom_departments bd,
163: wip_operations wo
164: where wo.operation_seq_num =
165: (select max(operation_seq_num)
269: wo.operation_seq_num,
270: bso.operation_code,
271: wo.department_id,
272: bd.department_code
273: from bom_standard_operations bso,
274: bom_departments bd,
275: wip_operations wo
276: where wo.operation_seq_num =
277: (select min(operation_seq_num)