APPS.WSMPWROT dependencies on WIP_OPERATIONS

Line 202: WIP_OPERATIONS O,

198: c.segment20,
199: o.first_unit_start_date,
200: o.department_id
201: FROM
202: WIP_OPERATIONS O,
203: BOM_INVENTORY_COMPONENTS A,
204: MTL_SYSTEM_ITEMS C,
205: BOM_EXPLOSION_TEMP BE
206: WHERE

Line 219: from wip_operations o1

215: -- so that records are inserted in WRO for the last operation also.
216: AND O.operation_seq_num IN
217: (
218: SELECT max (o1.operation_seq_num)
219: from wip_operations o1
220: where
221: o1.wip_entity_id = p_wip_entity_id
222: and o1.operation_sequence_id = o.operation_sequence_id
223: and not exists (

Line 336: FROM WIP_OPERATIONS

332: l_stmt_num := 10;
333:
334: SELECT max(operation_seq_num)
335: INTO x_operation_seq_num
336: FROM WIP_OPERATIONS
337: WHERE operation_sequence_id=p_operation_sequence_id
338: and wip_entity_id = p_wip_entity_id;
339:
340: l_stmt_num := 15;

Line 344: FROM WIP_OPERATIONS

340: l_stmt_num := 15;
341:
342: SELECT first_unit_start_date, last_unit_completion_date, department_id
343: INTO x_start_date, x_completion_date, x_department_id
344: FROM WIP_OPERATIONS
345: WHERE wip_entity_id = p_wip_entity_id
346: AND organization_id = p_organization_id
347: AND operation_seq_num = x_operation_seq_num;
348: