DBA Data[Home] [Help]

APPS.WIP_MASSLOAD_PVT dependencies on MTL_SYSTEM_ITEMS

Line 126: from mtl_system_items

122: update wip_discrete_jobs
123: set serialization_start_op = l_serStartOp
124: where wip_entity_id = wjsi_row.wip_entity_id
125: and exists (select 1
126: from mtl_system_items
127: where inventory_item_id = wjsi_row.primary_item_id
128: and organization_id = wjsi_row.organization_id
129: and serial_number_control_code = wip_constants.full_sn);
130: elsif ( l_defaultSer = wip_constants.yes ) then

Line 137: from mtl_system_items

133: from wip_operations
134: where wip_entity_id = wjsi_row.wip_entity_id)
135: where wip_entity_id = wjsi_row.wip_entity_id
136: and exists (select 1
137: from mtl_system_items
138: where inventory_item_id = wjsi_row.primary_item_id
139: and organization_id = wjsi_row.organization_id
140: and serial_number_control_code = wip_constants.full_sn);
141: end if;