APPS.OKS_ENTITLEMENTS_WEB dependencies on JTF_RS_RESOURCE_EXTNS

Line 1836: JTF_RS_RESOURCE_EXTNS RSC ,

1832: IS
1833: SELECT
1834: C.LAST_NAME name
1835: FROM
1836: JTF_RS_RESOURCE_EXTNS RSC ,
1837: PO_VENDOR_SITES_ALL S ,
1838: PO_VENDOR_CONTACTS C
1839: WHERE
1840: RSC.CATEGORY = 'SUPPLIER_CONTACT'

Line 1849: FROM JTF_RS_RESOURCE_EXTNS RSC ,

1845: AND '#' = p_object1_id2
1846: UNION ALL
1847: SELECT
1848: EMP.FULL_NAME name
1849: FROM JTF_RS_RESOURCE_EXTNS RSC ,
1850: FND_USER U ,
1851: OKX_PER_ALL_PEOPLE_V EMP
1852: WHERE
1853: RSC.CATEGORY = 'EMPLOYEE'

Line 1862: JTF_RS_RESOURCE_EXTNS RSC ,

1858: UNION ALL
1859: SELECT
1860: PARTY.PARTY_NAME name
1861: FROM
1862: JTF_RS_RESOURCE_EXTNS RSC ,
1863: FND_USER U ,
1864: HZ_PARTIES PARTY
1865: WHERE
1866: RSC.CATEGORY IN ( 'PARTY', 'PARTNER')

Line 1875: JTF_RS_RESOURCE_EXTNS RSC

1871: UNION ALL
1872: SELECT /*+ ordered */
1873: TL.RESOURCE_NAME name
1874: FROM
1875: JTF_RS_RESOURCE_EXTNS RSC
1876: ,JTF_RS_SALESREPS SRP
1877: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182
1878: ,FND_USER U
1879:

Line 1877: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182

1873: TL.RESOURCE_NAME name
1874: FROM
1875: JTF_RS_RESOURCE_EXTNS RSC
1876: ,JTF_RS_SALESREPS SRP
1877: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182
1878: ,FND_USER U
1879:
1880: WHERE
1881: RSC.CATEGORY = 'OTHER'

Line 1898: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182

1894: CURSOR party_contact_name_cur3(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2)
1895: IS
1896: SELECT TL.RESOURCE_NAME
1897: FROM JTF_RS_SALESREPS S
1898: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182
1899: WHERE S.salesrep_id = TO_NUMBER(p_object1_id1)
1900: AND S.org_id = p_org_id
1901: AND S.RESOURCE_ID = TL.RESOURCE_ID
1902: AND TL.LANGUAGE = USERENV('LANG');

Line 3232: JTF_RS_RESOURCE_EXTNS RSC ,

3228: C.LAST_NAME name2
3229: from
3230: okc_contacts_v con,
3231: okc_k_party_roles_b pty ,
3232: JTF_RS_RESOURCE_EXTNS RSC ,
3233: PO_VENDOR_SITES_ALL S ,
3234: PO_VENDOR_CONTACTS C
3235: where
3236: pty.cle_id = to_number(p_bus_proc_ID_arg)

Line 3255: JTF_RS_RESOURCE_EXTNS RSC ,

3251: EMP.FULL_NAME name2
3252: from
3253: okc_contacts_v con,
3254: okc_k_party_roles_b pty ,
3255: JTF_RS_RESOURCE_EXTNS RSC ,
3256: FND_USER U ,
3257: OKX_PER_ALL_PEOPLE_V EMP
3258: where
3259: pty.cle_id = to_number(p_bus_proc_ID_arg)

Line 3277: JTF_RS_RESOURCE_EXTNS RSC ,

3273: PARTY.PARTY_NAME name2
3274: from
3275: okc_contacts_v con,
3276: okc_k_party_roles_b pty ,
3277: JTF_RS_RESOURCE_EXTNS RSC ,
3278: FND_USER U ,
3279: HZ_PARTIES PARTY
3280: where
3281: pty.cle_id = to_number(p_bus_proc_ID_arg)

Line 3299: JTF_RS_RESOURCE_EXTNS RSC ,

3295: SRP.NAME name2
3296: from
3297: okc_contacts_v con,
3298: okc_k_party_roles_b pty ,
3299: JTF_RS_RESOURCE_EXTNS RSC ,
3300: FND_USER U ,
3301: JTF_RS_SALESREPS SRP
3302: where
3303: pty.cle_id = to_number(p_bus_proc_ID_arg)

Line 3330: JTF_RS_RESOURCE_EXTNS RSC,

3326: ,'PARTY', hz_party.party_name
3327: ) name2
3328:
3329: FROM OKC_K_LINES_B okcline,
3330: JTF_RS_RESOURCE_EXTNS RSC,
3331: OKC_CONTACTS Contacts,
3332: FND_LOOKUPS RoleLookup,
3333: OKC_K_PARTY_ROLES_B PartyRoles,
3334: AP_SUPPLIER_CONTACTS ap_supp_contact,