DBA Data[Home] [Help]

APPS.OE_DEMAND_STREAM_PROCESSOR dependencies on SO_ORDER_TYPES

Line 72: so_order_types sot

68: x_entry_status,
69: x_po_number
70: FROM
71: so_headers soh,
72: so_order_types sot
73: WHERE
74: sot.order_type_id = soh.order_type_id
75: AND sot.name = x_order_type_name
76: AND soh.order_number = x_order_number;

Line 165: so_order_types sot

161: x_entry_status,
162: x_po_number
163: FROM
164: so_headers soh,
165: so_order_types sot
166: WHERE
167: sot.order_type_id = soh.order_type_id
168: AND soh.header_id = x_header_id;
169:

Line 544: so_order_types t

540: l_order_number,
541: l_order_type
542: FROM
543: so_headers h,
544: so_order_types t
545: WHERE
546: h.order_type_id = t.order_type_id
547: AND h.header_id = x_header_id;
548: