i have 2 areas where a Vendor Name will work, in user_name = 'KnS' and user_type='vendor', a brand name will be 'KnS'
- user will select a vendor from a Select list in order header area (for vendor orders there is a separate master-detail form)
- in order's detail area, user should have all items in PopUp LOV related to that vendor (here this will reference as Brand)
created a page item P34_VENDORNAME which value sets from DA after Change of Vendor (i keep it visible to check value sets it seems fine) and reference it in a List of Value ( b.brand_name = :P34_VENDORNAME ) created it under Shared Components and reference that page item but can't see related items, then created a pate item in Global Page say P0_VENDORNAME, referenced this in same query of LOV ( b.brand_name = :P0_VENDORNAME ) but still i can't see any related item.
how it can be achieved, my approach is wrong, i am doing something wrong or missing any part of this procedure? how to reference page item in LOV query created in Shared Components? please help.
regards