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 FND_LOOKUPS

Line 1290: FROM fnd_lookups fndLkups

1286:
1287: CURSOR cntrct_hdr_period_cur(p_period_unit VARCHAR)
1288: IS
1289: /*SELECT fndLkups.meaning
1290: FROM fnd_lookups fndLkups
1291: WHERE fndLkups.lookup_code = p_period_unit
1292: and fndLkups.lookup_type = 'EGO_SRV_DURATION_PERIOD';*/
1293: /*Bug #6140663 - fp of 6026318*/
1294: SELECT unit_of_measure_tl

Line 1420: FND_LOOKUPS fnd,

1416: pty.name name,
1417: fnd.meaning Role,
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

Line 1442: FND_LOOKUPS fnd,

1438: pty.name name,
1439: fnd.meaning Role,
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

Line 1464: FND_LOOKUPS fnd,

1460: pty.name name,
1461: fnd.meaning Role,
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

Line 2419: FND_LOOKUPS Fnd

2415: Select
2416: Fnd.Meaning RenewalType
2417: From
2418: OKC_K_LINES_B okcLn,
2419: FND_LOOKUPS Fnd
2420: Where
2421: okcLn.ID = to_number(p_line_id_arg)
2422: And Fnd.Lookup_Code = okcLn.LINE_RENEWAL_TYPE_CODE
2423: And Fnd.Lookup_Type = 'OKC_LINE_RENEWAL_TYPE';

Line 2451: ,FND_LOOKUPS fnd

2447: ,fnd.MEANING InvoicePrintFlg
2448: From
2449: OKS_K_LINES_TL oksLnTL
2450: ,OKS_K_LINES_B oksLnB
2451: ,FND_LOOKUPS fnd
2452: Where oksLnB.Cle_Id = to_number(p_line_id_arg)
2453: And oksLnTL.ID = oksLnB.ID
2454: And language = userenv('LANG')
2455: And fnd.LOOKUP_TYPE = 'OKS_Y_N'

Line 2466: FND_LOOKUPS lok

2462: ,lok.meaning TaxStatus
2463: ,oksLn.EXEMPT_CERTIFICATE_NUMBER TaxExcemptCertificate
2464: ,oksLn.EXEMPT_REASON_CODE TaxExcemptCode
2465: From OKS_K_LINES_B oksLn,
2466: FND_LOOKUPS lok
2467: Where oksLn.Cle_Id = to_number(p_line_id_arg)
2468: and lok.lookup_type = 'ZX_EXEMPTION_CONTROL'
2469: and lok.lookup_code = oksLn.tax_status;
2470:

Line 2593: FROM fnd_lookups fndLkups

2589: WHERE uom_code = p_period_unit
2590: AND language = userenv('LANG');
2591:
2592: /*SELECT fndLkups.meaning
2593: FROM fnd_lookups fndLkups
2594: WHERE fndLkups.lookup_code = p_period_unit
2595: and fndLkups.lookup_type = 'EGO_SRV_DURATION_PERIOD';*/
2596:
2597: CURSOR covered_level_cur(p_line_id_arg VARCHAR2)

Line 2667: FND_LOOKUPS Fnd

2663: Select
2664: Fnd.Meaning RenewalType
2665: From
2666: OKC_K_LINES_B okcLn,
2667: FND_LOOKUPS Fnd
2668: Where
2669: okcLn.Id = p_covered_level_id
2670: AND Fnd.Lookup_Code = okcLn.LINE_RENEWAL_TYPE_CODE
2671: And Fnd.Lookup_Type = 'OKC_LINE_RENEWAL_TYPE';

Line 2700: FND_LOOKUPS FNDCONT,

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,
2704: HZ_CUST_ACCOUNT_ROLES ACCROLE

Line 2934: FND_LOOKUPS fnd,

2930: IS
2931: Select
2932: fnd.MEANING WarrantyInheritance
2933: From
2934: FND_LOOKUPS fnd,
2935: OKS_K_LINEs_B oksLn
2936: Where
2937: oksLn.CLE_ID = to_number(p_coverage_ID_arg)
2938: and fnd.LOOKUP_TYPE = 'OKSWHETYPE'

Line 2948: FND_LOOKUPS Fnd

2944: oksLn.PROD_UPGRADE_YN FreeUpgrade,
2945: Fnd.MEANING TransferAllowed
2946: From
2947: OKS_K_LINES_B oksLn,
2948: FND_LOOKUPS Fnd
2949: Where
2950: oksLn.CLE_ID = to_number(p_coverage_ID_arg)
2951: AND Fnd.lookup_code = oksLn.TRANSFER_OPTION
2952: AND Fnd.lookup_type='OKS_TRANSFER_OPTIONS';

Line 2978: FND_LOOKUPS Fnd

2974: oksLn.OFFSET_DURATION OffSetDuration,
2975: Fnd.Meaning OffsetPeriod
2976: From
2977: OKS_K_LINES_B oksLn,
2978: FND_LOOKUPS Fnd
2979: Where
2980: -- oksLn.dnz_chr_id = to_number(p_contract_ID_arg)
2981: oksLn.CLE_ID = business_proc_id
2982: and Fnd.lookup_type = 'EGO_SRV_DURATION_PERIOD'

Line 3332: FND_LOOKUPS RoleLookup,

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

Line 3360: FND_LOOKUPS RoleLookup,

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

Line 3412: fnd_lookups fnd

3408:
3409: FROM oks_billrate_schedules bsh ,
3410: okc_k_lines_b lines,
3411: mtl_units_of_measure_tl mtl,
3412: fnd_lookups fnd
3413: WHERE bsh.cle_id = lines.id
3414: and lines.lse_id in (6,24,60)
3415: and lines.cle_id = p_bill_type_id
3416: and mtl.UOM_CODE(+) = bsh.UOM

Line 3655: ,FND_LOOKUPS fnd

3651: ,fnd.MEANING InvoicePrintFlg
3652: From
3653: OKS_K_LINES_TL oksLnTL
3654: ,OKS_K_LINES_B oksLnB
3655: ,FND_LOOKUPS fnd
3656: Where oksLnB.Cle_Id = to_number(p_line_id_arg)
3657: And oksLnTL.ID = oksLnB.ID
3658: And language = userenv('LANG')
3659: And fnd.LOOKUP_TYPE = 'OKS_Y_N'

Line 3682: FND_LOOKUPS lok

3678:
3679: Select lok.meaning TaxStatus
3680: ,oksLn.tax_classification_code TaxCode
3681: From OKS_K_LINES_B oksLn,
3682: FND_LOOKUPS lok
3683: Where oksLn.Cle_Id = to_number(p_line_id_arg)
3684: and lok.lookup_type = 'ZX_EXEMPTION_CONTROL'
3685: and lok.lookup_code = oksLn.tax_status;
3686: