APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_CONTACTS

Line 6959: ,OKC_Contacts CON

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

Line 6992: ,OKC_Contacts CON

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

Line 7037: ,OKC_Contacts CON

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

Line 7069: ,OKC_Contacts CON

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

Line 7363: ,OKC_CONTACTS CO

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

Line 7389: ,OKC_CONTACTS CO

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

Line 7413: ,OKC_CONTACTS CO

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

Line 7445: ,OKC_CONTACTS CO

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

Line 7472: ,OKC_CONTACTS CO

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

Line 7498: ,OKC_CONTACTS CO

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

Line 15284: OKC_CONTACTS CON

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