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_RS_CONC_RES_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1302: FROM jtf_rs_resource_extns_vl rsc

1298: , rsc.source_id
1299: , rsc.object_version_number
1300: -- , rsc.start_date_active
1301: -- , rsc.end_date_active
1302: FROM jtf_rs_resource_extns_vl rsc
1303: WHERE rsc.category = 'EMPLOYEE'
1304: /* AND not exists (select employee_id
1305: from per_employees_current_x emp
1306: where emp.employee_id = rsc.source_id

Line 1687: FROM jtf_rs_resource_extns_vl

1683: source_pager,
1684: resource_name,
1685: end_date_active,
1686: person_party_id
1687: FROM jtf_rs_resource_extns_vl
1688: WHERE resource_id = l_resource_id;
1689:
1690: rr_old_rec rr_old_cur%rowtype;
1691:

Line 1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;

1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values

Line 1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;

1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;

Line 1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;

1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;

Line 1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;

1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

Line 1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;

1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1753: l_row_id varchar2(24) := null;

Line 1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;

1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1753: l_row_id varchar2(24) := null;
1754: /* Moved the initial assignment of below variables to inside begin */

Line 1768: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;

1764: l_pager VARCHAR2(240);
1765: l_mgr_name VARCHAR2(240);
1766: l_job_name VARCHAR2(240);
1767: l_org_name VARCHAR2(240);
1768: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;
1769: -- l_sysdate DATE := SYSDATE;
1770: /* Moved the initial assignment of below variables to inside begin */
1771: l_user_id NUMBER;
1772: l_login NUMBER;

Line 4273: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4269: OBJECT_VERSION_NUMBER,
4270: USER_ID,
4271: SOURCE_NAME,
4272: USER_NAME
4273: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4274: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4275: AND jres.USER_ID is not null
4276: AND NOT EXISTS
4277: ( SELECT 'x'

Line 4294: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4290: OBJECT_VERSION_NUMBER,
4291: USER_ID,
4292: SOURCE_NAME,
4293: USER_NAME
4294: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4295: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4296: AND USER_ID is not null
4297: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4298: AND NOT EXISTS

Line 4318: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4314: OBJECT_VERSION_NUMBER,
4315: USER_ID,
4316: SOURCE_NAME,
4317: USER_NAME
4318: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4319: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4320: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4321: AND jres.USER_ID is null
4322: AND exists (select 'x'

Line 4338: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4334: OBJECT_VERSION_NUMBER,
4335: USER_ID,
4336: SOURCE_NAME,
4337: USER_NAME
4338: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4339: WHERE CATEGORY = 'EMPLOYEE'
4340: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4341: AND jres.USER_ID is null
4342: AND exists (select 'x'

Line 4355: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4351: OBJECT_VERSION_NUMBER,
4352: USER_ID,
4353: SOURCE_NAME,
4354: USER_NAME
4355: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4356: WHERE CATEGORY = 'SUPPLIER_CONTACT'
4357: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4358: AND jres.USER_ID is null
4359: AND exists (select 'x'

Line 4372: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4368: OBJECT_VERSION_NUMBER,
4369: USER_ID,
4370: SOURCE_NAME,
4371: USER_NAME
4372: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4373: WHERE CATEGORY in ('PARTY','PARTNER')
4374: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4375: AND jres.USER_ID is null
4376: AND exists (select 'x'