APPS.JAI_RCV_TAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 83: v_so_currency oe_order_headers_all.transactional_curr_code % TYPE; -- added

79: v_tax_total NUMBER; --File.Sql.35 Cbabu := 0;
80: -- v_line_id so_lines_all.line_id % type; --commented by GSri and Jagdish on 5-may-01
81: v_line_id oe_order_lines_all.line_id % TYPE; --added by GSri and Jagdish on 5-may-01
82: v_rg_type VARCHAR2(30);
83: v_so_currency oe_order_headers_all.transactional_curr_code % TYPE; -- added
84: v_req_id NUMBER;
85: v_result BOOLEAN;
86: v_currency_code rcv_transactions.currency_code % TYPE;
87: v_currency_conversion_rate rcv_transactions.currency_conversion_rate % TYPE;

Line 303: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662

299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
300:
301: v_express VARCHAR2(100);
302: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
303: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
304:
305: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
306: select order_header_id
307: from JAI_OM_WSH_LINES_ALL

Line 1126: of a full table scan on the oe_order_headers_all table.

1122:
1123: 24. 02/06/2004 ssumaith - bug# 3657662 - File Version 115.1
1124:
1125: There was a performance problem with a query . The issue was it was taking time because
1126: of a full table scan on the oe_order_headers_all table.
1127:
1128: Issue was resolved by retreiving the order_header_id from the JAI_OM_WSH_LINES_ALL
1129: based on delivery id and adding a where clause to qualify the order_header_id.
1130:

Line 4180: oe_order_headers_all sha,

4176:
4177: FROM
4178:
4179: oe_order_lines_all sla,
4180: oe_order_headers_all sha,
4181: po_requisition_headers_all prha,
4182: po_requisition_lines_all prla,
4183: JAI_OM_WSH_LINES_ALL spl,
4184: rcv_shipment_headers rsh