How to Restrict Item to a particular Subinventory

Oracle 

Form Personalization: How to Restrict Item to a particular Subinventory

We can restrict item to a particular subinventory by using form personalization.

1.Navigation to Miscellaneous Transaction

Navigation: Inventory --> Transactions --> Miscellaneous Transactions.

Click on Transaction Lines.

2.Go to Form Personalization

3.Enter the following information in respective fields.

A. Enter the Seq no,Description and Level is Form.
B. Under condition tab Enter following information

     --> Trigger Event  = WHEN-NEW-ITEM-INSTANCE

     --> Trigger Object = MTL_TRX_LINE.SUBINVENTORY_CODE

     --> Processing Mode = Both.

C. Under Actions tab enter the following information.

Seq                = 1
Type              = Property
Description    = Global Varible
Language       = All
Enable           = Yes

Object Type     = Global Varible
Target Object   = G_ITEM_NAME
Property Name = VALUE
Value                = =:MTL_TRX_LINE.ITEM

Seq           = 7
Type         = Builtin
Language  = All
Enable      = yes.

Builtin Type = Create Record Group from Query

Argument =

 select secondary_inventory_name ,description, quantity_tracked, asset_inventory, locator_type, material_account

 from mtl_subinventories_val_v

 where organization_id = :parameter.org_id

and inv_material_status_grp.is_status_applicable(

    :parameter.wms_installed

,    :mtl_trx_header.trx_status_enabled

,   decode(:mtl_trx_header.transaction_type_id,-99,:mtl_trx_line.transaction_type_id,:mtl_trx_header.transaction_type_id)

,    NULL

,    NULL

,    :parameter.org_id

,    :mtl_trx_line.inventory_item_id

,    secondary_inventory_name

,    NULL

,    NULL

,    NULL

,    nvl(:mtl_trx_header.material_status_object_type,'Z') ) = 'Y' 

and SECONDARY_INVENTORY_NAME in (select SECONDARY_INVENTORY from MTL_ITEM_SUB_INVENTORIES_ALL_V

where INVENTORY_ITEM_ID in (select INVENTORY_ITEM_ID from MTL_SYSTEM_ITEMS_FVL

where  SEGMENT1 =:GLOBAL.G_ITEM_NAME))

Group Name = XX_Sub

 

Seq   = 10

Type = Property
Language =  All
Enable  = yes.


Object Type     = LOV
Target Object   = SUBINVENTORY
Property Name = GROUP_NAME
Value                = XX_Sub

Click on Apply Now.

Save Your work.

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/