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 5754: FROM OKC_K_PARTY_ROLES_B PTY

5750: ,OKSHDR.billing_profile_id billing_profile_id -- 11.5.10 changes
5751: ,OKSHDR.tax_exemption_id tax_exemption_id -- 11.5.10 changes
5752: ,OKSHDR.tax_status tax_status -- 11.5.10 changes
5753: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5754: FROM OKC_K_PARTY_ROLES_B PTY
5755: ,OKC_K_HEADERS_TL HDT
5756: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5757: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5758: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)

Line 6960: ,OKC_K_Party_Roles_B ROL

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
6963: ,OKC_K_Lines_B COV
6964: ,okc_k_items cimbp

Line 6993: ,OKC_K_Party_Roles_B ROL

6989: ,con.primary_yn
6990: ,con.resource_class
6991: FROM OKS_Resource_Groups_V RSG
6992: ,OKC_Contacts CON
6993: ,OKC_K_Party_Roles_B ROL
6994: ,OKC_K_Lines_B BPL
6995: ,OKC_K_Lines_B SBL
6996: ,OKC_K_Lines_B COV
6997: ,okc_k_items cimbp

Line 7038: ,OKC_K_Party_Roles_B ROL

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

Line 7070: ,OKC_K_Party_Roles_B ROL

7066: ,ksl.dnz_chr_id ksl_dnz_chr_id
7067:
7068: FROM OKS_Resource_Groups_V RSG
7069: ,OKC_Contacts CON
7070: ,OKC_K_Party_Roles_B ROL
7071: ,OKC_K_Lines_B BPL
7072: ,okc_k_items cimbp
7073: ,oks_k_lines_b ksl
7074: WHERE ksl.cle_id = Cx_SBL_Id

Line 7364: ,OKC_K_PARTY_ROLES_B PR

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

Line 7390: ,OKC_K_PARTY_ROLES_B PR

7386: ,CO.CRO_CODE CONTACT_ROLE_CODE
7387: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7388: ,PER_ALL_PEOPLE_F PER
7389: ,OKC_CONTACTS CO
7390: ,OKC_K_PARTY_ROLES_B PR
7391: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7392: and co.dnz_chr_id = pr.dnz_chr_id
7393: AND CO.CPL_ID = PR.ID
7394: AND CO.OBJECT1_ID1 = POA.AGENT_ID --CS.ID1

Line 7414: ,OKC_K_PARTY_ROLES_B PR

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

Line 7446: ,OKC_K_PARTY_ROLES_B PR

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
7449: and PR.CLE_ID = Cx_Cle_Id
7450:

Line 7473: ,OKC_K_PARTY_ROLES_B PR

7469: ,CO.CRO_CODE CONTACT_ROLE_CODE
7470: FROM PO_AGENTS POA --OKX_BUYERS_V CS
7471: ,PER_ALL_PEOPLE_F PER
7472: ,OKC_CONTACTS CO
7473: ,OKC_K_PARTY_ROLES_B PR
7474: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7475: and PR.CLE_ID = Cx_Cle_Id
7476: and co.dnz_chr_id = pr.dnz_chr_id
7477: AND CO.CPL_ID = PR.ID

Line 7499: ,OKC_K_PARTY_ROLES_B PR

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

Line 9185: FROM OKC_K_PARTY_ROLES_B PR

