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.PA_FAXFACE dependencies on PA_NL_INSTALLED

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

1760: AND pei.task_id = pt.task_id
1761: AND pei.expenditure_type = pet.expenditure_type
1762: AND pt.project_id =p_project_id
1763: /*start of change for bug 6037734*/
1764: AND (pa_nl_installed.is_nl_installed='N'
1765: OR (pa_nl_installed.is_nl_installed='Y'
1766: AND EXISTS(select NULL from pa_expenditure_items_all ei1
1767: where ei1.expenditure_item_id = pei.expenditure_item_id
1768: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null

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

1761: AND pei.expenditure_type = pet.expenditure_type
1762: AND pt.project_id =p_project_id
1763: /*start of change for bug 6037734*/
1764: AND (pa_nl_installed.is_nl_installed='N'
1765: OR (pa_nl_installed.is_nl_installed='Y'
1766: AND EXISTS(select NULL from pa_expenditure_items_all ei1
1767: where ei1.expenditure_item_id = pei.expenditure_item_id
1768: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null
1769: OR ei1.attribute9 is not null OR ei1.attribute10 is not null)

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

1773: and ei2.attribute8 is NULL
1774: and ei2.attribute9 is NULL
1775: )
1776: )
1777: OR (pa_nl_installed.is_nl_installed='Y'
1778: AND EXISTS(select null from pa_expenditure_items_all ei3
1779: where ei3.expenditure_item_id = pei.expenditure_item_id
1780: and ei3.attribute6 is NULL
1781: and ei3.attribute7 is NULL