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.MSC_GET_NAME dependencies on MSC_VISITS

Line 6311: from msc_visits

6307: FUNCTION visit_name(arg_visit_id IN NUMBER) return varchar2
6308: is
6309: cursor c1 is
6310: select visit_name
6311: from msc_visits
6312: where visit_id = arg_visit_id;
6313: l_temp varchar2(250);
6314: begin
6315: if arg_visit_id is null then

Line 6328: from msc_visits

6324:
6325: FUNCTION visit_name(arg_inst_id number, arg_visit_id IN NUMBER) return varchar2 is
6326: cursor c1 is
6327: select visit_name
6328: from msc_visits
6329: where visit_id = arg_visit_id
6330: and sr_instance_id = arg_inst_id;
6331: l_temp varchar2(250);
6332: begin

Line 6348: msc_visits mv

6344: is
6345: cursor c1 is
6346: select mv.visit_id, mv.visit_name
6347: from msc_supplies ms,
6348: msc_visits mv
6349: where ms.plan_id = arg_plan_id
6350: and ms.sr_instance_id = arg_inst_id
6351: and ms.transaction_id = arg_transaction_id
6352: and ms.sr_instance_id = mv.sr_instance_id