APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_CONTACTS

Line 6571: ,OKC_Contacts CON

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

Line 6604: ,OKC_Contacts CON

6600: ,cimbp.object1_id1
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

Line 6649: ,OKC_Contacts CON

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
6653: ,oks_k_lines_b ksl

Line 6681: ,OKC_Contacts CON

6677: ,bpl.id bpl_id
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

Line 6975: ,OKC_CONTACTS CO

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
6979:

Line 7001: ,OKC_CONTACTS CO

6997: ,PR.ID CONTACT_ROLE_ID
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

Line 7025: ,OKC_CONTACTS CO

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
7029: AND co.dnz_chr_id = pr.dnz_chr_id

Line 7057: ,OKC_CONTACTS CO

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

Line 7084: ,OKC_CONTACTS CO

7080: ,PR.ID CONTACT_ROLE_ID
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

Line 7110: ,OKC_CONTACTS CO

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

Line 13926: OKC_CONTACTS CON

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)
13930: AND BPL.ID = CPL.CLE_ID