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 OKC_K_PARTY_ROLES_B

Line 5366: FROM OKC_K_PARTY_ROLES_B PTY

5362: ,OKSHDR.billing_profile_id billing_profile_id -- 11.5.10 changes
5363: ,OKSHDR.tax_exemption_id tax_exemption_id -- 11.5.10 changes
5364: ,OKSHDR.tax_status tax_status -- 11.5.10 changes
5365: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5366: FROM OKC_K_PARTY_ROLES_B PTY
5367: ,OKC_K_HEADERS_TL HDT
5368: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5369: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5370: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)

Line 6572: ,OKC_K_Party_Roles_B ROL

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
6575: ,OKC_K_Lines_B COV
6576: ,okc_k_items cimbp

Line 6605: ,OKC_K_Party_Roles_B ROL

6601: ,con.primary_yn
6602: ,con.resource_class
6603: FROM OKS_Resource_Groups_V RSG
6604: ,OKC_Contacts CON
6605: ,OKC_K_Party_Roles_B ROL
6606: ,OKC_K_Lines_B BPL
6607: ,OKC_K_Lines_B SBL
6608: ,OKC_K_Lines_B COV
6609: ,okc_k_items cimbp

Line 6650: ,OKC_K_Party_Roles_B ROL

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
6653: ,oks_k_lines_b ksl
6654: WHERE ksl.cle_id = Cx_SBL_Id

Line 6682: ,OKC_K_Party_Roles_B ROL

6678: ,ksl.dnz_chr_id ksl_dnz_chr_id
6679:
6680: FROM OKS_Resource_Groups_V RSG
6681: ,OKC_Contacts CON
6682: ,OKC_K_Party_Roles_B ROL
6683: ,OKC_K_Lines_B BPL
6684: ,okc_k_items cimbp
6685: ,oks_k_lines_b ksl
6686: WHERE ksl.cle_id = Cx_SBL_Id

Line 6976: ,OKC_K_PARTY_ROLES_B PR

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
6979:
6980: -- Modified for 12.0 MOAC project (JVARGHES)

Line 7002: ,OKC_K_PARTY_ROLES_B PR

6998: ,CO.CRO_CODE CONTACT_ROLE_CODE
6999: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7000: ,PER_ALL_PEOPLE_F PER
7001: ,OKC_CONTACTS CO
7002: ,OKC_K_PARTY_ROLES_B PR
7003: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7004: and co.dnz_chr_id = pr.dnz_chr_id
7005: AND CO.CPL_ID = PR.ID
7006: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1

Line 7026: ,OKC_K_PARTY_ROLES_B PR

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
7029: AND co.dnz_chr_id = pr.dnz_chr_id
7030: AND CO.CPL_ID = PR.ID

Line 7058: ,OKC_K_PARTY_ROLES_B PR

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
7061: and PR.CLE_ID = Cx_Cle_Id
7062:

Line 7085: ,OKC_K_PARTY_ROLES_B PR

7081: ,CO.CRO_CODE CONTACT_ROLE_CODE
7082: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7083: ,PER_ALL_PEOPLE_F PER
7084: ,OKC_CONTACTS CO
7085: ,OKC_K_PARTY_ROLES_B PR
7086: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7087: and PR.CLE_ID = Cx_Cle_Id
7088: and co.dnz_chr_id = pr.dnz_chr_id
7089: AND CO.CPL_ID = PR.ID

Line 7111: ,OKC_K_PARTY_ROLES_B PR

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
7114: and PR.CLE_ID = Cx_Cle_Id
7115: and co.dnz_chr_id = pr.dnz_chr_id

Line 8796: FROM OKC_K_PARTY_ROLES_B PR

