Order Management  Interface with Validations , Interface Tables and Base Tables Information's.

-------------

Interface tables

1. Oe_headers_iface_all
2. oe_lines_iface_all

3. oe_price_adjs_iface_all
4. OE_PRICE_ATTS_IFACE_ALL
5. OE_ACTIONS_IFACE_ALL
6. OE_CREDITS_IFACE_ALL

Base Tables

1. OE_ORDER_HEADERS_ALL
2. OE_ORDER_LINES_ALL

Validations

1. Customer/Customer Site -   hz_cust_accounts,

                                         hz_cust_site_uses_all,hz_cust_acct_sites_all,hz_party_sites
2. Currency -- fnd_currencies
3. Price List -qp_list_headers
4. Transaction Type/Order Type -
5. Order Source --oe_order_sources
6. Payment Terms --ra_terms_tl
7. Item --mtl_system_items_b
8. Warehouse-org_organization_definitions
9. conversion Rate/type- gl_daily_conversion_types,gl_daily_rates
10. tax code--zx_rates_b

 

Thank You...

Cheers ,

Avinash