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 145: ln_test_delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%TYPE; --Added by Ramananda for Bug#4533114

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

Line 307: from JAI_OM_WSH_LINES_ALL

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
308: where delivery_id = p_shipment_num;
309:
310: /* bug 4516678. Added by Lakshmi Gopalsami */
311:

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

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

Line 4183: JAI_OM_WSH_LINES_ALL spl,

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
4185:
4186: WHERE
4187:

Line 4194: from JAI_OM_WSH_LINES_ALL

4190: AND sla.header_id = sha.header_id
4191: AND sha.header_id in /* following subquery added by ssumaith - 3772135*/
4192: (
4193: select order_header_id
4194: from JAI_OM_WSH_LINES_ALL
4195: where delivery_id = v_shipment_num
4196: )
4197: /* = v_order_header_id -- ssumaith - bug# 3657662*/
4198: and sla.source_document_line_id = prla.requisition_line_id