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 OKS_K_LINES_B

Line 2439: OKS_K_LINES_TL oksLnTL, OKS_K_LINES_B oksLnB

2435: /* Select
2436: oksLnTL.INVOICE_TEXT InvoiceText,
2437: oksLnB.INV_PRINT_FLAG InvoicePrintFlg
2438: From
2439: OKS_K_LINES_TL oksLnTL, OKS_K_LINES_B oksLnB
2440: Where
2441: oksLnB.Cle_Id = to_number(p_line_id_arg)
2442: And oksLnTL.ID = oksLnB.ID; */
2443:

Line 2450: ,OKS_K_LINES_B oksLnB

2446: oksLnTL.INVOICE_TEXT InvoiceText
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')

Line 2465: From OKS_K_LINES_B oksLn,

2461: Select oksLn.tax_classification_code TaxCode
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;

Line 2479: OKS_K_LINES_B oksLn

2475: tcd.NAME TaxCode
2476: From
2477: OKX_TAX_CODES_V tcd,
2478: OKX_LOOKUPS_V lok,
2479: OKS_K_LINES_B oksLn
2480: Where
2481: oksLn.Cle_Id = to_number(p_line_id_arg)
2482: and lok.Lookup_Code = oksLn.TAX_STATUS
2483: and lok.Lookup_type = 'TAX_CONTROL_FLAG'

Line 2513: OKS_K_LINES_b oks,

2509: ln.END_DATE CoverageEndDate,
2510: decode(cov.lse_id,15,'Y','N') Warranty_YN
2511: From
2512: OKC_K_LINES_b ln,
2513: OKS_K_LINES_b oks,
2514: OKC_K_LINES_V cov
2515: Where
2516: ln.ID = to_number(p_line_id_arg)
2517: and ln.id = oks.cle_id

Line 2526: OKS_K_LINES_B oksLn

2522: IS
2523: Select cvt.MEANING CoverageType
2524: From
2525: OKS_COV_TYPES_V cvt,
2526: OKS_K_LINES_B oksLn
2527: Where
2528: oksLn.CLE_ID = p_coverage_id
2529: and cvt.CODE = oksLn.COVERAGE_TYPE;
2530: /*

Line 2544: OKS_K_LINES_B oksLn

2540: decode(ln.lse_id,15,'Y','N') Warranty_YN
2541: From
2542: OKC_K_LINES_V ln,
2543: OKC_K_LINES_B ln_c,
2544: OKS_K_LINES_B oksLn
2545: Where
2546: ln_c.CLE_ID = to_number(p_line_id_arg) and
2547: ln.LSE_ID in (2,15,20)
2548: and oksLn.CLE_ID = ln_c.ID

Line 2564: oks_k_lines_b oksrv,

2560: expcov.END_DATE EndDate,
2561: decode(expcov.lse_id,15,'Y','N') Warranty_YN
2562: from
2563: okc_k_lines_b srv,
2564: oks_k_lines_b oksrv,
2565: oks_k_lines_b okscov,
2566: okc_k_lines_v expcov
2567: Where srv.id = to_number(p_line_id_arg)
2568: AND srv.id = oksrv.cle_id

Line 2565: oks_k_lines_b okscov,

2561: decode(expcov.lse_id,15,'Y','N') Warranty_YN
2562: from
2563: okc_k_lines_b srv,
2564: oks_k_lines_b oksrv,
2565: oks_k_lines_b okscov,
2566: okc_k_lines_v expcov
2567: Where srv.id = to_number(p_line_id_arg)
2568: AND srv.id = oksrv.cle_id
2569: AND oksrv.coverage_id = okscov.cle_id

Line 2579: OKS_K_LINES_B oksLn

2575: Select
2576: cvt.MEANING CoverageType
2577: From
2578: OKS_COV_TYPES_V cvt,
2579: OKS_K_LINES_B oksLn
2580: Where
2581: oksLn.CLE_ID = p_excep_coverage_type_id
2582: and cvt.CODE = oksLn.COVERAGE_TYPE;
2583:

Line 2935: OKS_K_LINEs_B oksLn

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'
2939: and fnd.LOOKUP_CODE = oksLn.INHERITANCE_TYPE;

Line 2947: OKS_K_LINES_B oksLn,

2943: Select
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

Line 2977: OKS_K_LINES_B oksLn,

2973: Select
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

Line 3002: OKS_K_LINES_B oksLn

2998: Select
2999: dis.NAME Discount
3000: From
3001: OKX_LIST_HEADERS_V dis,
3002: OKS_K_LINES_B oksLn
3003: Where
3004: oksLn.CLE_ID = business_proc_id
3005: and dis.ID1 = oksLn.DISCOUNT_LIST;
3006:

Line 3389: OKS_K_LINES_B oksLn

3385: OKX_TRANSACTION_TYPES_V trn,
3386: OKX_TXN_BILLING_TYPES_V bil,
3387: OKC_K_ITEMS itm,
3388: OKC_K_LINES_B ln,
3389: OKS_K_LINES_B oksLn
3390: Where
3391: ln.CLE_ID = to_number(p_bus_proc_ID_arg)
3392: AND ln.LSE_ID in (5,23,59) -- Fix #4238239
3393: and itm.CLE_ID = ln.ID

Line 3654: ,OKS_K_LINES_B oksLnB

3650: oksLnTL.INVOICE_TEXT InvoiceText
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')

Line 3681: From OKS_K_LINES_B oksLn,

3677: IS
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;

Line 3693: OKS_K_LINES_B oksLn

3689: tcd.NAME TaxCode
3690: From
3691: OKX_TAX_CODES_V tcd,
3692: OKX_LOOKUPS_V lok,
3693: OKS_K_LINES_B oksLn
3694: Where
3695: oksLn.Cle_Id = to_number(p_line_id_arg)
3696: and lok.Lookup_Code = oksLn.TAX_STATUS
3697: and lok.Lookup_type = 'TAX_CONTROL_FLAG'

Line 3720: OKS_K_LINES_B oksLn

3716: oksLn.USAGE_TYPE
3717: )UsageType
3718: From
3719: OKX_UNITS_OF_MEASURE_V uom,
3720: OKS_K_LINES_B oksLn
3721: Where
3722: oksLn.CLE_ID = to_number(p_line_id_arg)
3723: and uom.UOM_CODE(+) = oksLn.USAGE_PERIOD;
3724:

Line 3743: OKS_K_LINES_B rul,

3739: '#' Reading,
3740: sub_line.price_negotiated Price,
3741: okcItms.object1_id1 ItemObject1_Id1
3742: FROM OKC_K_LINES_B sub_line,
3743: OKS_K_LINES_B rul,
3744: OKC_K_LINES_V okcLnV,
3745: OKS_K_LINES_V oksLnV,
3746: OKC_K_ITEMS okcItms,
3747: MTL_UNITS_OF_MEASURE_TL mtl