Query behind the PO Release -> Tools -> View Document

Query behind the PO Release -> Tools -> View Document

In Oracle ebs R12 we have some reports like the above. 

form name: POXPOERL

view name: PO_RELEASE_XML  

 SELECT text FROM all_views WHERE view_name = 'PO_RELEASE_XML';

We can select the text for the view.  Run the query, if there is any error on our report, by running the query for that release or po id. we can find out the error.

 

 

Query for banks list in oracle ebs r12

Query for banks list in oracle ebs r12

select * from ce_banks_v

 

Query for banks branch list in oracle ebs r12

select * from ce_bank_branches_v