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 1027: FROM pa_draft_revenue_items dri,

1023: /* END fix bug 2249216 */
1024: AND pf.project_id = l_project_id
1025: AND NOT EXISTS
1026: ( SELECT null
1027: FROM pa_draft_revenue_items dri,
1028: pa_draft_revenues dr
1029: WHERE dri.project_id = dr.project_id
1030: AND dri.draft_revenue_num = dr.draft_revenue_num
1031: AND ( nvl(pf.task_id,0) = 0

Line 1046: FROM pa_draft_revenue_items dri,

1042: sum(dri.amount) dri_amount, dri.revproc_currency_code,
1043: sum(dri.projfunc_revenue_amount) dri_projfunc_amount,dri.projfunc_currency_code,
1044: sum(dri.project_revenue_amount) dri_project_amount,dri.project_currency_code,
1045: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
1046: FROM pa_draft_revenue_items dri,
1047: pa_draft_revenues dr,
1048: pa_summary_project_fundings pf,
1049: pa_projects p /* Added pa_projects for bug 3647592 */
1050: WHERE dri.project_id = dr.project_id