[Home] [Help]
63:
64: cursor c_get_tax_details (p_tax_id number) is
65: select tax_type, tax_rate, stform_type
66: , mod_cr_percentage -- 5763527
67: from JAI_CMN_TAXES_ALL
68: where tax_id = p_tax_id;
69:
70: v_mod_cr_pctg JAI_CMN_TAXES_ALL.mod_cr_percentage%type ;-- 5763527
71: lv_recoverable_flag JAI_AP_MATCH_INV_TAXES.recoverable_flag%type ;-- 5763527
66: , mod_cr_percentage -- 5763527
67: from JAI_CMN_TAXES_ALL
68: where tax_id = p_tax_id;
69:
70: v_mod_cr_pctg JAI_CMN_TAXES_ALL.mod_cr_percentage%type ;-- 5763527
71: lv_recoverable_flag JAI_AP_MATCH_INV_TAXES.recoverable_flag%type ;-- 5763527
72:
73:
74: cursor c_get_ven_info(p_invoice_id number) is
140: and nvl(match_status_flag, 'N') <> 'A');
141:
142:
143:
144: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
145: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
141:
142:
143:
144: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
145: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
142:
143:
144: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
145: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
143:
144: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
145: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
151: v_org_id ap_invoices_all.org_id%type;
304: and jmit.line_location_id = p_line_location_id
305: and nvl(jmit.po_distribution_id,1) = nvl(p_po_distribution_id,nvl(jmit.po_distribution_id,1)) /*Added by nprashar for bug # 12561167 */
306: and jmit.parent_invoice_line_number = p_parent_line_number
307: and jmit.tax_id = (select jpt.tax_id from JAI_PO_TAXES jpt
308: , jai_cmn_taxes_all jcta -- for bug 14183827 by anupgupt
309: Where jpt.line_location_id = p_line_location_id
310: and jpt.tax_line_no = p_precedence
311: and jpt.tax_id = jcta.tax_id -- for bug 14183827 by anupgupt
312: and nvl(jcta.inclusive_tax_flag,'N') <> 'Y' -- for bug 14183827 by anupgupt
402: is not present in jai_po_taxes*/
403: Begin /*Added Begin End section for bug # 12561167 */
404: select jamit.tax_amount into v_tax_base_amt_loop
405: from JAI_AP_MATCH_INV_TAXES jamit
406: , jai_cmn_taxes_all jcta -- for bug 14183827 by anupgupt
407: Where jamit.invoice_id = p_invoice_id
408: and jamit.po_header_id = v_po_header_id
409: and jamit.po_line_id = v_po_line_id
410: and jamit.line_location_id = v_po_line_location_id
579: )
580: and exists (select '1'
581: from JAI_AP_MATCH_INV_TAXES
582: where invoice_id = a.invoice_id
583: and tax_id in (select tax_id from JAI_CMN_TAXES_ALL where stform_type is not null)
584: ) -- to ensure that loc taxes exists for the invoice and are of st forms type.
585:
586: order by invoice_date asc
587: )
733: from JAI_AP_MATCH_INV_TAXES
734: where invoice_id = b.invoice_id
735: --and distribution_line_number = b.distribution_line_number
736: and invoice_line_number = b.line_number
737: and tax_id in (select tax_id from JAI_CMN_TAXES_ALL where stform_type is not null)
738: ) -- to ensure that the line is an india local tax line for a st form type tax
739: -- Added by Jia for Bug#9535954, Begin
740: ------------------------------------------------------------------------------------------------------
741: Union All
759: where invoice_id = b.invoice_id
760: and invoice_line_number = b.line_number
761: and tax_id in
762: (select tax_id
763: from JAI_CMN_TAXES_ALL
764: where stform_type is not null
765: and inclusive_tax_flag = 'Y'))
766: ------------------------------------------------------------------------------------------------------
767: -- Added by Jia for Bug#9535954, End
1359: AND trunc(jspl.creation_date) between p_from_date and p_to_date
1360: AND EXISTS
1361: (SELECT 1
1362: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1363: JAI_CMN_TAXES_ALL jtc
1364: WHERE jtc.tax_id = jsptl.tax_id
1365: AND jsptl.delivery_detail_id = jspl.delivery_detail_id
1366: AND jtc.tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1367: AND jtc.stform_type IS NOT NULL
1401: jsptl.TAX_AMOUNT ,
1402: jsptl.base_tax_amount ,
1403: jtc.stform_type
1404: from JAI_OM_WSH_LINE_TAXES jsptl ,
1405: JAI_CMN_TAXES_ALL jtc
1406: where delivery_detail_id in
1407: (
1408: select delivery_detail_id
1409: from JAI_OM_WSH_LINES_ALL
1822: WHERE customer_trx_id = trx.customer_trx_id AND
1823: EXISTS
1824: (SELECT 1
1825: FROM JAI_AR_TRX_TAX_LINES tax_lines ,
1826: JAI_CMN_TAXES_ALL jtc
1827: WHERE link_to_cust_trx_line_id = trx_lines.customer_trx_line_id AND
1828: tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1829: AND jtc.tax_id = tax_lines.tax_id AND
1830: jtc.stform_type IS NOT NULL
1856: jtxn.INVOICE_CLASS ,
1857: jtxn.base_tax_amount ,
1858: jtc.stform_type
1859: from JAI_AR_TRX_TAX_LINES jtxn ,
1860: JAI_CMN_TAXES_ALL jtc
1861: where link_to_cust_Trx_line_id in
1862: (
1863: select customer_Trx_line_id
1864: from JAI_AR_TRX_LINES