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_V

Line 1187: FROM oks_k_lines_v srv,

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,
1188: okc_k_lines_v cov
1189: WHERE srv.cle_id = p_line_id
1190: AND srv.coverage_id = cov.id;
1191:

Line 3185: oks_k_lines_v ServiceLines,

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'
3189: and ActTimeTypes.cle_id = ActTimes.cle_id

Line 3212: oks_k_lines_v ServiceLines,

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'
3216: and ActTimeTypes.cle_id = ActTimes.cle_id

Line 3646: From OKS_K_LINES_V oksLn

3642: CURSOR usage_invoice_cur(p_line_id_arg VARCHAR2)
3643: IS
3644: /* Select oksLn.INVOICE_TEXT InvoiceText,
3645: oksLn.INV_PRINT_FLAG InvoicePrintFlg
3646: From OKS_K_LINES_V oksLn
3647: Where oksLn.Cle_Id = to_number(p_line_id_arg); */
3648:
3649: Select
3650: oksLnTL.INVOICE_TEXT InvoiceText

Line 3745: OKS_K_LINES_V oksLnV,

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)
3749: AND rul.cle_id = sub_line.id