APPS.JAI_AP_TDS_POP_RPST_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1063: , JAI_RGM_ORG_REGNS_V jror

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
1067: and jattt.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id

Line 1441: ,JAI_RGM_ORG_REGNS_V jror

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
1442: WHERE aia.invoice_id = jatit.invoice_id
1443: AND jatit.threshold_grp_id IS NOT NULL
1444: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1445: AND aia.cancelled_date IS NULL

Line 1573: ,JAI_RGM_ORG_REGNS_V jror

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
1574: WHERE aia.invoice_id = jatit.invoice_id
1575: AND jatit.threshold_grp_id IS NOT NULL
1576: AND jatit.threshold_grp_id = r_thhold_grp_rec.threshold_grp_id
1577: AND aia.cancelled_date IS NULL

Line 1798: JAI_RGM_ORG_REGNS_V jror

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
1799: WHERE aia.invoice_id = jatit.invoice_id
1800: AND jatit.threshold_grp_id IS NOT NULL
1801: AND aia.cancelled_date IS NULL
1802: AND nvl(jatit.actual_tax_id, jatit.default_tax_id) = jitc.tax_id

Line 1934: , JAI_RGM_ORG_REGNS_V jror

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
1937: and povs.vendor_site_id = jte.vendor_site_id
1938: and base_invoices.cancelled_Date is null

Line 1990: ,JAI_RGM_ORG_REGNS_V jror

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
1992: and jte.vendor_site_id = base_invoices.vendor_site_id
1993: and jte.tds_vendor_classification in ('Transporter','Software')
1994: and aida.global_attribute1 is NULL