APPS.WIP_OPERATIONS_INFO dependencies on STANDARD

Line 28: from bom_standard_operations bso,

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. */

Line 42: and bso.standard_operation_id (+) = wo.standard_operation_id

38: and (wo.repetitive_schedule_id is null
39: or
40: wo.repetitive_schedule_id = p_first_schedule_id)
41: and bso.organization_id (+) = wo.organization_id
42: and bso.standard_operation_id (+) = wo.standard_operation_id
43: and bd.organization_id = wo.organization_id
44: and bd.department_id = wo.department_id;
45:
46: x_operation_exists := TRUE;

Line 110: from bom_standard_operations bso,

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)

Line 126: and wo.standard_operation_id = bso.standard_operation_id (+)

122: and nvl(bso.operation_type, 1) = 1
123: and bso.line_id is null
124: /* %/cfm */
125: and wo.department_id = bd.department_id
126: and wo.standard_operation_id = bso.standard_operation_id (+)
127: and wo.organization_id = c_org_id
128: and wo.wip_entity_id = c_wip_entity_id
129: and (wo.repetitive_schedule_id is NULL
130: or

Line 161: from bom_standard_operations bso,

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)

Line 177: and wo.standard_operation_id = bso.standard_operation_id (+)

173: and nvl(bso.operation_type, 1) = 1
174: and bso.line_id is null
175: /* %/cfm */
176: and wo.department_id = bd.department_id
177: and wo.standard_operation_id = bso.standard_operation_id (+)
178: and wo.organization_id = c_org_id
179: and wo.wip_entity_id = c_wip_entity_id
180: and (wo.repetitive_schedule_id is NULL
181: or

Line 273: from bom_standard_operations bso,

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)

Line 289: and wo.standard_operation_id = bso.standard_operation_id (+)

285: and nvl(bso.operation_type, 1) = 1
286: and bso.line_id is null
287: /* %/cfm */
288: and wo.department_id = bd.department_id
289: and wo.standard_operation_id = bso.standard_operation_id (+)
290: and wo.organization_id = c_org_id
291: and wo.wip_entity_id = c_wip_entity_id
292: and (wo.repetitive_schedule_id is NULL
293: or