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