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 6570: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

6566: -- ,decode(RSC.Resource_Type,'EMPLOYEE','RS_EMPLOYEE',RSC.Resource_Type) Resource_Type
6567: ,cimbp.object1_id1
6568: ,con.primary_yn
6569: ,con.resource_class
6570: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6571: ,OKC_Contacts CON
6572: ,OKC_K_Party_Roles_B ROL
6573: ,OKC_K_Lines_B BPL
6574: ,OKC_K_Lines_B SBL

Line 6648: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

6644: ,ksl.Standard_Cov_YN Standard_Cov_YN
6645: ,bpl.id bpl_id
6646: ,ksl.dnz_chr_id ksl_dnz_chr_id
6647:
6648: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6649: ,OKC_Contacts CON
6650: ,OKC_K_Party_Roles_B ROL
6651: ,OKC_K_Lines_B BPL
6652: ,okc_k_items cimbp

Line 6974: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS

6970: ,NULL CONTACT_NAME
6971: ,PR.ID CONTACT_ROLE_ID
6972: ,CO.CRO_CODE CONTACT_ROLE_CODE
6973: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
6974: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
6975: ,OKC_CONTACTS CO
6976: ,OKC_K_PARTY_ROLES_B PR
6977: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6978: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7022: FROM JTF_RS_RESOURCE_EXTNS CS

7018: ,CS.CATEGORY RSC_CATEGORY
7019: ,TL.RESOURCE_NAME CONTACT_NAME
7020: ,PR.ID CONTACT_ROLE_ID
7021: ,CO.CRO_CODE CONTACT_ROLE_CODE
7022: FROM JTF_RS_RESOURCE_EXTNS CS
7023: ,JTF_RS_SALESREPS S
7024: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7025: ,OKC_CONTACTS CO
7026: ,OKC_K_PARTY_ROLES_B PR

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

7020: ,PR.ID CONTACT_ROLE_ID
7021: ,CO.CRO_CODE CONTACT_ROLE_CODE
7022: FROM JTF_RS_RESOURCE_EXTNS CS
7023: ,JTF_RS_SALESREPS S
7024: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7025: ,OKC_CONTACTS CO
7026: ,OKC_K_PARTY_ROLES_B PR
7027: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7028: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7056: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS

7052: ,NULL CONTACT_NAME
7053: ,PR.ID CONTACT_ROLE_ID
7054: ,CO.CRO_CODE CONTACT_ROLE_CODE
7055: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7056: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7057: ,OKC_CONTACTS CO
7058: ,OKC_K_PARTY_ROLES_B PR
7059: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7060: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7107: FROM JTF_RS_RESOURCE_EXTNS CS

7103: ,CS.CATEGORY RSC_CATEGORY
7104: ,TL.RESOURCE_NAME CONTACT_NAME -- Bug Fix #5442182 hmnair
7105: ,PR.ID CONTACT_ROLE_ID
7106: ,CO.CRO_CODE CONTACT_ROLE_CODE
7107: FROM JTF_RS_RESOURCE_EXTNS CS
7108: ,JTF_RS_SALESREPS S
7109: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7110: ,OKC_CONTACTS CO
7111: ,OKC_K_PARTY_ROLES_B PR

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

7105: ,PR.ID CONTACT_ROLE_ID
7106: ,CO.CRO_CODE CONTACT_ROLE_CODE
7107: FROM JTF_RS_RESOURCE_EXTNS CS
7108: ,JTF_RS_SALESREPS S
7109: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7110: ,OKC_CONTACTS CO
7111: ,OKC_K_PARTY_ROLES_B PR
7112: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7113: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id

Line 7143: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7139: -- for category 'SUPPLIER_CONTACT'
7140:
7141: CURSOR Lx_Csr_vndr_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7142: SELECT C.LAST_NAME NAME
7143: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7144: PO_VENDOR_SITES_ALL S ,
7145: PO_VENDOR_CONTACTS C
7146: WHERE RSC.RESOURCE_ID = Cx_Resource_Id
7147: and C.VENDOR_CONTACT_ID = RSC.SOURCE_ID

Line 7156: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7152: -- for category 'EMPLOYEE'
7153:
7154: CURSOR Lx_Csr_emp_name(Cx_Resource_Id IN number) IS
7155: SELECT PER.FULL_NAME NAME
7156: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7157: FND_USER U ,
7158: PER_ALL_PEOPLE_F PER
7159: WHERE PER.PERSON_ID = RSC.SOURCE_ID
7160: and U.USER_ID = RSC.USER_ID

Line 7169: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7165: -- for category 'PARTNER', 'PARTY'
7166:
7167: CURSOR Lx_Csr_pty_name(Cx_Resource_Id IN number) IS
7168: SELECT PARTY.PARTY_NAME NAME
7169: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7170: FND_USER U ,
7171: HZ_PARTIES PARTY
7172: WHERE RSC.CATEGORY IN ( 'PARTNER', 'PARTY')
7173: AND PARTY.PARTY_ID = RSC.SOURCE_ID

Line 7182: FROM JTF_RS_RESOURCE_EXTNS RSC ,

7178: -- for category 'OTHER'
7179:
7180: CURSOR Lx_Csr_oth_name(Cx_Resource_Id IN number, cn_org_id in number) IS
7181: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7182: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7183: FND_USER U ,
7184: JTF_RS_SALESREPS SRP
7185: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7186: WHERE RSC.CATEGORY = 'OTHER'

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

7181: SELECT TL.RESOURCE_NAME NAME -- Bug Fix #5442182 hmnair
7182: FROM JTF_RS_RESOURCE_EXTNS RSC ,
7183: FND_USER U ,
7184: JTF_RS_SALESREPS SRP
7185: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7186: WHERE RSC.CATEGORY = 'OTHER'
7187: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
7188: AND U.USER_ID = RSC.USER_ID
7189: AND SRP.Org_ID = Cn_Org_Id -- Modified for 12.0 MOAC project (JVARGHES)