DBA Data[Home] [Help]

APPS.WIP_JSI_DEFAULTER dependencies on WIP_OPERATIONS

Line 211: from wip_operations

207:
208: elsif(l_default = wip_constants.yes) then
209: update wip_discrete_jobs
210: set serialization_start_op = (select nvl(min(operation_seq_num), 1)
211: from wip_operations
212: where wip_entity_id = l_wipID)
213: where wip_entity_id = l_wipID
214: and exists (select 1
215: from mtl_system_items

Line 1031: from wip_operations wo

1027: from wip_discrete_jobs wdj
1028: where wdj.wip_entity_id = wjsi_row.wip_entity_id
1029: and wdj.organization_id = wjsi_row.organization_id
1030: and exists ( select operation_seq_num
1031: from wip_operations wo
1032: where wo.wip_entity_id = wdj.wip_entity_id and
1033: wo.organization_id = wdj.organization_id
1034: minus
1035: select operation_seq_num