APPS.OKS_ENTITLEMENTS_WEB dependencies on OKC_CONTACTS_V

Line 2003: OKC_CONTACTS_V con,

1999: con.END_DATE EndDate,
2000: con.object1_id1 ContactID,
2001: con.object1_id2 ID2
2002: from
2003: OKC_CONTACTS_V con,
2004: OKC_K_PARTY_ROLES_B rol
2005: where
2006: rol.dnz_chr_id = to_number(p_contract_id_arg)
2007: and rol.RLE_CODE = p_party_rle_code_arg

Line 2683: OKC_CONTACTS_V con,

2679: con.START_DATE StartDate,
2680: con.END_DATE EndDate,
2681: OKC_UTIL.GET_NAME_FROM_JTFV(con.jtot_object1_code,con.object1_id1,con.object1_id2) ContactName
2682: from
2683: OKC_CONTACTS_V con,
2684: OKC_K_PARTY_ROLES_B rol,
2685: OKC_K_LINES_B ln
2686: where
2687: ln.ID = to_number(p_line_id_arg)

Line 3230: okc_contacts_v con,

3226: pty.rle_code rlecode,
3227: con.role resourcetype,
3228: C.LAST_NAME name2
3229: from
3230: okc_contacts_v con,
3231: okc_k_party_roles_b pty ,
3232: JTF_RS_RESOURCE_EXTNS RSC ,
3233: PO_VENDOR_SITES_ALL S ,
3234: PO_VENDOR_CONTACTS C

Line 3253: okc_contacts_v con,

3249: pty.rle_code rlecode,
3250: con.role resourcetype,
3251: EMP.FULL_NAME name2
3252: from
3253: okc_contacts_v con,
3254: okc_k_party_roles_b pty ,
3255: JTF_RS_RESOURCE_EXTNS RSC ,
3256: FND_USER U ,
3257: OKX_PER_ALL_PEOPLE_V EMP

Line 3275: okc_contacts_v con,

3271: pty.rle_code rlecode,
3272: con.role resourcetype,
3273: PARTY.PARTY_NAME name2
3274: from
3275: okc_contacts_v con,
3276: okc_k_party_roles_b pty ,
3277: JTF_RS_RESOURCE_EXTNS RSC ,
3278: FND_USER U ,
3279: HZ_PARTIES PARTY

Line 3297: okc_contacts_v con,

3293: pty.rle_code rlecode,
3294: con.role resourcetype,
3295: SRP.NAME name2
3296: from
3297: okc_contacts_v con,
3298: okc_k_party_roles_b pty ,
3299: JTF_RS_RESOURCE_EXTNS RSC ,
3300: FND_USER U ,
3301: JTF_RS_SALESREPS SRP