DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINE_TYPES

Line 1884: x_order_type po_line_types.order_type_lookup_code%type;

1880: v_accr_rcpt_cnt number;
1881: v_qty_rcvd number;
1882: x_display_stat varchar2(1) :='Y';
1883: x_price_change po_lines_all.allow_price_override_flag%type;
1884: x_order_type po_line_types.order_type_lookup_code%type;
1885: l_return_status varchar2(3);
1886: l_retro_active_price_change varchar2(3);
1887: l_doc_type varchar2(25);
1888: x_po_header_id po_headers_all.po_header_id%type;

Line 1924: from po_lines_all pol,po_line_types polt

1920: --PO API does not cover this.
1921: begin
1922: select polt.ORDER_TYPE_LOOKUP_CODE,PO_HEADER_ID
1923: into x_order_type,x_po_header_id
1924: from po_lines_all pol,po_line_types polt
1925: where pol.po_line_id = p_po_line_id and
1926: pol.line_type_id = polt.line_type_id;
1927: exception
1928: when no_data_found then