This content has been marked as final. Show 9 replies
+"...I have an lov for dept_id, If the user is the not manager of that department, then I populate a message, you are not the supervisor..."+
So why don't you, from the beginning, display a LOV that includes only the allowed departments ?
For the second question, a LOV is based on a Record Group that can be re-created at runtime with the Create_Group_From_Query() built-in.
I have a requirement to populate an LOV in a Form Which is taking LOT of TIME (PERFORMANCE ISSUE)
the Record Group Query is as
select segment1 INVENTORY_ITEM ,
decode(service_item_flag, 'Y', service_duration, NULL) service_duration,
Decode( serviceable_product_flag,'Y','SVA','STD'))) item_type_code
from mtl_system_items_b --table name
where organization_id = :QOTLNDET_LINES.ORGANIZATION_ID
AND (bom_item_type = 1 or bom_item_type = 4)
AND vendor_warranty_flag = 'N'
AND primary_uom_code <> 'ENR'
AND ((:QOTLNDET_LINES.LINE_CATEGORY_CODE = 'ORDER' and customer_order_enabled_flag = 'Y') OR
(:LINE_CATEGORY_CODE = 'RETURN' and NVL(returnable_flag, 'Y') = 'Y'))
AND segment1 like :QOTLNDET_LINES.INVENTORY_ITEM || '%'
When ever i give :QOTLNDET_LINES.INVENTORY_ITEM from Front end This LOV need to be displayed.
IT IS TAKING MORE THAT 3 MINUTES DEPENDING ON THE ITEM GIVEN.
SUGGEST ME TO REDUCE THIS TIME.