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 1877: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl

1873:
1874: /* Commented and rewritten for bug 4735682
1875: UPDATE pa_draft_invoice_items dii
1876: SET dii.inv_amount =
1877: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl
1878: WHERE rdl.project_id = dii.project_id
1879: AND rdl.draft_invoice_num = dii.draft_invoice_num
1880: AND rdl.draft_invoice_item_line_num = dii.line_num)
1881: WHERE dii.project_id = p_project_id

Line 1890: FROM pa_cust_rev_dist_lines_all rdl

1886: /* Select query for bug 4735682 brought out to comply with 8i.. bug 4995695 */
1887:
1888: SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) * l_head_inv_exch_rate
1889: INTO l_calc_inv_amount
1890: FROM pa_cust_rev_dist_lines_all rdl
1891: WHERE rdl.project_id = p_project_id
1892: AND rdl.draft_invoice_num = inv_num_cached
1893: AND rdl.draft_invoice_item_line_num = cm_rec.line_num;
1894: