Query to find sales order type in oracle apps

Query to find sales order type in oracle apps

In this post , We will be discuss about Query to find sales order type in oracle apps. Sale Order Type is very important to define the Sales Order in Oracle apps. Sale Order Type helps to determine the next processing steps of the Sales order. So system process the Sale Order as per the sale order type attached to that. Each Sales Order type attach to the Different Oracle Workflows and each workflows process the sale order with different steps. Like Standard Sale Order have different Steps and RMA sale order have different steps So here below I will share the SQL Query to find sales order type in oracle apps.

Important Table of sales order type in oracle apps

1. OE_TRANSACTION_TYPES_TL

 

This Query helps to find all the Sale Order Transaction Types in Oracle Apps.

 

Select * from oe_transaction_types_tl

 

SQL Query to find sales order type With Sales Order in oracle apps

SELECT ooha.header_id, ooha.order_number, ott.NAME "ORDER TYPE",
 hp.party_name "CUSTOMER", hca.account_number "CUSTOMER NUMBER",
 ooha.ordered_date "DATE ORDERED",
 ooha.transactional_curr_code "CURRENCY",
 ooha.cust_po_number "CUSTOMER PO",
 ooha.freight_carrier_code "SHIPPING METHOD",
 ooha.flow_status_code "STATUS"
 FROM oe_order_headers_all ooha,
 oe_transaction_types_tl ott,
 hz_cust_accounts hca,
 hz_parties hp
 WHERE 1 = 1
 AND ooha.order_number = :P_ORDER_NUMBER
 AND ooha.sold_to_org_id = hca.cust_account_id
 AND ooha.order_type_id = ott.transaction_type_id
 AND ott.LANGUAGE = USERENV ('LANG')
 AND hca.party_id = hp.party_id