DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINE_TYPES

Line 2031: x_order_type po_line_types.order_type_lookup_code%type;

2027: v_accr_rcpt_cnt number;
2028: v_qty_rcvd number;
2029: x_display_stat varchar2(1) :='Y';
2030: x_price_change po_lines_all.allow_price_override_flag%type;
2031: x_order_type po_line_types.order_type_lookup_code%type;
2032: l_return_status varchar2(3);
2033: l_retro_active_price_change varchar2(3);
2034: l_doc_type varchar2(25);
2035: x_po_header_id po_headers_all.po_header_id%type;

Line 2071: from po_lines_all pol,po_line_types polt

2067: --PO API does not cover this.
2068: begin
2069: select polt.ORDER_TYPE_LOOKUP_CODE,PO_HEADER_ID
2070: into x_order_type,x_po_header_id
2071: from po_lines_all pol,po_line_types polt
2072: where pol.po_line_id = p_po_line_id and
2073: pol.line_type_id = polt.line_type_id;
2074: exception
2075: when no_data_found then