[Home] [Help]
521: WHERE invoice_id = pn_invoice_id ;
522:
523: CURSOR get_total_rec_amt_cur IS
524: SELECT SUM(tax_amt)
525: FROM jai_cmn_document_taxes jcdt,
526: jai_cmn_taxes_all jcta
527: WHERE jcdt.source_doc_id = pn_invoice_id
528: --Add by Chong for bug#13358557 08-NOV-2011, begin
529: -----------------------------------------------------------------------------------------------
547:
548: CURSOR get_dist_line_cur IS
549: SELECT 'STANDALONE' match_type, aida.invoice_distribution_id, jcdt.tax_amt, jcdt.tax_type
550: FROM ap_invoice_distributions_all aida,
551: jai_cmn_document_taxes jcdt
552: WHERE aida.invoice_id = pn_invoice_id
553: AND aida.line_type_lookup_code = 'MISCELLANEOUS'
554: AND jcdt.source_doc_id = pn_invoice_id
555: AND jcdt.source_doc_parent_line_no = pn_line_number
2024: /*Bug 9854974 - Item Line ID in JAI_RGM_TRX_REFS should refer to the Item Line to which Service Tax is attached
2025: and not the Line Number of the Service Tax*/
2026: a.source_doc_parent_line_no invoice_line_number, /* INVOICE LINES UPTAKE */
2027: nvl(b.mod_cr_percentage,0) recoverable_ptg, d.base_amount
2028: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,
2029: AP_INVOICE_DISTRIBUTIONS_ALL d
2030: WHERE a.source_doc_id = cp_invoice_id
2031: AND d.invoice_distribution_id = cp_inv_distribution_id
2032: AND d.invoice_id = a.source_doc_id
2045: a.source_doc_parent_line_no invoice_line_number, /* INVOICE LINES UPTAKE */
2046: 100 recoverable_ptg,
2047: ap_dist.base_amount
2048: FROM
2049: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,
2050: JAI_CMN_TAXES_ALL b
2051: WHERE ap_dist.invoice_id = cp_invoice_id
2052: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id
2053: AND ap_line.invoice_id = ap_dist.invoice_id
2054: AND ap_dist.invoice_line_number = ap_line.line_number
2055: AND ap_line.line_type_lookup_code = 'MISCELLANEOUS'
2056: AND ap_dist.amount < 0
2057: AND ap_line.application_id = 7000
2058: AND ap_line.PRODUCT_TABLE = 'JAI_CMN_DOCUMENT_TAXES'
2059: AND ap_line.REFERENCE_KEY1 = to_char(a.tax_id)
2060: AND ap_line.REFERENCE_KEY2 = to_char(a.source_doc_parent_line_no)
2061: AND a.source_doc_id = ap_dist.invoice_id
2062: AND a.tax_id = b.tax_id
2089: UNION
2090: SELECT 2 chk, a.tax_id, b.tax_rate, a.tax_amt,null, b.tax_type,
2091: a.source_doc_parent_line_no invoice_line_number,
2092: nvl(b.mod_cr_percentage,0) recoverable_ptg, d.base_amount
2093: FROM JAI_CMN_DOCUMENT_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RGM_REGISTRATIONS c,
2094: AP_INVOICE_DISTRIBUTIONS_ALL d
2095: WHERE a.source_doc_id = cp_invoice_id
2096: AND d.invoice_distribution_id = cp_inv_distribution_id
2097: AND d.invoice_id = a.source_doc_id
2110: a.source_doc_parent_line_no invoice_line_number,
2111: 100 recoverable_ptg,
2112: ap_dist.base_amount
2113: FROM
2114: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,
2115: JAI_CMN_TAXES_ALL b
2116: WHERE ap_dist.invoice_id = cp_invoice_id
2117: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id
2118: AND ap_line.invoice_id = ap_dist.invoice_id
2119: AND ap_dist.invoice_line_number = ap_line.line_number
2120: AND ap_line.line_type_lookup_code = 'MISCELLANEOUS'
2121: AND ap_dist.amount < 0
2122: AND ap_line.application_id = 7000
2123: AND ap_line.PRODUCT_TABLE = 'JAI_CMN_DOCUMENT_TAXES'
2124: AND ap_line.REFERENCE_KEY1 = to_char(a.tax_id)
2125: AND ap_line.REFERENCE_KEY2 = to_char(a.source_doc_parent_line_no)
2126: AND a.source_doc_id = ap_dist.invoice_id
2127: AND a.tax_id = b.tax_id
4637: CURSOR get_total_rec_amt_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
4638: ----------------------------------------------------------------------------------------------
4639: --Modified by Chong for bug#13358557 08-NOV-2011, end
4640: SELECT SUM(tax_amt)
4641: FROM jai_cmn_document_taxes jcdt,
4642: jai_cmn_taxes_all jcta
4643: WHERE jcdt.source_doc_id = pn_invoice_id
4644: --Add by Chong for bug#13358557 08-NOV-2011, begin
4645: ----------------------------------------------------------------------------------------------
4671:
4672: CURSOR get_reversal_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
4673: SELECT jcta.tax_type, jcdt.tax_amt, aida.invoice_distribution_id,
4674: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4675: FROM jai_cmn_document_taxes jcdt
4676: , jai_cmn_taxes_all jcta
4677: , ap_invoice_distributions_all aida
4678: , ap_invoices_all aia
4679: WHERE jcdt.source_doc_id = pn_invoice_id
4725:
4726: CURSOR get_claim_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER, pn_invoice_payment_id IN NUMBER) IS
4727: SELECT jcta.tax_type, jcdt.tax_amt, aida.invoice_distribution_id,
4728: aida.accounting_date, aia.invoice_date, aida.po_distribution_id
4729: FROM jai_cmn_document_taxes jcdt
4730: , jai_cmn_taxes_all jcta
4731: , ap_invoices_all aia
4732: , ap_invoice_distributions_all aida
4733: WHERE jcdt.source_doc_id = pn_invoice_id