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_K_PARTY_ROLES_B

Line 211: FROM OKC_K_PARTY_ROLES_B rle,

207: IS
208: CURSOR party_sites_cur(p_party_id VARCHAR2, p_site_name VARCHAR2)
209: IS
210: SELECT PSE.PARTY_SITE_ID ID1
211: FROM OKC_K_PARTY_ROLES_B rle,
212: OKC_K_HEADERS_ALL_V hdr1,
213: okc_k_items itm,
214: HZ_PARTY_SITES PSE,
215: HZ_LOCATIONS LCN

Line 232: FROM OKC_K_PARTY_ROLES_B rle,

228:
229: CURSOR party_items_cur(p_party_id VARCHAR2, p_item_name VARCHAR2)
230: IS
231: SELECT B.INVENTORY_ITEM_ID ID1
232: FROM OKC_K_PARTY_ROLES_B rle,
233: OKC_K_HEADERS_ALL_V hdr1,
234: okc_k_items itm,
235: MTL_SYSTEM_ITEMS_B_KFV B,
236: MTL_SYSTEM_ITEMS_TL T

Line 255: FROM OKC_K_PARTY_ROLES_B rle,

251:
252: CURSOR party_systems_cur(p_party_id VARCHAR2, p_system_name VARCHAR2)
253: IS
254: SELECT B.SYSTEM_ID ID1
255: FROM OKC_K_PARTY_ROLES_B rle,
256: OKC_K_HEADERS_ALL_V hdr1,
257: okc_k_items itm,
258: CS_SYSTEMS_ALL_B B,
259: CS_SYSTEMS_ALL_TL T

Line 276: FROM OKC_K_PARTY_ROLES_B rle,

272:
273: CURSOR party_products_cur(p_party_id VARCHAR2, p_product_name VARCHAR2)
274: IS
275: SELECT CP.INSTANCE_ID ID1
276: FROM OKC_K_PARTY_ROLES_B rle,
277: OKC_K_HEADERS_ALL_B hdr1,
278: okc_k_items itm,
279: CSI_ITEM_INSTANCES CP,
280: MTL_SYSTEM_ITEMS_B_KFV BK

Line 539: FROM OKC_K_PARTY_ROLES_B rle,

535: '#' ID2,
536: PSE.PARTY_SITE_NAME NAME,
537: SUBSTR(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,LCN.ADDRESS4,
538: LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
539: FROM OKC_K_PARTY_ROLES_B rle,
540: OKC_K_HEADERS_ALL_V hdr1,
541: okc_k_items itm,
542: HZ_PARTY_SITES PSE,
543: HZ_LOCATIONS LCN

Line 642: FROM OKC_K_PARTY_ROLES_B rle,

638: B.INVENTORY_ITEM_ID ID1,
639: B.ORGANIZATION_ID ID2,
640: T.DESCRIPTION NAME,
641: B.CONCATENATED_SEGMENTS DESCRIPTION
642: FROM OKC_K_PARTY_ROLES_B rle,
643: OKC_K_HEADERS_ALL_V hdr1,
644: okc_k_items itm,
645: MTL_SYSTEM_ITEMS_B_KFV B,
646: MTL_SYSTEM_ITEMS_TL T

Line 749: FROM OKC_K_PARTY_ROLES_B rle,

745: B.SYSTEM_ID ID1,
746: '#' ID2,
747: T.NAME NAME,
748: T.DESCRIPTION DESCRIPTION
749: FROM OKC_K_PARTY_ROLES_B rle,
750: OKC_K_HEADERS_ALL_V hdr1,
751: okc_k_items itm,
752: CS_SYSTEMS_ALL_B B,
753: CS_SYSTEMS_ALL_TL T

Line 854: FROM OKC_K_PARTY_ROLES_B rle,

850: CP.INSTANCE_ID ID1,
851: '#' ID2,
852: BK.DESCRIPTION NAME,
853: BK.CONCATENATED_SEGMENTS || '-' || CP.instance_number DESCRIPTION
854: FROM OKC_K_PARTY_ROLES_B rle,
855: OKC_K_HEADERS_ALL_B hdr1,
856: OKC_K_ITEMS itm,
857: CSI_ITEM_INSTANCES CP,
858: MTL_SYSTEM_ITEMS_B_KFV BK

Line 1422: OKC_K_PARTY_ROLES_B rle,

1418: pty.gsa_indicator_flag Gsa
1419: FROM
1420: FND_LOOKUPS fnd,
1421: OKX_PARTIES_V pty,
1422: OKC_K_PARTY_ROLES_B rle,
1423: OKC_K_HEADERS_ALL_B hdr
1424: WHERE
1425: hdr.id=p_contract_id
1426: and rle.chr_id=hdr.id

Line 1444: OKC_K_PARTY_ROLES_B rle,

1440: NULL Gsa
1441: FROM
1442: FND_LOOKUPS fnd,
1443: OKX_PARTIES_V pty,
1444: OKC_K_PARTY_ROLES_B rle,
1445: OKC_K_HEADERS_ALL_B hdr
1446: WHERE
1447: hdr.id=p_contract_id
1448: AND rle.chr_id=hdr.id

Line 1466: OKC_K_PARTY_ROLES_B rle,

1462: NULL Gsa
1463: FROM
1464: FND_LOOKUPS fnd,
1465: OKX_ORGANIZATION_DEFS_V pty,
1466: OKC_K_PARTY_ROLES_B rle,
1467: OKC_K_HEADERS_ALL_B hdr
1468: WHERE
1469: hdr.id=p_contract_id
1470: AND rle.chr_id=hdr.id

Line 2004: OKC_K_PARTY_ROLES_B rol

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
2008: and rol.CLE_ID is NULL

Line 2684: OKC_K_PARTY_ROLES_B rol,

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)
2688: and rol.cle_id = ln.ID

Line 2699: OKC_K_PARTY_ROLES_B PR,

2695: CONT.START_DATE StartDate,
2696: CONT.END_DATE EndDate,
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,

Line 3231: okc_k_party_roles_b pty ,

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
3235: where

Line 3254: okc_k_party_roles_b pty ,

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
3258: where

Line 3276: okc_k_party_roles_b pty ,

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
3280: where

Line 3298: okc_k_party_roles_b pty ,

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
3302: where

Line 3333: OKC_K_PARTY_ROLES_B PartyRoles,

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,
3336: PER_ALL_PEOPLE_F employee,
3337: HZ_PARTIES hz_party

Line 3361: OKC_K_PARTY_ROLES_B PartyRoles

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)
3364: AND PartyRoles.cle_id = okcline.ID
3365: AND PartyRoles.dnz_chr_id = okcline.dnz_chr_id