Reputation: 81
I'm creating a report that contains details of sales order per order number in BI Publisher using Oracle Fusion Cloud r13. Now, my problem is, I can't find the table that contains the shipping method
and payment terms
. I tried to search it to Google but I can't find anything that can help me. Can someone here knows what the query for it is? Or the table only. Thanks
Upvotes: 0
Views: 9356
Reputation: 1953
These should help you. You'll have to do some more digging to know what exactly these do and how to link to them.
Don't forget about select * from all_tab_cols
you can query against that to find any table that has a column your looking for.
Also, while in Oracle EBS, there's always the help, diagnostics, examine which should get you the field. And record history will give you the table/view name
Ship Method
oe_order_headers_all.shipping_method_code
wsh_trips.ship_method_code
wsh_new_deliveries.ship_method_code
wsh_delivery_details.ship_method_code
wsh_carrier_ship_methods
wsh_carrier_services
Payment terms
oe_order_headers_all.payment_term_id
ra_terms_tl.payment_term_id
Upvotes: 0