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_WEB dependencies on OKC_CONTACTS

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 2701: OKC_CONTACTS CONT,

2697: PR.CLE_ID ContractLineID
2698: FROM OKC_K_LINES_B LINE,
2699: OKC_K_PARTY_ROLES_B PR,
2700: FND_LOOKUPS FNDCONT,
2701: OKC_CONTACTS CONT,
2702: HZ_PARTIES HZP,
2703: HZ_RELATIONSHIPS HZR,
2704: HZ_CUST_ACCOUNT_ROLES ACCROLE
2705:

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

Line 3331: OKC_CONTACTS Contacts,

3327: ) name2
3328:
3329: FROM OKC_K_LINES_B okcline,
3330: JTF_RS_RESOURCE_EXTNS RSC,
3331: OKC_CONTACTS Contacts,
3332: FND_LOOKUPS RoleLookup,
3333: OKC_K_PARTY_ROLES_B PartyRoles,
3334: AP_SUPPLIER_CONTACTS ap_supp_contact,
3335: HZ_PARTIES vendor_contact,

Line 3359: OKC_CONTACTS Contacts,

3355: ,RoleLookup.meaning resourcetype
3356: ,resource_group.group_name name2
3357: FROM OKC_K_LINES_B okcline,
3358: JTF_RS_GROUPS_TL resource_group,
3359: OKC_CONTACTS Contacts,
3360: FND_LOOKUPS RoleLookup,
3361: OKC_K_PARTY_ROLES_B PartyRoles
3362:
3363: WHERE okcline.ID = to_number(p_bus_proc_ID_arg)