ERPstuff - Oracle EBS Community

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....

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'

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