APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 236: ,ap_invoice_distributions_all aida

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: ;
240:

Line 272: FROM ap_invoice_distributions_all aida

268:
269: CURSOR c_get_prepay_dist_id( pn_inv_dist_id NUMBER
270: ) IS
271: SELECT aida.prepay_distribution_id
272: FROM ap_invoice_distributions_all aida
273: WHERE aida.invoice_distribution_id = pn_inv_dist_id
274: ;
275:
276: r_c_get_trx_tds_info c_get_trx_tds_info%rowtype;

Line 821: FROM ap_invoice_distributions_all aida

817: --get prepayment distribution id
818: CURSOR c_get_prepay_dist_id( pn_inv_dist_id NUMBER
819: ) IS
820: SELECT aida.prepay_distribution_id
821: FROM ap_invoice_distributions_all aida
822: WHERE aida.invoice_distribution_id = pn_inv_dist_id
823: ;
824: --Derive apply from invoice info
825: CURSOR c_get_apply_fromto_inv (pn_distribution_id NUMBER

Line 836: ,ap_invoice_distributions_all aida

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: ;
840:

Line 1437: ,ap_invoice_distributions_all aida

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
1441: ,JAI_RGM_ORG_REGNS_V jror

Line 1569: ,ap_invoice_distributions_all aida

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
1573: ,JAI_RGM_ORG_REGNS_V jror

Line 1794: ap_invoice_distributions_all aida,

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,
1798: JAI_RGM_ORG_REGNS_V jror

Line 1932: , ap_invoice_distributions_all aida

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
1935: where jte.vendor_id = base_invoices.vendor_id
1936: and povs.vendor_id = jte.vendor_id

Line 1987: ,ap_invoice_distributions_all aida

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
1991: where jte.vendor_id = base_invoices.vendor_id