eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAPIMP_PKG dependencies on PO_VENDORS

Line 1663: PO_VENDORS vend

1659: AND ((
1660: exists (SELECT NULL
1661: FROM AP_INVOICES inv,
1662: AP_Invoice_distributions DIST1,
1663: PO_VENDORS vend
1664: WHERE inv.invoice_id = DIST1.invoice_id
1665: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
1666: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
1667: AND DIST1.historical_flag = 'Y' -- process historical dist as invoices in Cash Based Acctng

Line 1678: FROM PO_VENDORS vend1,

1674: AND inv.source in ('CREDIT CARD','Both Pay')
1675: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1676: OR
1677: (EXISTS ( SELECT NULL
1678: FROM PO_VENDORS vend1,
1679: ap_invoices inv1,
1680: ap_invoice_distributions dist2
1681: WHERE inv1.invoice_id = dist2.invoice_id
1682: AND inv1.invoice_id = dist.invoice_id

Line 1728: PO_VENDORS vend

1724: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
1725: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
1726: AND exists (SELECT NULL
1727: FROM AP_INVOICES inv,
1728: PO_VENDORS vend
1729: WHERE inv.invoice_id = DIST.invoice_id
1730: AND inv.vendor_id = vend.vendor_id
1731: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1732: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)

Line 1771: PO_VENDORS vend

1767: AND DIST.project_id > 0
1768: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1769: AND exists (SELECT NULL
1770: FROM AP_INVOICES inv,
1771: PO_VENDORS vend
1772: WHERE inv.invoice_id = DIST.invoice_id
1773: AND inv.vendor_id = vend.vendor_id
1774: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1775: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)

Line 1813: PO_VENDORS vend

1809: AND (
1810: (exists (SELECT NULL
1811: FROM AP_INVOICES inv,
1812: AP_Invoice_distributions DIST1,
1813: PO_VENDORS vend
1814: WHERE inv.invoice_id = DIST1.invoice_id
1815: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
1816: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
1817: AND DIST1.historical_flag = 'Y' --process historical dist as invoices in Cash Based Acctng

Line 1828: FROM PO_VENDORS vend1,

1824: AND inv.source in ('CREDIT CARD','Both Pay')
1825: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1826: OR
1827: (EXISTS ( SELECT NULL
1828: FROM PO_VENDORS vend1,
1829: ap_invoices inv1, ap_invoice_distributions dist2
1830: WHERE inv1.invoice_id = dist2.invoice_id
1831: AND inv1.invoice_id = dist.invoice_id
1832: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )

Line 1874: PO_VENDORS vend

1870: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
1871: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
1872: AND exists (SELECT NULL
1873: FROM AP_INVOICES_ALL inv,
1874: PO_VENDORS vend
1875: WHERE inv.invoice_id = DIST.invoice_id
1876: AND inv.vendor_id = vend.vendor_id
1877: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1878: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)

Line 1917: PO_VENDORS vend

1913: AND DIST.project_id > 0
1914: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
1915: AND exists (SELECT invoice_id
1916: FROM AP_INVOICES_ALL inv,
1917: PO_VENDORS vend
1918: WHERE inv.invoice_id = DIST.invoice_id
1919: AND inv.vendor_id = vend.vendor_id
1920: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1921: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)

Line 8914: PO_VENDORS vend,

8910: WHERE hist.payment_history_id = dist.payment_history_id
8911: AND hist.posted_flag = 'Y')
8912: AND exists (SELECT inv.invoice_id
8913: FROM AP_INVOICES inv,
8914: PO_VENDORS vend,
8915: AP_Invoice_Distributions_all aid,
8916: ap_invoice_payments_all aip
8917: WHERE inv.invoice_id = aid.invoice_id
8918: AND inv.vendor_id = vend.vendor_id

Line 8954: PO_VENDORS vend,

8950: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
8951: AND dist.amount <>0
8952: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
8953: FROM AP_INVOICES_ALL inv,
8954: PO_VENDORS vend,
8955: PO_Distributions_all PO,
8956: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
8957: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
8958: WHERE aid.invoice_id = inv.invoice_id

Line 9004: PO_VENDORS vend,

9000: WHERE hist.payment_history_id = dist.payment_history_id
9001: AND hist.posted_flag = 'Y')
9002: AND exists (SELECT inv.invoice_id
9003: FROM AP_INVOICES_ALL inv,
9004: PO_VENDORS vend,
9005: AP_Invoice_Distributions_all aid,
9006: ap_invoice_payments_all aip
9007: WHERE inv.vendor_id = vend.vendor_id
9008: AND aid.invoice_id = inv.invoice_id

Line 9045: PO_VENDORS vend,

9041: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
9042: AND dist.amount <>0
9043: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
9044: FROM AP_INVOICES_ALL inv,
9045: PO_VENDORS vend,
9046: PO_Distributions_all PO,
9047: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
9048: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
9049: WHERE aid.invoice_id = inv.invoice_id