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

Line 91: FROM pa_draft_revenue_items dri

87: /* Change this column from amount to projfunc_revenue_amount for MCB2 */
88:
89: SELECT sum(nvl(dri.projfunc_revenue_amount,0))
90: INTO accrued_rev
91: FROM pa_draft_revenue_items dri
92: WHERE dri.project_id = X_project_id
93: AND nvl(dri.task_id,0) =
94: decode(X_task_id, NULL, nvl(dri.task_id,0), X_task_id);
95:

Line 1531: FROM pa_draft_revenue_items dri,

1527: --
1528: /* Changed this column from amount to projfunc_revenue_amount for MCB2 */
1529: SELECT sum(nvl(dri.projfunc_revenue_amount,0))
1530: INTO l_revenue_ptd
1531: FROM pa_draft_revenue_items dri,
1532: pa_draft_revenues_all dr,
1533: pa_periods pp /* Bug# 2197991 */
1534: WHERE dri.project_id = x_project_id
1535: AND nvl(dri.task_id,0) =