APPS.WIP_OPERATIONS_INFO dependencies on WIP_OPERATIONS

Line 1: PACKAGE BODY WIP_OPERATIONS_INFO AS

1: PACKAGE BODY WIP_OPERATIONS_INFO AS
2: /* $Header: wipopinb.pls 120.2 2006/03/01 16:35:22 hshu noship $ */
3:
4: procedure derive_info(
5: p_org_id in number,

Line 30: wip_operations wo

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. */
33: and nvl(bso.operation_type, 1) = 1
34: and bso.line_id is null

Line 62: wip_operations wo1,

58: min(wo2.operation_seq_num)
59: into p_prev_op_seq_num,
60: p_next_op_seq_num
61: from dual sd,
62: wip_operations wo1,
63: wip_operations wo2
64: where wo1.organization_id(+) = p_org_id
65: and wo1.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
66: and wo1.operation_seq_num(+) < p_operation_seq_num

Line 63: wip_operations wo2

59: into p_prev_op_seq_num,
60: p_next_op_seq_num
61: from dual sd,
62: wip_operations wo1,
63: wip_operations wo2
64: where wo1.organization_id(+) = p_org_id
65: and wo1.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
66: and wo1.operation_seq_num(+) < p_operation_seq_num
67: and wo2.organization_id(+) = p_org_id

Line 79: proc_name => 'WIP_OPERATIONS_PKG.DERIVE_INFO');

75: exception
76: when others then
77: wip_constants.get_ora_error(
78: application => 'WIP',
79: proc_name => 'WIP_OPERATIONS_PKG.DERIVE_INFO');
80: fnd_message.raise_error;
81: end derive_info;
82:
83: procedure last_operation(

Line 112: wip_operations wo

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)
115: from wip_operations wo1
116: where wo1.organization_id = wo.organization_id

Line 115: from wip_operations wo1

111: bom_departments bd,
112: wip_operations wo
113: where wo.operation_seq_num =
114: (select max(operation_seq_num)
115: from wip_operations wo1
116: where wo1.organization_id = wo.organization_id
117: and wo1.wip_entity_id = wo.wip_entity_id
118: and (wo1.repetitive_schedule_id is NULL
119: or

Line 163: wip_operations wo

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)
166: from wip_operations wo1
167: where wo1.organization_id = wo.organization_id

Line 166: from wip_operations wo1

162: bom_departments bd,
163: wip_operations wo
164: where wo.operation_seq_num =
165: (select max(operation_seq_num)
166: from wip_operations wo1
167: where wo1.organization_id = wo.organization_id
168: and wo1.wip_entity_id = wo.wip_entity_id
169: and (wo1.repetitive_schedule_id is NULL
170: or

Line 275: wip_operations wo

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)
278: from wip_operations wo1
279: where wo1.organization_id = wo.organization_id

Line 278: from wip_operations wo1

274: bom_departments bd,
275: wip_operations wo
276: where wo.operation_seq_num =
277: (select min(operation_seq_num)
278: from wip_operations wo1
279: where wo1.organization_id = wo.organization_id
280: and wo1.wip_entity_id = wo.wip_entity_id
281: and (wo1.repetitive_schedule_id is NULL
282: or

Line 323: END WIP_OPERATIONS_INFO;

319:
320: end first_operation;
321:
322:
323: END WIP_OPERATIONS_INFO;