9181: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9182: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9183: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
9184: AND EXISTS (SELECT/*+ push_subq no_unnest */ '*'
9185: FROM OKC_K_PARTY_ROLES_B PR
9186: WHERE PR.CHR_ID = IT.DNZ_CHR_ID
9187: AND PR.CLE_ID IS NULL
9188: AND PR.DNZ_CHR_ID = IT.DNZ_CHR_ID
9189: AND PR.OBJECT1_ID1 = TO_CHAR(p_party_id)

Line 9203: FROM OKC_K_PARTY_ROLES_B PR

9199: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9200: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9201: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
9202: AND EXISTS (SELECT/*+ push_subq no_unnest */ '*'
9203: FROM OKC_K_PARTY_ROLES_B PR
9204: WHERE PR.CHR_ID = IT.DNZ_CHR_ID
9205: AND PR.CLE_ID IS NULL
9206: AND PR.DNZ_CHR_ID = IT.DNZ_CHR_ID
9207: AND PR.OBJECT1_ID1 = TO_CHAR(p_party_id)

Line 10608: FROM Okc_K_Party_Roles_B PR

10604: AND HD.Template_YN <> 'Y'
10605: AND (Cv_Cont_Pty_Id IS NULL
10606: OR
10607: EXISTS (SELECT '*'
10608: FROM Okc_K_Party_Roles_B PR
10609: WHERE PR.Chr_Id = HD.Id
10610: AND PR.Cle_Id IS NULL
10611: AND PR.Dnz_Chr_Id = HD.Id
10612: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 10653: FROM Okc_K_Party_Roles_B PR

10649: AND HD.Template_YN <> 'Y'
10650: AND (Cv_Cont_Pty_Id IS NULL
10651: OR
10652: EXISTS (SELECT '*'
10653: FROM Okc_K_Party_Roles_B PR
10654: WHERE PR.Chr_Id = HD.Id
10655: AND PR.Cle_Id IS NULL
10656: AND PR.Dnz_Chr_Id = HD.Id
10657: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 13640: ,Okc_K_Party_Roles_B PR

13636: AND (Cv_Con_Cusomer_Id IS NULL
13637: OR
13638: HB.Id IN ( SELECT PR.Chr_Id
13639: FROM Okx_Parties_V PX
13640: ,Okc_K_Party_Roles_B PR
13641: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
13642: AND PR.Rle_Code in ('CUSTOMER')
13643: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
13644: AND PX.Id1 = TO_NUMBER(PR.Object1_Id1)

Line 13687: ,Okc_K_Party_Roles_B PR

13683: AND (Cv_Con_Cusomer_Id IS NULL
13684: OR
13685: HB.Id IN ( SELECT PR.Chr_Id
13686: FROM Okx_Parties_V PX
13687: ,Okc_K_Party_Roles_B PR
13688: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
13689: AND PR.Rle_Code in ('CUSTOMER','SUBSCRIBER') ---Modified condition for ER9681794
13690: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
13691: AND PX.Id1 = TO_NUMBER(PR.Object1_Id1)

Line 15283: OKC_K_PARTY_ROLES_B CPL,

15279: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
15280: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
15281: FROM OKC_K_LINES_B CVL,
15282: OKC_K_LINES_B BPL,
15283: OKC_K_PARTY_ROLES_B CPL,
15284: OKC_CONTACTS CON
15285: WHERE CVL.ID = p_coverage_id
15286: AND BPL.CLE_ID = CVL.ID
15287: AND BPL.LSE_ID in (3,16,21)

Line 16869: FROM Okc_K_Party_Roles_B PR

16865: AND CL.Cle_Id = SV.Id
16866: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
16867: AND CL.Id = NVL(Cx_CovLvlLine_Id, CL.Id)
16868: AND EXISTS (SELECT '*'
16869: FROM Okc_K_Party_Roles_B PR
16870: WHERE PR.Chr_Id = HD.Id
16871: AND PR.Cle_Id IS NULL
16872: AND PR.Dnz_Chr_Id = HD.Id
16873: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 16945: FROM Okc_K_Party_Roles_B PR

16941: AND CL.Cle_Id = SV.Id
16942: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
16943: AND CL.Id = NVL(Cx_CovLvlLine_Id, CL.Id)
16944: AND EXISTS (SELECT '*'
16945: FROM Okc_K_Party_Roles_B PR
16946: WHERE PR.Chr_Id = HD.Id
16947: AND PR.Cle_Id IS NULL
16948: AND PR.Dnz_Chr_Id = HD.Id
16949: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 17000: FROM Okc_K_Party_Roles_B PR

16996: nvl(trunc(Cx_Date_Terminated_From),nvl(trunc(Cx_Date_Terminated_To),trunc(HD.Date_Terminated))) and
16997: nvl(trunc(Cx_Date_Terminated_To),nvl(trunc(Cx_Date_Terminated_From),trunc(HD.Date_Terminated))))))
16998: AND HD.Sts_code = nvl(Cx_HD_Sts_Code,HD.Sts_code)
16999: AND EXISTS (SELECT '*'
17000: FROM Okc_K_Party_Roles_B PR
17001: WHERE PR.Chr_Id = HD.Id
17002: AND PR.Cle_Id IS NULL
17003: AND PR.Dnz_Chr_Id = HD.Id
17004: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 17054: FROM Okc_K_Party_Roles_B PR

17050: nvl(trunc(Cx_Date_Terminated_From),nvl(trunc(Cx_Date_Terminated_To),trunc(HD.Date_Terminated))) and
17051: nvl(trunc(Cx_Date_Terminated_To),nvl(trunc(Cx_Date_Terminated_From),trunc(HD.Date_Terminated))))))
17052: AND HD.Sts_code = nvl(Cx_HD_Sts_Code,HD.Sts_code)
17053: AND EXISTS (SELECT '*'
17054: FROM Okc_K_Party_Roles_B PR
17055: WHERE PR.Chr_Id = HD.Id
17056: AND PR.Cle_Id IS NULL
17057: AND PR.Dnz_Chr_Id = HD.Id
17058: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 17109: FROM Okc_K_Party_Roles_B PR

17105: nvl(trunc(Cx_Date_Terminated_From),nvl(trunc(Cx_Date_Terminated_To),trunc(HD.Date_Terminated))) and
17106: nvl(trunc(Cx_Date_Terminated_To),nvl(trunc(Cx_Date_Terminated_From),trunc(HD.Date_Terminated))))))
17107: AND HD.Sts_code = nvl(Cx_HD_Sts_Code,HD.Sts_code)
17108: AND EXISTS (SELECT '*'
17109: FROM Okc_K_Party_Roles_B PR
17110: WHERE PR.Chr_Id = HD.Id
17111: AND PR.Cle_Id IS NULL
17112: AND PR.Dnz_Chr_Id = HD.Id
17113: AND PR.Object1_Id1 = Cv_Cont_Pty_Id

Line 19335: FROM Okc_K_Party_Roles_B PR

19331: AND (Cv_Cont_Pty_Id IS NULL
19332: OR
19333: EXISTS
19334: (SELECT 'x'
19335: FROM Okc_K_Party_Roles_B PR
19336: WHERE pr.Cle_Id IS NULL
19337: AND PR.Dnz_Chr_Id = b.Id
19338: -- AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
19339: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19406: FROM Okc_K_Party_Roles_B PR

19402: AND (Cv_Cont_Pty_Id IS NULL
19403: OR
19404: EXISTS
19405: (SELECT 'x'
19406: FROM Okc_K_Party_Roles_B PR
19407: WHERE pr.Cle_Id IS NULL
19408: AND PR.Dnz_Chr_Id = b.Id
19409: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19410: AND PR.Object1_Id2 = '#'

Line 19438: Okc_K_Party_Roles_B PR

19434: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19435: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19436: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19437: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19438: Okc_K_Party_Roles_B PR
19439: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19440: AND PR.Object1_Id2 = '#'
19441: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
19442: AND PR.RLE_CODE <> 'VENDOR'

Line 19481: Okc_K_Party_Roles_B PR

19477: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19478: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19479: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19480: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19481: Okc_K_Party_Roles_B PR
19482: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19483: AND PR.Object1_Id2 = '#'
19484: AND PR.Jtot_Object1_Code = 'OKX_PARTY'
19485: AND PR.RLE_CODE not in ('VENDOR','MERCHANT') ---Modified condition for ER9681794

Line 19561: FROM Okc_K_Party_Roles_B PR,

19557: SELECT /*+ ordered use_nl(pr grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19558: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19559: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19560:
19561: FROM Okc_K_Party_Roles_B PR,
19562: Okc_K_grpings grpng,
19563: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19564: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19565:

Line 19608: FROM Okc_K_Party_Roles_B PR,

19604: SELECT /*+ ordered use_nl(pr grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19605: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19606: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19607:
19608: FROM Okc_K_Party_Roles_B PR,
19609: Okc_K_grpings grpng,
19610: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19611: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19612:

Line 19688: FROM Okc_K_Party_Roles_B PR

19684: AND authoring_org_id = nvl(cv_authoring_org_id,authoring_org_id) -- multi org security check
19685: AND (Cv_Cont_Pty_Id IS NULL
19686: OR
19687: EXISTS (SELECT 'x'
19688: FROM Okc_K_Party_Roles_B PR
19689: WHERE pr.Cle_Id IS NULL
19690: AND PR.Dnz_Chr_Id = b.Id
19691: -- AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
19692: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19752: FROM Okc_K_Party_Roles_B PR

19748: AND authoring_org_id = nvl(cv_authoring_org_id,authoring_org_id) -- multi org security check
19749: AND (Cv_Cont_Pty_Id IS NULL
19750: OR
19751: EXISTS (SELECT 'x'
19752: FROM Okc_K_Party_Roles_B PR
19753: WHERE pr.Cle_Id IS NULL
19754: AND PR.Dnz_Chr_Id = b.Id
19755: -- AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
19756: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19814: FROM Okc_K_Party_Roles_B PR

19810: AND (Cv_Cont_Pty_Id IS NULL
19811: OR
19812: EXISTS
19813: (SELECT 'x'
19814: FROM Okc_K_Party_Roles_B PR
19815: WHERE pr.Cle_Id IS NULL
19816: AND PR.Dnz_Chr_Id = b.Id
19817: --AND to_number(PR.Object1_Id1) = nvl(Cv_Cont_Pty_Id,to_number(PR.Object1_Id1))
19818: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)

Line 19878: FROM Okc_K_Party_Roles_B PR

19874: AND (Cv_Cont_Pty_Id IS NULL
19875: OR
19876: EXISTS
19877: (SELECT 'x'
19878: FROM Okc_K_Party_Roles_B PR
19879: WHERE pr.Cle_Id IS NULL
19880: AND PR.Dnz_Chr_Id = b.Id
19881: AND PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19882: AND PR.Object1_Id2 = '#'