FROM regal.regal_inv_landed_cost_tab a
WHERE organization_id = 81
and not exists(SELECT a2.inventory_item_id FROM mtl_system_items_kfv a2 where a1.inventory_item_id =a2.inventory_item_id
and a2.organization_id = 82
AND Nvl(a2.inventory_item_status_code, 'Inactive' ) = 'Inactive')
AND file_number =:RHCLANDEDCOSTHEADER.file_number;
For 1 file_number i have 10 items are there , for example i have selected xyz (ACTIVE),123(INACTIVE),ASQ(INACTIVE) item_numbers (i have select flag)
I want to get messages in the form, like "123 ,ASQ items are INACTIVE"
Could you please help me on how to write a code please , i am new to the Oracle forms 10g
I want a code on if it is ACTIVE Then fine, if it is INACTIVE Then i need the messages in the form like--> "1,2,3 items are INACTIVE"
How to implement the code..