Lawrencxe
Lawrencxe

Reputation: 81

Query to get the Shipping Method and Payment Terms of Sales Order

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

Answers (1)

EdHayes3
EdHayes3

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

Related Questions