8792: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
8793: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
8794: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
8795: AND EXISTS (SELECT '*'
8796: FROM OKC_K_PARTY_ROLES_B PR
8797: WHERE PR.CHR_ID = IT.DNZ_CHR_ID
8798: AND PR.CLE_ID IS NULL
8799: AND PR.DNZ_CHR_ID = IT.DNZ_CHR_ID
8800: AND PR.OBJECT1_ID1 = TO_CHAR(p_party_id)

Line 10177: FROM Okc_K_Party_Roles_B PR

10173: AND HD.Template_YN <> 'Y'
10174: AND (Cv_Cont_Pty_Id IS NULL
10175: OR
10176: EXISTS (SELECT '*'
10177: FROM Okc_K_Party_Roles_B PR
10178: WHERE PR.Chr_Id = HD.Id
10179: AND PR.Cle_Id IS NULL
10180: AND PR.Dnz_Chr_Id = HD.Id
10181: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 12389: ,Okc_K_Party_Roles_B PR

12385: AND (Cv_Con_Cusomer_Id IS NULL
12386: OR
12387: HB.Id IN ( SELECT PR.Chr_Id
12388: FROM Okx_Parties_V PX
12389: ,Okc_K_Party_Roles_B PR
12390: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
12391: AND PR.Rle_Code = 'CUSTOMER'
12392: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
12393: AND PX.Id1 = TO_NUMBER(PR.Object1_Id1)

Line 13925: OKC_K_PARTY_ROLES_B CPL,

13921: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
13922: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
13923: FROM OKC_K_LINES_B CVL,
13924: OKC_K_LINES_B BPL,
13925: OKC_K_PARTY_ROLES_B CPL,
13926: OKC_CONTACTS CON
13927: WHERE CVL.ID = p_coverage_id
13928: AND BPL.CLE_ID = CVL.ID
13929: AND BPL.LSE_ID in (3,16,21)

Line 15466: FROM Okc_K_Party_Roles_B PR

15462: AND CL.Cle_Id = SV.Id
15463: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
15464: AND CL.Id = NVL(Cx_CovLvlLine_Id, CL.Id)
15465: AND EXISTS (SELECT '*'
15466: FROM Okc_K_Party_Roles_B PR
15467: WHERE PR.Chr_Id = HD.Id
15468: AND PR.Cle_Id IS NULL
15469: AND PR.Dnz_Chr_Id = HD.Id
15470: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 15521: FROM Okc_K_Party_Roles_B PR

15517: nvl(trunc(Cx_Date_Terminated_From),nvl(trunc(Cx_Date_Terminated_To),trunc(HD.Date_Terminated))) and
15518: nvl(trunc(Cx_Date_Terminated_To),nvl(trunc(Cx_Date_Terminated_From),trunc(HD.Date_Terminated))))))
15519: AND HD.Sts_code = nvl(Cx_HD_Sts_Code,HD.Sts_code)
15520: AND EXISTS (SELECT '*'
15521: FROM Okc_K_Party_Roles_B PR
15522: WHERE PR.Chr_Id = HD.Id
15523: AND PR.Cle_Id IS NULL
15524: AND PR.Dnz_Chr_Id = HD.Id
15525: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 17491: FROM Okc_K_Party_Roles_B PR

17487: AND (Cv_Cont_Pty_Id IS NULL
17488: OR
17489: EXISTS
17490: (SELECT 'x'
17491: FROM Okc_K_Party_Roles_B PR
17492: WHERE pr.Cle_Id IS NULL
17493: AND PR.Dnz_Chr_Id = b.Id
17494: -- AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
17495: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 17540: Okc_K_Party_Roles_B PR

17536: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17537: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17538: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17539: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17540: Okc_K_Party_Roles_B PR
17541: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
17542: AND PR.Object1_Id2 = '#'
17543: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
17544: AND PR.RLE_CODE <> 'VENDOR'

Line 17620: FROM Okc_K_Party_Roles_B PR,

17616: SELECT /*+ ordered use_nl(pr grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17617: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17618: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17619:
17620: FROM Okc_K_Party_Roles_B PR,
17621: Okc_K_grpings grpng,
17622: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17623: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17624:

Line 17699: FROM Okc_K_Party_Roles_B PR

17695: AND authoring_org_id = nvl(cv_authoring_org_id,authoring_org_id) -- multi org security check
17696: AND (Cv_Cont_Pty_Id IS NULL
17697: OR
17698: EXISTS (SELECT 'x'
17699: FROM Okc_K_Party_Roles_B PR
17700: WHERE pr.Cle_Id IS NULL
17701: AND PR.Dnz_Chr_Id = b.Id
17702: -- AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
17703: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 17760: FROM Okc_K_Party_Roles_B PR

17756: AND (Cv_Cont_Pty_Id IS NULL
17757: OR
17758: EXISTS
17759: (SELECT 'x'
17760: FROM Okc_K_Party_Roles_B PR
17761: WHERE pr.Cle_Id IS NULL
17762: AND PR.Dnz_Chr_Id = b.Id
17763: --AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
17764: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)