DBA Data[Home] [Help]

APPS.WIP_MASSLOAD_PVT dependencies on MTL_SYSTEM_ITEMS

Line 111: from mtl_system_items

107: update wip_discrete_jobs
108: set serialization_start_op = l_serStartOp
109: where wip_entity_id = wjsi_row.wip_entity_id
110: and exists (select 1
111: from mtl_system_items
112: where inventory_item_id = wjsi_row.primary_item_id
113: and organization_id = wjsi_row.organization_id
114: and serial_number_control_code = wip_constants.full_sn);
115: elsif ( l_defaultSer = wip_constants.yes ) then

Line 122: from mtl_system_items

118: from wip_operations
119: where wip_entity_id = wjsi_row.wip_entity_id)
120: where wip_entity_id = wjsi_row.wip_entity_id
121: and exists (select 1
122: from mtl_system_items
123: where inventory_item_id = wjsi_row.primary_item_id
124: and organization_id = wjsi_row.organization_id
125: and serial_number_control_code = wip_constants.full_sn);
126: end if;