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 PA_NL_INSTALLED

Line 2015: AND (pa_nl_installed.is_nl_installed = 'N'

2011: AND dist3.invoice_distribution_id = dist.parent_reversal_id --Process Historical data reversals as Invoices in Cash based
2012: AND dist3.pa_addition_flag = 'Y')
2013: )
2014: /* Bug 6353803: Added the following for this bug. */
2015: AND (pa_nl_installed.is_nl_installed = 'N'
2016: OR ( pa_nl_installed.is_nl_installed = 'Y'
2017: AND NOT EXISTS (SELECT 'X'
2018: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2019: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2016: OR ( pa_nl_installed.is_nl_installed = 'Y'

2012: AND dist3.pa_addition_flag = 'Y')
2013: )
2014: /* Bug 6353803: Added the following for this bug. */
2015: AND (pa_nl_installed.is_nl_installed = 'N'
2016: OR ( pa_nl_installed.is_nl_installed = 'Y'
2017: AND NOT EXISTS (SELECT 'X'
2018: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2019: WHERE pod.po_distribution_id = dist.po_distribution_id
2020: AND pod.po_line_id = pol.po_line_id

Line 2088: AND (pa_nl_installed.is_nl_installed = 'N'

2084: AND aid.pa_addition_flag = 'Y'
2085: AND aid.invoice_distribution_id = dist.prepay_distribution_id --Prepayment dist id
2086: AND aid.project_id = G_PROJECT_ID)
2087: /* Bug 6353803: Added the following for this bug. */
2088: AND (pa_nl_installed.is_nl_installed = 'N'
2089: OR ( pa_nl_installed.is_nl_installed = 'Y'
2090: AND NOT EXISTS (SELECT 'X'
2091: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2092: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2089: OR ( pa_nl_installed.is_nl_installed = 'Y'

2085: AND aid.invoice_distribution_id = dist.prepay_distribution_id --Prepayment dist id
2086: AND aid.project_id = G_PROJECT_ID)
2087: /* Bug 6353803: Added the following for this bug. */
2088: AND (pa_nl_installed.is_nl_installed = 'N'
2089: OR ( pa_nl_installed.is_nl_installed = 'Y'
2090: AND NOT EXISTS (SELECT 'X'
2091: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2092: WHERE pod.po_distribution_id = dist.po_distribution_id
2093: AND pod.po_line_id = pol.po_line_id

Line 2162: AND (pa_nl_installed.is_nl_installed = 'N'

2158: dist2.line_type_lookup_code = 'NONREC_TAX'
2159: )
2160: )
2161: /* Bug 6353803: Added the following for this bug. */
2162: AND (pa_nl_installed.is_nl_installed = 'N'
2163: OR ( pa_nl_installed.is_nl_installed = 'Y'
2164: AND NOT EXISTS (SELECT 'X'
2165: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2166: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2163: OR ( pa_nl_installed.is_nl_installed = 'Y'

2159: )
2160: )
2161: /* Bug 6353803: Added the following for this bug. */
2162: AND (pa_nl_installed.is_nl_installed = 'N'
2163: OR ( pa_nl_installed.is_nl_installed = 'Y'
2164: AND NOT EXISTS (SELECT 'X'
2165: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2166: WHERE pod.po_distribution_id = dist.po_distribution_id
2167: AND pod.po_line_id = pol.po_line_id

Line 2254: AND (pa_nl_installed.is_nl_installed = 'N'

2250: AND dist3.invoice_distribution_id = dist.parent_reversal_id --Process Historical data reversals as Invoices in Cash based
2251: AND dist3.pa_addition_flag = 'Y')
2252: )
2253: /* Bug 6353803: Added the following for this bug. */
2254: AND (pa_nl_installed.is_nl_installed = 'N'
2255: OR ( pa_nl_installed.is_nl_installed = 'Y'
2256: AND NOT EXISTS (SELECT 'X'
2257: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2258: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2255: OR ( pa_nl_installed.is_nl_installed = 'Y'

2251: AND dist3.pa_addition_flag = 'Y')
2252: )
2253: /* Bug 6353803: Added the following for this bug. */
2254: AND (pa_nl_installed.is_nl_installed = 'N'
2255: OR ( pa_nl_installed.is_nl_installed = 'Y'
2256: AND NOT EXISTS (SELECT 'X'
2257: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2258: WHERE pod.po_distribution_id = dist.po_distribution_id
2259: AND pod.po_line_id = pol.po_line_id

Line 2326: AND (pa_nl_installed.is_nl_installed = 'N'

2322: AND aid.pa_addition_flag = 'Y'
2323: AND aid.invoice_distribution_id = dist.prepay_distribution_id --Prepayment dist id
2324: AND aid.project_id > 0 )
2325: /* Bug 6353803: Added the following for this bug. */
2326: AND (pa_nl_installed.is_nl_installed = 'N'
2327: OR ( pa_nl_installed.is_nl_installed = 'Y'
2328: AND NOT EXISTS (SELECT 'X'
2329: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2330: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2327: OR ( pa_nl_installed.is_nl_installed = 'Y'

2323: AND aid.invoice_distribution_id = dist.prepay_distribution_id --Prepayment dist id
2324: AND aid.project_id > 0 )
2325: /* Bug 6353803: Added the following for this bug. */
2326: AND (pa_nl_installed.is_nl_installed = 'N'
2327: OR ( pa_nl_installed.is_nl_installed = 'Y'
2328: AND NOT EXISTS (SELECT 'X'
2329: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2330: WHERE pod.po_distribution_id = dist.po_distribution_id
2331: AND pod.po_line_id = pol.po_line_id

Line 2401: AND (pa_nl_installed.is_nl_installed = 'N'

2397: dist2.line_type_lookup_code = 'NONREC_TAX'
2398: )
2399: )
2400: /* Bug 6353803: Added the following for this bug. */
2401: AND (pa_nl_installed.is_nl_installed = 'N'
2402: OR ( pa_nl_installed.is_nl_installed = 'Y'
2403: AND NOT EXISTS (SELECT 'X'
2404: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2405: WHERE pod.po_distribution_id = dist.po_distribution_id

Line 2402: OR ( pa_nl_installed.is_nl_installed = 'Y'

2398: )
2399: )
2400: /* Bug 6353803: Added the following for this bug. */
2401: AND (pa_nl_installed.is_nl_installed = 'N'
2402: OR ( pa_nl_installed.is_nl_installed = 'Y'
2403: AND NOT EXISTS (SELECT 'X'
2404: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2405: WHERE pod.po_distribution_id = dist.po_distribution_id
2406: AND pod.po_line_id = pol.po_line_id

Line 7487: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items

7483: SELECT dist.rowid
7484: FROM ap_invoices inv, ap_invoice_distributions_all dist
7485: WHERE inv.invoice_id = dist.invoice_id
7486: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7487: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7488: AND EXISTS (SELECT 'X'
7489: FROM mtl_system_items si,
7490: po_lines_all pol,
7491: po_distributions_all po_dist1

Line 7617: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items

7613: SELECT dist.rowid
7614: FROM ap_invoices inv, ap_invoice_distributions_all dist
7615: WHERE inv.invoice_id = dist.invoice_id
7616: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7617: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7618: AND EXISTS (SELECT 'X'
7619: FROM mtl_system_items si,
7620: po_lines_all pol,
7621: po_distributions_all po_dist1