Oracle Apps 11i & 12i Sales Order Type Name Query
Select Ot.NAME /*Order Type Name*/
From apps.oe_transaction_types_tl Ot, /*All Sales Order Type */
apps.oe_order_headers_all h
Where
Select Ot.NAME /*Order Type Name*/
From apps.oe_transaction_types_tl Ot, /*All Sales Order Type */
apps.oe_order_headers_all h
Where
H.Order_Number = <Order_Number> /*Put Order Number and Show Sales Order type */
And H.order_type_id = ot.transaction_type_id /*Join Order Header id and Transaction Type Id */
No comments:
Post a Comment