APPS.JAI_RCV_TAX_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added

95: v_gl_set_of_books_id gl_sets_of_books.set_of_books_id % TYPE;
96: v_conv_factor NUMBER;
97: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
98: v_duplicate_ship VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added
100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;

Line 143: ln_test_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%TYPE; --Added by Ramananda for Bug#4533114

139: lv_vat_recoverable_for_item JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE;
140: lv_process_flag VARCHAR2(2);
141: lv_process_msg VARCHAR2(1000);
142: ln_vat_setup_chk NUMBER;
143: ln_test_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%TYPE; --Added by Ramananda for Bug#4533114
144: --Added by walton for inclusive tax
145: ---------------------------------------------
146: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
147: TYPE tax_amt_num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 285: from JAI_OM_WSH_LINES_ALL

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
286: where delivery_id = p_shipment_num;
287:
288: /* bug 4516678. Added by Lakshmi Gopalsami */
289:

Line 1036: Issue was resolved by retreiving the order_header_id from the JAI_OM_WSH_LINES_ALL

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:
1039:
1040: 25. 04/06/2004 Nagaraj.s - Bug # 3655330 - File Version : 115.1

Line 3049: JAI_OM_WSH_LINES_ALL spl,

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
3051:
3052: WHERE
3053:

Line 3060: from JAI_OM_WSH_LINES_ALL

3056: AND sla.header_id = sha.header_id
3057: AND sha.header_id in /* following subquery added by ssumaith - 3772135*/
3058: (
3059: select order_header_id
3060: from JAI_OM_WSH_LINES_ALL
3061: where delivery_id = v_shipment_num
3062: )
3063: /* = v_order_header_id -- ssumaith - bug# 3657662*/
3064: and sla.source_document_line_id = prla.requisition_line_id