APPS.OKS_COVERAGES_PVT dependencies on OKS_K_LINES_V

Line 655: FROM OKS_K_LINES_V

651: ,creation_date
652: ,last_updated_by
653: ,last_update_date
654: ,last_update_login
655: FROM OKS_K_LINES_V
656: WHERE cle_id = p_cle_id;
657:
658: -------------------------------------------------
659:

Line 4534: OKS_K_LINES_V oksl,

4530: NVL(acm.thu_duration,0) thu_duration,
4531: NVL(acm.fri_duration,0) fri_duration,
4532: NVL(acm.sat_duration,0) sat_duration
4533: FROM OKC_K_LINES_B lines,
4534: OKS_K_LINES_V oksl,
4535: OKS_ACTION_TIME_TYPES act,
4536: OKS_ACTION_TIMES acm
4537: WHERE lines.cle_id = p_cle_id
4538: AND lines.lse_id IN (4,17,22)

Line 7071: oks_k_lines_v oks

7067: oks.allow_bt_discount allow_bt_discount,
7068: oks.apply_default_timezone apply_default_timezone,
7069: oks.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7070: FROM okc_k_lines_b lines1,
7071: oks_k_lines_v oks
7072: WHERE lines1.cle_id = p_cle_id
7073: AND oks.cle_id = lines1.id
7074: AND lines1.lse_id IN (4,17,22)
7075: ORDER BY lines1.line_number,lines1.start_date, lines1.end_date;

Line 9397: Select id,dnz_chr_id,cle_id,sfwt_flag,object_version_number from OKS_K_LINES_V

9393: AND ACTION_TYPE_CODE IN ('RCN', 'RSN');
9394:
9395:
9396: Cursor cur_oks_id (p_id NUMBER) IS
9397: Select id,dnz_chr_id,cle_id,sfwt_flag,object_version_number from OKS_K_LINES_V
9398: where cle_id = p_id;
9399:
9400:
9401: