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_MCB_INVOICE_PKG dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 1869: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl

1865:
1866: /* Commented and rewritten for bug 4735682
1867: UPDATE pa_draft_invoice_items dii
1868: SET dii.inv_amount =
1869: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl
1870: WHERE rdl.project_id = dii.project_id
1871: AND rdl.draft_invoice_num = dii.draft_invoice_num
1872: AND rdl.draft_invoice_item_line_num = dii.line_num)
1873: WHERE dii.project_id = p_project_id

Line 1882: FROM pa_cust_rev_dist_lines_all rdl

1878: /* Select query for bug 4735682 brought out to comply with 8i.. bug 4995695 */
1879:
1880: SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) * l_head_inv_exch_rate
1881: INTO l_calc_inv_amount
1882: FROM pa_cust_rev_dist_lines_all rdl
1883: WHERE rdl.project_id = p_project_id
1884: AND rdl.draft_invoice_num = inv_num_cached
1885: AND rdl.draft_invoice_item_line_num = cm_rec.line_num;
1886: