[Home] [Help]
63: --| and also added p_debug parameter in process_batch |
64: --| procedure |
65: --| |
66: --| 23-Jan-2008 rchandan for bug#6766561 - file version 120.16 |
67: --| delete from jai_ar_trx_lines_ins_t was missing for |
68: --| autoinvoiced records. This has been added. |
69: --| This change is made to merge the fix of version |
70: --| 120.14 made for bug#6691354 |
71: --| |
246: IS
247: SELECT rctl.interface_line_attribute3, rctl.interface_line_attribute6
248: FROM ra_customer_trx_all trx,
249: ra_customer_trx_lines_all rctl,
250: jai_ar_trx_lines jrctl,
251: JAI_AR_TRXS jrct
252: WHERE trx.customer_trx_id = rctl.customer_trx_id
253: AND jrct.customer_trx_id = trx.customer_trx_id
254: AND rctl.line_type = 'LINE'
340: regime_id ,
341: regime_code
342: FROM
343: JAI_AR_TRX_TAX_LINES jcttl,
344: JAI_AR_TRX_LINES jctl,
345: JAI_CMN_TAXES_ALL jtc ,
346: jai_regime_tax_types_v jrttv
347: WHERE
348: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
372: WHERE rcta.CUSTOMER_TRX_ID = pn_customer_trx_id;
373:
374: CURSOR get_excise_inv_no_cur(pn_customer_trx_id NUMBER) IS
375: SELECT l.excise_invoice_no
376: FROM JAI_AR_TRX_LINES L
377: WHERE l.customer_trx_id = pn_customer_trx_id;
378:
379: CURSOR get_vat_inv_no_cur(pn_customer_trx_id NUMBER) IS
380: SELECT h.vat_invoice_no
2064: --Start Addition by anujsax for Bug#5636544
2065: CURSOR cur_excise_invoice_number(cp_customer_trx_id NUMBER)
2066: IS
2067: SELECT excise_invoice_no
2068: FROM JAI_AR_TRX_LINES
2069: WHERE customer_trx_id = cp_customer_trx_id
2070: AND excise_invoice_no is NOT NULL;
2071:
2072: r_excise_invoice_number cur_excise_invoice_number%ROWTYPE;
4684: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
4685: AND a.link_to_cust_trx_line_id IN (SELECT
4686: customer_trx_line_id
4687: FROM
4688: jai_ar_trx_lines
4689: WHERE customer_trx_id = pn_customer_trx_id)
4690: GROUP BY
4691: a.tax_id
4692: , b.tax_type
4892: select 1
4893: from dual
4894: where exists
4895: ( select customer_trx_line_id
4896: from jai_ar_trx_lines
4897: where customer_trx_id = pn_customer_trx_id
4898: AND NVL(interface_flag,'#') = 'Y'
4899: AND NVL(interface_event,'#')= JAI_OPEN_API_PKG.GV_TAXABLE_EVENT_EXTERNAL
4900: );