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.GMS_AWARDS_DIST_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 873: po_requisition_lines_all rl,

869: rd.last_updated_by last_updated_by,
870: rd.created_by created_by,
871: nvl(rd.last_update_login,0) last_update_login
872: FROM po_req_distributions_all rd,
873: po_requisition_lines_all rl,
874: pa_projects_all pp,
875: gms_project_types gpt
876: WHERE rl.requisition_header_id = p_header_id
877: AND rd.requisition_line_id = rl.requisition_line_id

Line 904: po_requisition_lines_all rl,

900:
901: SELECT adl2.award_set_id
902: bulk collect into l_dummy_tab
903: FROM po_req_distributions_all rd,
904: po_requisition_lines_all rl,
905: gms_award_distributions adl2
906: WHERE rl.requisition_header_id = p_header_id
907: AND rd.requisition_line_id = rl.requisition_line_id
908: AND adl2.distribution_id = rd.distribution_id

Line 938: po_requisition_lines_all rl,

934: --
935: SELECT adl2.award_set_id
936: bulk collect into l_dummy_tab
937: FROM po_req_distributions_all rd,
938: po_requisition_lines_all rl,
939: gms_award_distributions adl2
940: WHERE rl.requisition_header_id = p_header_id
941: AND rd.requisition_line_id = rl.requisition_line_id
942: AND adl2.distribution_id = rd.distribution_id

Line 973: po_requisition_lines_all rl,

969:
970: SELECT rd2.distribution_id
971: bulk collect into l_dummy_tab
972: FROM po_req_distributions_all rd2,
973: po_requisition_lines_all rl,
974: pa_projects_all pp,
975: gms_project_types gpt
976: WHERE rl.requisition_header_id = p_header_id
977: AND rd2.requisition_line_id = rl.requisition_line_id