Suppose we have to restrict some values in Sub inventory LOV on Miscellaneous Transactions form in inventory.
Argument
SELECT secondary_inventory_name, description, quantity_tracked,
asset_inventory, locator_type, material_account
FROM mtl_item_sub_val_v
WHERE --your conditions according to business scenarios
AND organization_id = :MTL_TRX_LINE.ORGANIZATION_ID --fields passing from form
AND inventory_item_id = :mtl_trx_line.inventory_item_id --fields passing from form
The interesting part is that when we open the LOV of sub inventory only sub inventory and its description is shown, but in query we have to select various columns too. So whenever we have to change any LOV we have to open that particular form through Oracle Forms Developer and on filed we have to check its LOV and from LOV we have to track its Record Group. In record group query we came to know that 6 columns have to be selected if we want to personalize this. Screen Shots are uploaded below.
Argument
SELECT secondary_inventory_name, description, quantity_tracked,
asset_inventory, locator_type, material_account
FROM mtl_item_sub_val_v
WHERE --your conditions according to business scenarios
AND organization_id = :MTL_TRX_LINE.ORGANIZATION_ID --fields passing from form
AND inventory_item_id = :mtl_trx_line.inventory_item_id --fields passing from form
The interesting part is that when we open the LOV of sub inventory only sub inventory and its description is shown, but in query we have to select various columns too. So whenever we have to change any LOV we have to open that particular form through Oracle Forms Developer and on filed we have to check its LOV and from LOV we have to track its Record Group. In record group query we came to know that 6 columns have to be selected if we want to personalize this. Screen Shots are uploaded below.
Moreover, below mentioned might also be helpful
How To Customize a LOV using Form Personalization ? (Doc ID 726324.1)
what a great work by asad........i was really in need of this issue
ReplyDelete