Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Canceled Requisitions Query
SELECT prh.requisition_header_id ,prh.preparer_id ,prh.segment1 "REQ NUM" ,TRUNC (prh.creation_date) ,prh.description ,prh.note_to_authorizer FROM apps.po_requisition_headers_all prh, apps.po_action_history pahWHERE action_code = 'CANCEL' AND pah.object_type_code = 'REQUISITION' AND pah.object_id = prh.requisition_header_id
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Get Flower Effect
No comments:
Post a Comment