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_BILLING dependencies on PA_DRAFT_REVENUE_ITEMS

Line 964: FROM pa_draft_revenue_items dri,

960: /* END fix bug 2249216 */
961: AND pf.project_id = l_project_id
962: AND NOT EXISTS
963: ( SELECT null
964: FROM pa_draft_revenue_items dri,
965: pa_draft_revenues dr
966: WHERE dri.project_id = dr.project_id
967: AND dri.draft_revenue_num = dr.draft_revenue_num
968: AND ( nvl(pf.task_id,0) = 0

Line 983: FROM pa_draft_revenue_items dri,

979: sum(dri.amount) dri_amount, dri.revproc_currency_code,
980: sum(dri.projfunc_revenue_amount) dri_projfunc_amount,dri.projfunc_currency_code,
981: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
982: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
983: FROM pa_draft_revenue_items dri,
984: pa_draft_revenues dr,
985: pa_summary_project_fundings pf,
986: pa_projects p /* Added pa_projects for bug 3647592 */
987: WHERE dri.project_id = dr.project_id