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.AP_WEB_AME_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 560: from ap_exp_report_dists_all

556: -- and report_line_id = p_item_id;
557: elsif (p_item_class = C_PROJECT) then
558: select nvl(sum(amount),0)
559: into p_amount
560: from ap_exp_report_dists_all
561: where report_header_id = p_report_header_id
562: and project_id = p_item_id;
563: elsif (p_item_class = C_AWARD) then
564: select nvl(sum(amount),0)

Line 566: from ap_exp_report_dists_all

562: and project_id = p_item_id;
563: elsif (p_item_class = C_AWARD) then
564: select nvl(sum(amount),0)
565: into p_amount
566: from ap_exp_report_dists_all
567: where report_header_id = p_report_header_id
568: and award_id = p_item_id;
569: elsif (p_item_class = C_COST_CENTER) then
570: select nvl(sum(amount),0)

Line 572: from ap_exp_report_dists_all

568: and award_id = p_item_id;
569: elsif (p_item_class = C_COST_CENTER) then
570: select nvl(sum(amount),0)
571: into p_amount
572: from ap_exp_report_dists_all
573: where report_header_id = p_report_header_id
574: and cost_center = p_item_id;
575: end if;
576:

Line 884: from ap_exp_report_dists_all xd,

880: -> will have award_id if the gt.item_class is C_AWARD
881: */
882: select sum(xd.amount)
883: into l_approver_amount
884: from ap_exp_report_dists_all xd,
885: oie_ame_notif_gt gt
886: where xd.report_header_id = p_report_header_id
887: and xd.report_line_id = i.report_line_id
888: and ( (xd.cost_center = gt.item_id