How to generate alerts via forms in Oracle 10g?

20 pts.
Tags:
Oracle 10g
Oracle coding
Oracle Forms
Hi all,
   SELECT Count(1)
   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..

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • sivasurya
    can any one please help me on this code please , i have urgent requirement...
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following