Thursday 2 July 2015

Sales Order Type Name in 11i and 12i

11i & 12i Same Query (Sales Order Type Name)
Select Distinct ot.NAME
From apps.oe_transaction_types_tl Ot,
apps.oe_order_headers_all h
Where Ot.NAME = 'KROSS LUT ORDER'
And h.HEADER_ID = :ORDER_HEADER_ID
h.order_type_id = ot.transaction_type_id

No comments:

Post a Comment