hi srishan,
Oracle have more information in the HZ table now, I am not sure if views have all new data in. I decided do not work with them and work directly with tables, did not want to depend on Oracle views. Cannot help you with performance information on views, sorry.
Thanks.
Hi,
In APPS 11i you have to work with HZ tables in AR schema.
You still can use ra_addresses_all, ra_customers_all and
ra_site_uses_all - they are views in 11i. I don't know for
how long Oracle will be supporting those views.
You can find detail description for HZ tables on Metalink Top Tech...
In 11i you have to use OE_ACTIONS_IFACE_ALL table to book order. You can do it on the header or line level. For booking orders you have to use value 'BOOK_ORDER' in the OPERATION_CODE in the action table.
You also have ability to put on hold order header (whole order) or a line. Just set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.