DBA Data[Home] [Help]

APPS.OTA_WF dependencies on OE_ORDER_HEADERS

Line 936: l_order_number oe_order_headers.order_number%type;

932:
933: l_uom oe_order_lines.order_quantity_uom%type;
934: l_proc varchar2(72) := g_package||'check_uom';
935: l_line_id oe_order_lines.line_id%type := to_number(itemkey);
936: l_order_number oe_order_headers.order_number%type;
937: l_line_number oe_order_lines.line_number%type;
938: l_email_address per_people_f.email_address%type;
939: l_description varchar2(200);
940:

Line 949: oe_order_headers_all oh

945: oh.order_number,
946: ol.line_number
947: FROM
948: oe_order_lines_all ol,
949: oe_order_headers_all oh
950: WHERE
951: oh.header_id = ol.header_id and
952: ol.line_id = l_line_id;
953:

Line 1711: oe_order_headers_all oh

1707: oh.order_number,
1708: ol.line_number
1709: FROM
1710: oe_order_lines_all ol,
1711: oe_order_headers_all oh
1712: WHERE
1713: oh.header_id = ol.header_id and
1714: ol.line_id = l_line_id;
1715: