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