DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 251: from mtl_system_items_b msi

247: select msi.revision_qty_control_code,
248: msi.lot_control_code,
249: msi.serial_number_control_code
250: into l_revision_control_code, l_lot_control_code, l_serial_control_code
251: from mtl_system_items_b msi
252: where msi.organization_id = p_org_id
253: and msi.inventory_item_id = p_component_id;
254:
255: if ( l_lot_control_code = WIP_CONSTANTS.LOT ) then

Line 1825: from mtl_system_items_b

1821: l_control_code Number := 1; /* 1- NC , 2 - LC , 3 - SC/ST */
1822: Begin
1823: select lot_control_code,serial_number_control_code
1824: into l_lot_control,l_serial_control
1825: from mtl_system_items_b
1826: where inventory_item_id = p_comp_item_id
1827: and organization_id = p_org_id;
1828:
1829: if l_lot_control = 2 then