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.CSF_MAINTAIN_GRP dependencies on CAC_SR_OBJECT_CAPACITY

Line 706: delete cac_sr_object_capacity

702: END IF;
703:
704:
705:
706: delete cac_sr_object_capacity
707: where object_capacity_id in
708: (select cac.object_capacity_id
709: from
710: cac_sr_object_capacity cac

Line 710: cac_sr_object_capacity cac

706: delete cac_sr_object_capacity
707: where object_capacity_id in
708: (select cac.object_capacity_id
709: from
710: cac_sr_object_capacity cac
711: , JTF_TASKS_B tskt
712: , JTF_OBJECT_PURGE_PARAM_TMP tmp
713: , jtf_Task_assignments jtt
714: , jtf_task_statuses_b jtfts

Line 741: update cac_sr_object_capacity cac set cac.available_hours =

737: );
738:
739:
740:
741: update cac_sr_object_capacity cac set cac.available_hours =
742: ( SELECT (cac.END_DATE_TIME - cac.START_DATE_TIME) -
743: SUM(ta.booking_end_date - ta.booking_start_date) -
744: SUM(NVL(csf_util_pvt.convert_to_minutes(
745: ta.sched_travel_duration

Line 755: cac_sr_object_capacity cac

751: where cac.start_date_time > sysdate and
752: cac.object_capacity_id in
753: (select cac.object_capacity_id
754: from
755: cac_sr_object_capacity cac
756: , JTF_TASKS_B tskt
757: , JTF_OBJECT_PURGE_PARAM_TMP tmp
758: , jtf_Task_assignments jtt
759: , jtf_task_statuses_b jtfts