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.JTF_TASK_PARTY_MERGE_PKG dependencies on JTF_OBJECTS_VL

Line 295: --from jtf_objects_vl o,

291: where batch_id = p_batch_id;
292:
293: --Cursor c_name Is
294: --select o.select_name
295: --from jtf_objects_vl o,
296: -- jtf_tasks_b t
297: --where t.task_id = p_from_id
298: --and t.source_object_type_code = o.object_code
299: --and nvl(start_date_active, sysdate) <= sysdate

Line 304: from jtf_objects_vl

300: --and nvl(end_date_active, sysdate) >= sysdate;
301:
302: Cursor c_name Is
303: select select_name
304: from jtf_objects_vl
305: where object_code = 'PARTY'
306: and nvl(start_date_active, sysdate) <= sysdate
307: and nvl(end_date_active, sysdate) >= sysdate;
308:

Line 309: l_name jtf_objects_vl.select_name%TYPE;

305: where object_code = 'PARTY'
306: and nvl(start_date_active, sysdate) <= sysdate
307: and nvl(end_date_active, sysdate) >= sysdate;
308:
309: l_name jtf_objects_vl.select_name%TYPE;
310: l_select_stat varchar2(1000);
311:
312:
313: BEGIN

Line 420: --from jtf_objects_vl o,

416: where batch_id = p_batch_id;
417:
418: --Cursor c_name Is
419: --select o.select_name
420: --from jtf_objects_vl o,
421: -- jtf_task_audits_b a
422: --where a.task_audit_id = p_from_id
423: --and a.new_source_object_type_code = o.object_code
424: --and nvl(start_date_active, sysdate) <= sysdate

Line 429: from jtf_objects_vl

425: --and nvl(end_date_active, sysdate) >= sysdate;
426:
427: Cursor c_name Is
428: select select_name
429: from jtf_objects_vl
430: where object_code = 'PARTY'
431: and nvl(start_date_active, sysdate) <= sysdate
432: and nvl(end_date_active, sysdate) >= sysdate;
433:

Line 434: l_name jtf_objects_vl.select_name%TYPE;

430: where object_code = 'PARTY'
431: and nvl(start_date_active, sysdate) <= sysdate
432: and nvl(end_date_active, sysdate) >= sysdate;
433:
434: l_name jtf_objects_vl.select_name%TYPE;
435: l_select_stat varchar2(1000);
436:
437: BEGIN
438:

Line 542: --from jtf_objects_vl o,

538: where batch_id = p_batch_id;
539:
540: --Cursor c_name Is
541: --select o.select_name
542: --from jtf_objects_vl o,
543: -- jtf_task_audits_b a
544: --where a.task_audit_id = p_from_id
545: --and a.old_source_object_type_code = o.object_code
546: --and nvl(start_date_active, sysdate) <= sysdate

Line 551: from jtf_objects_vl

547: --and nvl(end_date_active, sysdate) >= sysdate;
548:
549: Cursor c_name Is
550: select select_name
551: from jtf_objects_vl
552: where object_code = 'PARTY'
553: and nvl(start_date_active, sysdate) <= sysdate
554: and nvl(end_date_active, sysdate) >= sysdate;
555:

Line 556: l_name jtf_objects_vl.select_name%TYPE;

552: where object_code = 'PARTY'
553: and nvl(start_date_active, sysdate) <= sysdate
554: and nvl(end_date_active, sysdate) >= sysdate;
555:
556: l_name jtf_objects_vl.select_name%TYPE;
557: l_select_stat varchar2(1000);
558:
559: BEGIN
560:

Line 667: --from jtf_objects_vl o,

663: where batch_id = p_batch_id;
664:
665: --Cursor c_name Is
666: --select o.select_name
667: --from jtf_objects_vl o,
668: -- jtf_task_references_b r
669: --where r.task_reference_id = p_from_id
670: --and r.object_type_code = o.object_code
671: --and nvl(start_date_active, sysdate) <= sysdate

Line 676: from jtf_objects_vl

672: --and nvl(end_date_active, sysdate) >= sysdate;
673:
674: Cursor c_name Is
675: select select_name
676: from jtf_objects_vl
677: where object_code = 'PARTY'
678: and nvl(start_date_active, sysdate) <= sysdate
679: and nvl(end_date_active, sysdate) >= sysdate;
680:

Line 681: l_name jtf_objects_vl.select_name%TYPE;

677: where object_code = 'PARTY'
678: and nvl(start_date_active, sysdate) <= sysdate
679: and nvl(end_date_active, sysdate) >= sysdate;
680:
681: l_name jtf_objects_vl.select_name%TYPE;
682: l_select_stat varchar2(1000);
683:
684:
685: BEGIN

Line 791: --from jtf_objects_vl o,

787: where batch_id = p_batch_id;
788:
789: --Cursor c_name Is
790: --select o.select_name
791: --from jtf_objects_vl o,
792: -- jtf_task_references_b r
793: --where r.task_reference_id = p_from_id
794: --and r.object_type_code = o.object_code
795: --and nvl(start_date_active, sysdate) <= sysdate

Line 800: from jtf_objects_vl

796: --and nvl(end_date_active, sysdate) >= sysdate;
797:
798: Cursor c_name Is
799: select select_name
800: from jtf_objects_vl
801: where object_code = 'SITE'
802: and nvl(start_date_active, sysdate) <= sysdate
803: and nvl(end_date_active, sysdate) >= sysdate;
804:

Line 805: l_name jtf_objects_vl.select_name%TYPE;

801: where object_code = 'SITE'
802: and nvl(start_date_active, sysdate) <= sysdate
803: and nvl(end_date_active, sysdate) >= sysdate;
804:
805: l_name jtf_objects_vl.select_name%TYPE;
806: l_select_stat varchar2(1000);
807:
808:
809: BEGIN