Order Uploaded Search Page @ ADF

1.Create an Application with Project
2.Connect to DataBase
3.Create AM
4.Create VO

Query in VO::

select h.price_list_id as pricelist,r.customer_number,r.customer_name,h.sold_to_org_id,h.cust_po_number, h.order_number Sales_Order,h.attribute1 Price,h.attribute10
,h.booked_flag,''''||h.header_id||''''||',' Header_ID,to_char(h.creation_date,'MM-DD-YYYY HH:MI:SS') Creation_Date
from oe_order_headers_all h, ra_customers r
where h.sold_to_org_id = r.customer_id
and to_char(h.creation_date,'MMDDYYYY')='06142016'-- > sysdate-0.5
order by h.creation_date desc;

5.Open adfc-config-xml file(Double Click on it)(UnBonded TaskFlow)
6.Drag and "View" object on to adfc-config-xml
7.Rename as Order-Search-Page
8.Double Click on Order-Search-Page (.jsf page will be created(select blank page))
9.From Data Controls in Application window select the data control  drop on the (.jsf file)
   select Query
   select ADF Query Panel with Table
10.Change the heading names(your wish)


11. (Optional) you can change the skin type by double click on trinidad-config-xml file and change

 <skin-family>fusionFx</skin-family>
  <skin-version>v1.1</skin-version>

Run the page

OutPut::

END