APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 244: Fix:Modified the cursor get_match_item_cur as the po_distribution_id would be null in ap_invoice_lines_all for a PO line having multiple distributions.

240: 37. 06-JAN-2012 Qiong for bug 13439861 service tax repository can't be updated normally
241:
242: 38. 31-Aug-2012 amandali for bug 14507573
243: Description:Service Tax repository not updated for PO matched invoice having multiple distributions
244: Fix:Modified the cursor get_match_item_cur as the po_distribution_id would be null in ap_invoice_lines_all for a PO line having multiple distributions.
245: Added the join to jai_ap_match_inv_taxes.
246: 39. 25-Feb-2013 amandali for bug 16246654
247: Description:Reverse charge service tax not hitting repository for third party invoices.
248: Fix:Modified the cursor c_tp_inv_details. Added union condition to pick the reverse charge liability distribution

Line 586: FROM ap_invoice_lines_all

582: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
583:
584: CURSOR get_total_amt_cur IS
585: SELECT SUM(amount)
586: FROM ap_invoice_lines_all
587: WHERE invoice_id = pn_invoice_id
588: AND line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS');
589:
590: CURSOR get_total_ar_amt_cur IS

Line 984: FROM ap_invoice_lines_all aila,

980: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,
981: aida.accounting_date, 'AP') = 'Y')
982: UNION ALL
983: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aila.accounting_date
984: FROM ap_invoice_lines_all aila,
985: ap_invoice_payments_all aipa
986: WHERE aila.invoice_id = pn_invoice_id
987: AND aila.line_type_lookup_code = 'PREPAY'
988: AND aila.prepay_invoice_id = aipa.invoice_id

Line 1713: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt

1709: /* Modified the cursor get_match_item_cur for bug 14507573 */
1710: CURSOR get_match_item_cur IS
1711:
1712: SELECT distinct line.match_type,line.line_number
1713: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt
1714: WHERE line.invoice_id = p_invoice_id
1715: and jamt.invoice_id=line.invoice_id
1716: and jamt.po_distribution_id=p_po_distribution_id
1717: and line.line_number=jamt.parent_invoice_line_number

Line 1733: FROM po_line_locations_all po,ap_invoice_lines_all ap

1729: AND parent_invoice_line_number IS NULL;
1730:
1731: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
1732: SELECT po.ship_to_organization_id, po.ship_to_location_id
1733: FROM po_line_locations_all po,ap_invoice_lines_all ap
1734: WHERE po.line_location_id = ap.po_line_location_id
1735: AND ap.invoice_id = p_invoice_id
1736: AND ap.line_number = pn_line_number;
1737:

Line 1740: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

1736: AND ap.line_number = pn_line_number;
1737:
1738: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
1739: SELECT rcv.organization_id, rcv.location_id
1740: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
1741: WHERE ap.rcv_transaction_id = rcv.transaction_id
1742: AND ap.invoice_id = p_invoice_id
1743: AND ap.line_number = pn_line_number;
1744:

Line 1886: , ap_invoice_lines_all line

1882: OR EXISTS
1883: (
1884: SELECT 1
1885: FROM po_line_locations_all po
1886: , ap_invoice_lines_all line
1887: WHERE ai.invoice_id = line.invoice_id
1888: AND line.po_line_location_id = po.line_location_id
1889: AND (line.match_type = 'ITEM_TO_RECEIPT'
1890: OR line.match_type = 'ITEM_TO_PO')

Line 2001: FROM AP_INVOICE_LINES_ALL ap_line,

1997: UNION
1998: SELECT 1 chk, match_tax.tax_id, tax.tax_rate, abs(ap_dist.amount), match_tax.parent_invoice_distribution_id,tax.tax_type,
1999: ap_line.line_number invoice_line_number,
2000: 100 recoverable_ptg, match_tax.base_amount
2001: FROM AP_INVOICE_LINES_ALL ap_line,
2002: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist, JAI_AP_MATCH_INV_TAXES match_tax,
2003: JAI_CMN_TAXES_ALL tax, JAI_RGM_REGISTRATIONS rgm
2004: WHERE ap_dist.invoice_id = cp_invoice_id
2005: AND ap_dist.invoice_distribution_id = cp_inv_distribution_id

Line 2049: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,

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

Line 2114: AP_INVOICE_LINES_ALL ap_line,AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,JAI_CMN_DOCUMENT_TAXES a, JAI_RGM_REGISTRATIONS c,

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

Line 4798: FROM ap_invoice_lines_all

4794: );
4795:
4796: CURSOR get_total_amount(pn_invoice_id IN NUMBER) IS
4797: SELECT SUM(amount)
4798: FROM ap_invoice_lines_all
4799: WHERE invoice_id = pn_invoice_id
4800: AND line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS')
4801: GROUP BY invoice_id;
4802:

Line 4847: FROM ap_invoice_lines_all aila,

4843: AND jai_st_reversal_extract_pkg.is_paid_after_reversal(aipa.accounting_date,
4844: aida.accounting_date, 'AP') = 'Y')
4845: UNION ALL
4846: SELECT abs(nvl(aila.amount, 0)) claim_amt, aipa.invoice_payment_id, aipa.accounting_date
4847: FROM ap_invoice_lines_all aila,
4848: ap_invoice_payments_all aipa
4849: WHERE aila.invoice_id = pn_invoice_id
4850: AND aila.line_type_lookup_code = 'PREPAY'
4851: AND aila.prepay_invoice_id = aipa.invoice_id