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....
Tables in OM
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'
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'
Who is online
Users browsing this forum: No registered users and 0 guests