[Home] [Help]
168: ,jattt.tds_authority_vendor_site_id
169: --,NVL(REGEXP_SUBSTR(jattt.invoice_to_tds_authority_num, '(WCT|TDS|ESSI)-\w+-\d+$',1,1,'i',1), G_TDS) withhold_tax_type
170: ,jctca.effective_tds_rate
171: FROM jai_ap_tds_thhold_trxs jattt
172: ,ap_invoices_all tds_inv
173: ,jai_cmn_tax_ctgs_all jctca
174: WHERE jattt.invoice_to_tds_authority_id = tds_inv.invoice_id
175: AND jattt.tax_category_id = jctca.tax_category_id(+)
176: AND jattt.invoice_to_tds_authority_id = p_tds_invoice_id
186: ,inv.invoice_date
187: ,inv.gl_date
188: ,inv.org_id
189: ,inv.legal_entity_id
190: FROM ap_invoices_all inv
191: WHERE inv.invoice_id = p_invoice_id
192: ;
193: --Get tax rate of ESSI/WCT tax in given tax category
194: CURSOR c_get_tds_essi_rate(p_tax_category_id NUMBER
231: ,aia.vendor_site_id
232: ,aia.invoice_date
233: ,aia.gl_date
234: ,ABS(aida.amount) apply_amount
235: FROM ap_invoices_all aia
236: ,ap_invoice_distributions_all aida
237: WHERE aia.invoice_id = aida.invoice_id
238: AND aida.invoice_distribution_id = pn_distribution_id
239: ;
831: ,aia.vendor_site_id
832: ,aia.invoice_date
833: ,aia.gl_date
834: ,ABS(aida.amount) apply_amount
835: FROM ap_invoices_all aia
836: ,ap_invoice_distributions_all aida
837: WHERE aia.invoice_id = aida.invoice_id
838: AND aida.invoice_distribution_id = pn_distribution_id
839: ;
856:
857: CURSOR c_gl_date(p_tds_invoice_id IN NUMBER)
858: IS
859: SELECT gl_date
860: FROM ap_invoices_all
861: WHERE invoice_id = p_tds_invoice_id
862: ;
863:
864: v_legalEntityTan VARCHAR2(50);
1056: ,sysdate
1057: ,fnd_global.login_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt
1060: , ap_invoices_all base_invoices
1061: , ap_invoices_all tds_invoices
1062: , ap_invoices_all vendor_invoices
1063: , JAI_RGM_ORG_REGNS_V jror
1064: where jattt.invoice_id = base_invoices.invoice_id
1057: ,fnd_global.login_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt
1060: , ap_invoices_all base_invoices
1061: , ap_invoices_all tds_invoices
1062: , ap_invoices_all vendor_invoices
1063: , JAI_RGM_ORG_REGNS_V jror
1064: where jattt.invoice_id = base_invoices.invoice_id
1065: and jattt.invoice_to_tds_authority_id = tds_invoices.invoice_id
1058: ,fnd_global.user_id
1059: from jai_ap_tds_thhold_trxs jattt
1060: , ap_invoices_all base_invoices
1061: , ap_invoices_all tds_invoices
1062: , ap_invoices_all vendor_invoices
1063: , JAI_RGM_ORG_REGNS_V jror
1064: where jattt.invoice_id = base_invoices.invoice_id
1065: and jattt.invoice_to_tds_authority_id = tds_invoices.invoice_id
1066: and jattt.invoice_to_vendor_id = vendor_invoices.invoice_id
1432: ,fnd_global.user_id
1433: ,sysdate
1434: ,fnd_global.login_id
1435: ,fnd_global.user_id
1436: FROM ap_invoices_all aia
1437: ,ap_invoice_distributions_all aida
1438: ,jai_ap_tds_inv_taxes jatit
1439: ,JAI_AP_TDS_VENDOR_HDRS jte
1440: ,JAI_CMN_TAXES_ALL jitc
1564: ,fnd_global.user_id
1565: ,sysdate
1566: ,fnd_global.login_id
1567: ,fnd_global.user_id
1568: FROM ap_invoices_all aia
1569: ,ap_invoice_distributions_all aida
1570: ,jai_ap_tds_inv_taxes jatit
1571: ,JAI_AP_TDS_VENDOR_HDRS jte
1572: ,JAI_CMN_TAXES_ALL jitc
1789: ,max(nvl(jatit.actual_tax_id, jatit.default_tax_id)) TAX_ID
1790: ,max(aia.invoice_amount) BASE_TAX_AMOUNT
1791: ,G_Y REQUIRED_FOR_ETDS
1792: ,G_Y MIGRATED
1793: FROM ap_invoices_all aia,
1794: ap_invoice_distributions_all aida,
1795: jai_ap_tds_inv_taxes jatit,
1796: JAI_AP_TDS_VENDOR_HDRS jte,
1797: JAI_CMN_TAXES_ALL jitc,
1926: ,base_invoices.invoice_amount BASE_TAX_AMOUNT
1927: ,G_Y REQUIRED_FOR_ETDS
1928: ,G_Y MIGRATED
1929: from jai_cmn_taxes_all a
1930: , ap_invoices_all base_invoices
1931: , po_vendor_sites_all povs
1932: , ap_invoice_distributions_all aida
1933: , jai_ap_tds_vendor_hdrs jte
1934: , JAI_RGM_ORG_REGNS_V jror
1982: ,-99
1983: ,base_invoices.invoice_amount
1984: ,G_Y
1985: ,G_Y
1986: from ap_invoices_all base_invoices
1987: ,ap_invoice_distributions_all aida
1988: ,jai_ap_tds_vendor_hdrs jte
1989: ,po_vendor_sites_all povs
1990: ,JAI_RGM_ORG_REGNS_V jror