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 281: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662

277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
278:
279: v_express VARCHAR2(100);
280: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
281: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
282:
283: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
284: select order_header_id
285: from JAI_OM_WSH_LINES_ALL

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

1030:
1031: 24. 02/06/2004 ssumaith - bug# 3657662 - File Version 115.1
1032:
1033: There was a performance problem with a query . The issue was it was taking time because
1034: of a full table scan on the oe_order_headers_all table.
1035:
1036: Issue was resolved by retreiving the order_header_id from the JAI_OM_WSH_LINES_ALL
1037: based on delivery id and adding a where clause to qualify the order_header_id.
1038:

Line 3046: oe_order_headers_all sha,

3042:
3043: FROM
3044:
3045: oe_order_lines_all sla,
3046: oe_order_headers_all sha,
3047: po_requisition_headers_all prha,
3048: po_requisition_lines_all prla,
3049: JAI_OM_WSH_LINES_ALL spl,
3050: rcv_shipment_headers rsh