[Home] [Help]
1878: AND ((
1879: exists (SELECT NULL
1880: FROM AP_INVOICES inv,
1881: AP_Invoice_distributions DIST1,
1882: PO_VENDORS vend
1883: WHERE inv.invoice_id = DIST1.invoice_id
1884: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
1885: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
1886: AND DIST1.historical_flag = 'Y' -- process historical dist as invoices in Cash Based Acctng
1902: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
1903: )))
1904: OR
1905: (EXISTS ( SELECT NULL
1906: FROM PO_VENDORS vend1,
1907: ap_invoices inv1,
1908: ap_invoice_distributions dist2
1909: WHERE inv1.invoice_id = dist2.invoice_id
1910: AND inv1.invoice_id = dist.invoice_id
1955: AND ((
1956: exists (SELECT NULL
1957: FROM AP_INVOICES inv,
1958: ap_self_assessed_tax_dist DIST1,
1959: PO_VENDORS vend
1960: WHERE inv.invoice_id = DIST1.invoice_id
1961: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
1962: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
1963: --AND DIST1.historical_flag = 'Y' -- process historical dist as invoices in Cash Based Acctng
1979: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
1980: )))
1981: OR
1982: (EXISTS ( SELECT NULL
1983: FROM PO_VENDORS vend1,
1984: ap_invoices inv1,
1985: ap_self_assessed_tax_dist dist2
1986: WHERE inv1.invoice_id = dist2.invoice_id
1987: AND inv1.invoice_id = dist.invoice_id
2039: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2040: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2041: AND exists (SELECT NULL
2042: FROM AP_INVOICES inv,
2043: PO_VENDORS vend
2044: WHERE inv.invoice_id = DIST.invoice_id
2045: AND inv.vendor_id = vend.vendor_id
2046: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2047: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2092: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2093: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2094: AND exists (SELECT NULL
2095: FROM AP_INVOICES inv,
2096: PO_VENDORS vend
2097: WHERE inv.invoice_id = DIST.invoice_id
2098: AND inv.vendor_id = vend.vendor_id
2099: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2100: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2143: AND DIST.project_id > 0
2144: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2145: AND exists (SELECT NULL
2146: FROM AP_INVOICES inv,
2147: PO_VENDORS vend
2148: WHERE inv.invoice_id = DIST.invoice_id
2149: AND inv.vendor_id = vend.vendor_id
2150: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2151: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2188: AND DIST.project_id > 0
2189: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2190: AND exists (SELECT NULL
2191: FROM AP_INVOICES inv,
2192: PO_VENDORS vend
2193: WHERE inv.invoice_id = DIST.invoice_id
2194: AND inv.vendor_id = vend.vendor_id
2195: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2196: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2240: AND (
2241: (exists (SELECT NULL
2242: FROM AP_INVOICES inv,
2243: AP_Invoice_distributions DIST1,
2244: PO_VENDORS vend
2245: WHERE inv.invoice_id = DIST1.invoice_id
2246: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
2247: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
2248: AND DIST1.historical_flag = 'Y' --process historical dist as invoices in Cash Based Acctng
2264: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2265: )))
2266: OR
2267: (EXISTS ( SELECT NULL
2268: FROM PO_VENDORS vend1,
2269: ap_invoices inv1, ap_invoice_distributions dist2
2270: WHERE inv1.invoice_id = dist2.invoice_id
2271: AND inv1.invoice_id = dist.invoice_id
2272: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )
2315: AND (
2316: (exists (SELECT NULL
2317: FROM AP_INVOICES inv,
2318: AP_self_assessed_tax_dist DIST1,
2319: PO_VENDORS vend
2320: WHERE inv.invoice_id = DIST1.invoice_id
2321: AND DIST1.invoice_distribution_id = DIST.invoice_distribution_id
2322: AND INV.payment_status_flag = 'Y' -- Flag indicated FULLY paid inv
2323: --AND DIST1.historical_flag = 'Y' --process historical dist as invoices in Cash Based Acctng
2339: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2340: )))
2341: OR
2342: (EXISTS ( SELECT NULL
2343: FROM PO_VENDORS vend1,
2344: ap_invoices inv1, ap_invoice_distributions dist2
2345: WHERE inv1.invoice_id = dist2.invoice_id
2346: AND inv1.invoice_id = dist.invoice_id
2347: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )
2395: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2396: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2397: AND exists (SELECT NULL
2398: FROM AP_INVOICES_ALL inv,
2399: PO_VENDORS vend
2400: WHERE inv.invoice_id = DIST.invoice_id
2401: AND inv.vendor_id = vend.vendor_id
2402: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2403: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2447: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2448: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2449: AND exists (SELECT NULL
2450: FROM AP_INVOICES_ALL inv,
2451: PO_VENDORS vend
2452: WHERE inv.invoice_id = DIST.invoice_id
2453: AND inv.vendor_id = vend.vendor_id
2454: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2455: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2498: AND DIST.project_id > 0
2499: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2500: AND exists (SELECT invoice_id
2501: FROM AP_INVOICES_ALL inv,
2502: PO_VENDORS vend
2503: WHERE inv.invoice_id = DIST.invoice_id
2504: AND inv.vendor_id = vend.vendor_id
2505: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2506: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2540: AND DIST.project_id > 0
2541: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2542: AND exists (SELECT invoice_id
2543: FROM AP_INVOICES_ALL inv,
2544: PO_VENDORS vend
2545: WHERE inv.invoice_id = DIST.invoice_id
2546: AND inv.vendor_id = vend.vendor_id
2547: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2548: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
10628: WHERE hist.payment_history_id = dist.payment_history_id
10629: AND hist.posted_flag = 'Y')
10630: AND exists (SELECT inv.invoice_id
10631: FROM AP_INVOICES inv,
10632: PO_VENDORS vend,
10633: AP_Invoice_Distributions_all aid,
10634: ap_invoice_payments_all aip
10635: WHERE inv.invoice_id = aid.invoice_id
10636: AND inv.vendor_id = vend.vendor_id
10668: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10669: AND dist.amount <>0
10670: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10671: FROM AP_INVOICES_ALL inv,
10672: PO_VENDORS vend,
10673: PO_Distributions_all PO,
10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10676: WHERE aid.invoice_id = inv.invoice_id
10718: WHERE hist.payment_history_id = dist.payment_history_id
10719: AND hist.posted_flag = 'Y')
10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,
10722: PO_VENDORS vend,
10723: AP_Invoice_Distributions_all aid,
10724: ap_invoice_payments_all aip
10725: WHERE inv.vendor_id = vend.vendor_id
10726: AND aid.invoice_id = inv.invoice_id
10759: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10760: AND dist.amount <>0
10761: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10762: FROM AP_INVOICES_ALL inv,
10763: PO_VENDORS vend,
10764: PO_Distributions_all PO,
10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10767: WHERE aid.invoice_id = inv.invoice_id