[Home] [Help]
159:
160: CURSOR c_so_picking_tax_record_ns
161: IS
162: SELECT DISTINCT 1
163: FROM JAI_OM_WSH_LINE_TAXES
164: WHERE delivery_detail_id IS NULL
165: AND order_line_id = TO_NUMBER(v_interface_line_attribute6);
166:
167: CURSOR c_so_picking_tax_lines_info_ns
187: , jowlt.precedence_9
188: , jowlt.precedence_10
189: , jowla.vat_invoice_no
190: , jowla.vat_invoice_date
191: FROM JAI_OM_WSH_LINE_TAXES jowlt
192: , JAI_OM_WSH_LINES_ALL jowla
193: , JAI_CMN_TAXES_ALL jcta
194: WHERE jowlt.delivery_detail_id IS NULL
195: AND jowlt.order_line_id = jowla.order_line_id
209: WHERE customer_trx_id = pr_new.customer_trx_id;
210:
211: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
212: SELECT DISTINCT 1
213: FROM JAI_OM_WSH_LINE_TAXES A, JAI_OM_WSH_LINES_ALL b, WSH_NEW_DELIVERIES C
214: WHERE A.delivery_detail_id = b.delivery_detail_id
215: AND b.delivery_id = C.DELIVERY_ID AND
216: c.NAME = v_interface_line_attribute3
217: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
229: A.func_tax_amount,
230: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
231: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
232: b.vat_invoice_no,b.vat_invoice_date
233: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,
234: JAI_CMN_TAXES_ALL c, wsh_new_deliveries D
235: WHERE A.delivery_detail_id = b.delivery_detail_id
236: AND A.tax_id=c.tax_id
237: and c.tax_type <> 'Modvat Recovery'
242: CURSOR SO_PICKING_TAX_AMT(p_tax_id NUMBER) IS
243: SELECT SUM(A.base_tax_amount) base_tax_amount,
244: SUM(A.tax_amount) tax_amount,
245: SUM(A.func_tax_amount) func_tax_amount
246: FROM JAI_OM_WSH_LINE_TAXES A,JAI_OM_WSH_LINES_ALL b,WSH_NEW_DELIVERIES C
247: WHERE A.delivery_detail_id = b.delivery_detail_id
248: AND b.delivery_id = c.delivery_id
249: AND c.NAME = v_interface_line_attribute3
250: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6)
283: IS
284: SELECT SUM(base_tax_amount) base_tax_amount
285: , SUM(tax_amount) tax_amount
286: , SUM(func_tax_amount) func_tax_amount
287: FROM JAI_OM_WSH_LINE_TAXES
288: WHERE delivery_detail_id IS NULL
289: AND order_line_id = TO_NUMBER(v_interface_line_attribute6)
290: AND tax_id = p_tax_id
291: GROUP BY tax_id;
2078: FETCH so_picking_tax_record_check INTO v_exist_flag;
2079: CLOSE so_picking_tax_record_check;
2080:
2081: /*
2082: Check if taxes exist in JAI_OM_WSH_LINE_TAXES tables.
2083: IF yes then insert all the taxes into ja_in_ra_cust_trx_lines_all table
2084: IF no then check the same in ja_in_so_tax_lines_table.
2085:
2086: (
2296: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
2297:
2298:
2299: ELSE /* ELSE OF IF NVL(v_exist_flag,0) = 1 */
2300: -- for non-shippable items, need to fetch OFI taxes from JAI_OM_WSH_LINE_TAXES
2301: IF((v_interface_line_attribute3 IS NULL OR v_interface_line_attribute3 = '0') -- delivery_id
2302: AND v_interface_line_attribute6 IS NOT NULL -- order_line_id
2303: )
2304: THEN
2512: ELSE -- ELSE OF IF v_interface_line_attribute3 IS NULL ... ...
2513: -- else, the record is not non-shippable item
2514: -- original logic of getting taxes from JAI_OM_OE_SO_TAXES
2515: /*
2516: If records do not exist in JAI_OM_WSH_LINE_TAXES table then control comes to this portion of the code
2517: */
2518:
2519: OPEN ja_so_lines_tax_record_check ;
2520: FETCH ja_so_lines_tax_record_check INTO v_exist_flag;
2606: ;
2607: CLOSE ja_so_lines_info;
2608: ELSE /* ELSE FOR IF NVL(v_exist_flag,0) = 1 */
2609: /*
2610: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
2611: would come here.
2612: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table
2613: for the given line_id.
2614: */