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.OKS_ENTITLEMENTS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 6958: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

6954: -- ,decode(RSC.Resource_Type,'EMPLOYEE','RS_EMPLOYEE',RSC.Resource_Type) Resource_Type
6955: ,cimbp.object1_id1
6956: ,con.primary_yn
6957: ,con.resource_class
6958: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6959: ,OKC_Contacts CON
6960: ,OKC_K_Party_Roles_B ROL
6961: ,OKC_K_Lines_B BPL
6962: ,OKC_K_Lines_B SBL

Line 7036: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

7032: ,ksl.Standard_Cov_YN Standard_Cov_YN
7033: ,bpl.id bpl_id
7034: ,ksl.dnz_chr_id ksl_dnz_chr_id
7035:
7036: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
7037: ,OKC_Contacts CON
7038: ,OKC_K_Party_Roles_B ROL
7039: ,OKC_K_Lines_B BPL
7040: ,okc_k_items cimbp

Line 7362: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS

7358: ,NULL CONTACT_NAME
7359: ,PR.ID CONTACT_ROLE_ID
7360: ,CO.CRO_CODE CONTACT_ROLE_CODE
7361: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7362: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7363: ,OKC_CONTACTS CO
7364: ,OKC_K_PARTY_ROLES_B PR
7365: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7366: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7410: FROM JTF_RS_RESOURCE_EXTNS CS

7406: ,CS.CATEGORY RSC_CATEGORY
7407: ,TL.RESOURCE_NAME CONTACT_NAME
7408: ,PR.ID CONTACT_ROLE_ID
7409: ,CO.CRO_CODE CONTACT_ROLE_CODE
7410: FROM JTF_RS_RESOURCE_EXTNS CS
7411: ,JTF_RS_SALESREPS S
7412: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7413: ,OKC_CONTACTS CO
7414: ,OKC_K_PARTY_ROLES_B PR

Line 7412: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair

7408: ,PR.ID CONTACT_ROLE_ID
7409: ,CO.CRO_CODE CONTACT_ROLE_CODE
7410: FROM JTF_RS_RESOURCE_EXTNS CS
7411: ,JTF_RS_SALESREPS S
7412: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7413: ,OKC_CONTACTS CO
7414: ,OKC_K_PARTY_ROLES_B PR
7415: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7416: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7444: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS

7440: ,NULL CONTACT_NAME
7441: ,PR.ID CONTACT_ROLE_ID
7442: ,CO.CRO_CODE CONTACT_ROLE_CODE
7443: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7444: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7445: ,OKC_CONTACTS CO
7446: ,OKC_K_PARTY_ROLES_B PR
7447: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7448: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7495: FROM JTF_RS_RESOURCE_EXTNS CS

7491: ,CS.CATEGORY RSC_CATEGORY
7492: ,TL.RESOURCE_NAME CONTACT_NAME -- Bug Fix #5442182 hmnair
7493: ,PR.ID CONTACT_ROLE_ID
7494: ,CO.CRO_CODE CONTACT_ROLE_CODE
7495: FROM JTF_RS_RESOURCE_EXTNS CS
7496: ,JTF_RS_SALESREPS S
7497: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7498: ,OKC_CONTACTS CO
7499: ,OKC_K_PARTY_ROLES_B PR

Line 7497: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair

7493: ,PR.ID CONTACT_ROLE_ID
7494: ,CO.CRO_CODE CONTACT_ROLE_CODE
7495: FROM JTF_RS_RESOURCE_EXTNS CS
7496: ,JTF_RS_SALESREPS S
7497: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7498: ,OKC_CONTACTS CO
7499: ,OKC_K_PARTY_ROLES_B PR
7500: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7501: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7531: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7527: -- for category 'SUPPLIER_CONTACT'
7528:
7529: CURSOR Lx_Csr_vndr_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7530: SELECT C.LAST_NAME NAME
7531: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7532: PO_VENDOR_SITES_ALL S ,
7533: PO_VENDOR_CONTACTS C
7534: WHERE RSC.RESOURCE_ID = Cx_Resource_Id
7535: and C.VENDOR_CONTACT_ID = RSC.SOURCE_ID

Line 7544: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7540: -- for category 'EMPLOYEE'
7541:
7542: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7543: SELECT PER.FULL_NAME NAME
7544: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7545: FND_USER U ,
7546: PER_ALL_PEOPLE_F PER
7547: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7548: and U.USER_ID = RSC.USER_ID

Line 7557: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7553: -- for category 'PARTNER', 'PARTY'
7554:
7555: CURSOR Lx_Csr_pty_name(Cx_Resource_Id IN number) IS
7556: SELECT PARTY.PARTY_NAME NAME
7557: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7558: FND_USER U ,
7559: HZ_PARTIES PARTY
7560: WHERE RSC.CATEGORY IN ( 'PARTNER', 'PARTY')
7561: AND PARTY.PARTY_ID = RSC.SOURCE_ID

Line 7570: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7566: -- for category 'OTHER'
7567:
7568: CURSOR Lx_Csr_oth_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7569: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7570: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7571: FND_USER U ,
7572: JTF_RS_SALESREPS SRP
7573: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7574: WHERE RSC.CATEGORY = 'OTHER'

Line 7573: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair

7569: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7570: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7571: FND_USER U ,
7572: JTF_RS_SALESREPS SRP
7573: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7574: WHERE RSC.CATEGORY = 'OTHER'
7575: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
7576: AND U.USER_ID = RSC.USER_ID
7577: AND SRP.Org_ID = Cn_Org_Id -- Modified for 12.0 MOAC project (JVARGHES)