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_LINES_V

Line 1183: -- SELECT name FROM okc_k_lines_v WHERE cle_id = p_line_id AND lse_id=p_lse_id;

1179: IS
1180: -- R12 Spanigra (Changed the cursor based on Coverage rearchitecture design)
1181: -- CURSOR line_cov_name_cur( p_line_id NUMBER, p_lse_id NUMBER)
1182: -- IS
1183: -- SELECT name FROM okc_k_lines_v WHERE cle_id = p_line_id AND lse_id=p_lse_id;
1184: CURSOR line_cov_name_cur( p_line_id NUMBER)
1185: IS
1186: SELECT name
1187: FROM oks_k_lines_v srv,

Line 1188: okc_k_lines_v cov

1184: CURSOR line_cov_name_cur( p_line_id NUMBER)
1185: IS
1186: SELECT name
1187: FROM oks_k_lines_v srv,
1188: okc_k_lines_v cov
1189: WHERE srv.cle_id = p_line_id
1190: AND srv.coverage_id = cov.id;
1191:
1192: l_line_cov_name OKC_K_LINES_V.NAME%TYPE;

Line 1192: l_line_cov_name OKC_K_LINES_V.NAME%TYPE;

1188: okc_k_lines_v cov
1189: WHERE srv.cle_id = p_line_id
1190: AND srv.coverage_id = cov.id;
1191:
1192: l_line_cov_name OKC_K_LINES_V.NAME%TYPE;
1193:
1194: BEGIN
1195: -- OPEN line_cov_name_cur(p_line_id, p_lse_id);
1196: OPEN line_cov_name_cur(p_line_id); -- R12 Spanigra

Line 1501: okc_k_lines_v ln

1497: itm.number_of_items Quantity
1498: FROM
1499: MTL_SYSTEM_ITEMS_KFV sys,
1500: okc_k_items itm,
1501: okc_k_lines_v ln
1502: WHERE
1503: ln.DNZ_CHR_ID=p_contract_id
1504: AND ln.lse_id IN (1,12,14,19)
1505: AND itm.cle_id=ln.id

Line 1520: okc_k_lines_v ln

1516: cus.description AccountDesc,
1517: cus.party_id Account
1518: FROM
1519: okx_customer_accounts_v cus,
1520: okc_k_lines_v ln
1521: WHERE
1522: ln.DNZ_CHR_ID = p_contract_id
1523: AND ln.id=p_line_id
1524: AND ln.lse_id IN (1,12,14,19)

Line 2496: OKC_K_LINES_V ln

2492: ln.START_DATE CoverageStartDate,
2493: ln.END_DATE CoverageEndDate,
2494: decode(ln.lse_id,15,'Y','N') Warranty_YN
2495: From
2496: OKC_K_LINES_V ln
2497: Where
2498: ln.CLE_ID = to_number(p_line_id_arg)
2499: and ln.LSE_ID in (2,15,20);
2500: */

Line 2514: OKC_K_LINES_V cov

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
2518: and cov.id = oks.coverage_id

Line 2542: OKC_K_LINES_V ln,

2538: ln.START_DATE StartDate,
2539: ln.END_DATE EndDate,
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

Line 2566: okc_k_lines_v expcov

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
2570: AND okscov.EXCEPTION_COV_ID = expcov.id;

Line 2962: OKC_K_LINES_V ln

2958: bus.NAME Name
2959: From
2960: OKC_K_ITEMS itm,
2961: OKX_BUS_PROCESSES_V bus,
2962: OKC_K_LINES_V ln
2963: Where
2964: ln.CLE_ID = to_number(p_coverage_ID_arg)
2965: and ln.LSE_ID in (3,16 ,21)
2966: and ln.ID = itm.CLE_ID

Line 2991: OKC_K_LINES_v okCLn

2987: Select
2988: prl.NAME PriceList
2989: From
2990: OKX_LIST_HEADERS_V prl,
2991: OKC_K_LINES_v okCLn
2992: Where
2993: okcLn.ID = business_proc_id
2994: and prl.ID1 = okcLn.Price_list_id;
2995:

Line 3184: okc_k_lines_v CoreLines,

3180: NVL2 (ActTimes.fri_duration, (floor(ActTimes.fri_duration/60))||':'||decode(LENGTH(mod (ActTimes.fri_duration, 60)), 1, '0'||(mod (ActTimes.fri_duration, 60)), (mod (ActTimes.fri_duration, 60))), null ) Friday,
3181: NVL2 (ActTimes.sat_duration, (floor(ActTimes.sat_duration/60))||':'||decode(LENGTH(mod (ActTimes.sat_duration, 60)), 1, '0'||(mod (ActTimes.sat_duration, 60)), (mod (ActTimes.sat_duration, 60))), null ) Saturday
3182: from oks_action_time_types ActTimeTypes,
3183: oks_action_times ActTimes,
3184: okc_k_lines_v CoreLines,
3185: oks_k_lines_v ServiceLines,
3186: OKX_INCIDENT_SEVERITS_V IncidentSeverities
3187: where ActTimeTypes.cle_id = CoreLines.id
3188: and ActTimeTypes.action_type_code='RCN'

Line 3211: okc_k_lines_v CoreLines,

3207: NVL2 (ActTimes.fri_duration, (floor(ActTimes.fri_duration/60))||':'||decode(LENGTH(mod (ActTimes.fri_duration, 60)), 1, '0'||(mod (ActTimes.fri_duration, 60)), (mod (ActTimes.fri_duration, 60))), null ) Friday,
3208: NVL2 (ActTimes.sat_duration, (floor(ActTimes.sat_duration/60))||':'||decode(LENGTH(mod (ActTimes.sat_duration, 60)), 1, '0'||(mod (ActTimes.sat_duration, 60)), (mod (ActTimes.sat_duration, 60))), null ) Saturday
3209: from oks_action_time_types ActTimeTypes,
3210: oks_action_times ActTimes,
3211: okc_k_lines_v CoreLines,
3212: oks_k_lines_v ServiceLines,
3213: OKX_INCIDENT_SEVERITS_V IncidentSeverities
3214: where ActTimeTypes.cle_id = CoreLines.id
3215: and ActTimeTypes.action_type_code='RSN'

Line 3744: OKC_K_LINES_V okcLnV,

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
3748: WHERE sub_line.cle_id = to_number(p_line_id_arg)