Tables in OM

[Hadi_apps]

Hi,

Can any body help me what are the regularly used tables and columns in Oracle Order Management? If any documents related to this tables plz tell me.


regards....

[Ritz]

You need to refer to Oracle Order management TRM for this.

To help you get started I have posted few SQL commands for the table name and the column name. I do Not know which version you work on , so I have taken examples of 2 versions-

Ritz

CODE ?

11i

select * from oe_order_headers_all where order_number ='7002981'

select * from oe_order_lines_all where header_id ='8906'

select * from xxont_interface_errors where attribute1 like '%8906%'

select * from ra_customers where customer_name like '%cummins%'

select * from ra_customers where customer_id like '%222%'

To see the status code ?

select flow_STATUS_CODE , line_id from oe_order_lines_all where header_id ='8544'

to see the flow status code

select FLOW_STATUS_CODE from oe_order_headers_all where order_number = '7002800'

select flow_STATUS_CODE from oe_order_lines_all where header_id ='8544'

select * from oe_price_adjustments where header_id='8544' (This is to check if the handling fees is being applied or not)

10.7

select * from so_headers_interface_all where customer_id = '3489'

Select * from so_headers_all where order_number=?7002980?

select * from so_lines_all where header_id='531089'

select * from ra_customers where customer_id=2098

select * from ra_site_uses_all where location like '%5100 EAST 58TH AVE%'

to find out if any lines are errored ?

select process_status from ceco_oe_header_stg where order_number_source_id = '7002800'

[ravishyni]

Hi, U can find these tables in Oracle OM 11i version

oe_order_headers_all
oe_order_lines_all
ic_item_mst
mtl_system_items
hz_cust_accounts
hz_cust_acct_sites_all
oe_transaction_types_tl
oe_transaction_types_all
hz_cust_sites_users_all
ja_in_customer_address

Regards

Raviraj KS