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_PVT dependencies on OKC_K_LINES_V

Line 9827: -- FROM Okc_K_Lines_V

9823: -- ,Item_Description
9824: -- ,Start_Date
9825: -- ,Get_End_Date_Time(End_Date) End_Date
9826: -- ,Get_End_Date_Time(Date_Terminated) Date_Terminated
9827: -- FROM Okc_K_Lines_V
9828: -- WHERE Cle_Id = Cx_SrvLine_Id
9829: -- AND Lse_Id IN (2,15,20);
9830: --
9831: -- Added for 12.0 Coverage Rearch project (JVARGHES)

Line 9847: ,Okc_K_Lines_V COV

9843: ,Get_End_Date_Time(SVL.End_Date) End_Date
9844: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
9845: FROM Okc_K_Lines_B SVL
9846: ,Oks_K_Lines_B KSL
9847: ,Okc_K_Lines_V COV
9848: WHERE SVL.Id = Cx_SrvLine_Id
9849: AND SVL.Lse_Id in (1,14,19)
9850: AND KSL.Cle_Id = SVL.Id
9851: AND COV.ID = KSL.Coverage_Id

Line 9858: Lv_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(240);

9854:
9855: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
9856: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
9857: Lx_Cov_Id Gx_OKS_Id;
9858: Lv_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(240);
9859: Lv_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
9860: Ld_Start_Date DATE;
9861: Ld_End_Date DATE;
9862: Ld_Date_Terminated DATE;

Line 9859: Lv_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);

9855: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
9856: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
9857: Lx_Cov_Id Gx_OKS_Id;
9858: Lv_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(240);
9859: Lv_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
9860: Ld_Start_Date DATE;
9861: Ld_End_Date DATE;
9862: Ld_Date_Terminated DATE;
9863: Ld_Eff_End_Date DATE;

Line 10213: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;

10209: Ld_Srv_Date_Terminated DATE;
10210: Ld_Srv_Eff_End_Date DATE;
10211:
10212: Lx_Cov_Id Gx_OKS_Id;
10213: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
10214: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10215: Ld_Cov_Start_Date DATE;
10216: Ld_Cov_End_Date DATE;
10217: Ld_Cov_Date_Terminated DATE;

Line 10214: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);

10210: Ld_Srv_Eff_End_Date DATE;
10211:
10212: Lx_Cov_Id Gx_OKS_Id;
10213: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
10214: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10215: Ld_Cov_Start_Date DATE;
10216: Ld_Cov_End_Date DATE;
10217: Ld_Cov_Date_Terminated DATE;
10218: Ld_Cov_Eff_End_Date DATE;

Line 11192: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;

11188: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
11189: Lv_Prof_Srv_Name VARCHAR2(300) ;
11190: Lv_Prof_Srv_Desc VARCHAR2(300);
11191:
11192: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
11193: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
11194:
11195: Lx_React_Durn Gx_ReactDurn;
11196: Lx_React_UOM Gx_ReactUOM;

Line 11193: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);

11189: Lv_Prof_Srv_Name VARCHAR2(300) ;
11190: Lv_Prof_Srv_Desc VARCHAR2(300);
11191:
11192: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
11193: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
11194:
11195: Lx_React_Durn Gx_ReactDurn;
11196: Lx_React_UOM Gx_ReactUOM;
11197: Lv_React_Day VARCHAR2(20);

Line 13289: FROM okc_k_lines_v bp,

13285:
13286:
13287: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
13288: SELECT 'Y'
13289: FROM okc_k_lines_v bp,
13290: okc_k_items cim,
13291: cs_business_processes cbp
13292: WHERE bp.cle_id = p_coverage_id
13293: AND cim.cle_id = bp.id

Line 14454: -- FROM Okc_K_Lines_V

14450: -- ,Id Coverage_Line_Id
14451: -- ,Start_Date CV_Start_Date
14452: -- ,Get_End_Date_Time(End_Date) Cv_End_Date
14453: -- ,Get_End_Date_Time(Date_Terminated) CV_Date_Terminated
14454: -- FROM Okc_K_Lines_V
14455: -- WHERE Cle_Id = Cx_SrvLine_Id
14456: -- AND Lse_Id IN (2,15,20);
14457: --
14458: --

Line 14470: ,Okc_K_Lines_V CVL

14466: ,Get_End_Date_Time(CVL.End_Date) Cv_End_Date
14467: ,Get_End_Date_Time(CVL.Date_Terminated) CV_Date_Terminated
14468: ,KSL.Standard_Cov_YN
14469: FROM OKS_K_LINES_B KSL
14470: ,Okc_K_Lines_V CVL
14471: WHERE KSL.Cle_Id = Cx_SrvLine_Id
14472: AND KSL.Coverage_Id = CVL.Id
14473: AND CVL.Lse_Id IN (2,15,20);
14474:

Line 14546: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;

14542: Lv_Srv_Description VARCHAR2(300) ; --Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
14543: Lv_Prof_Srv_Name VARCHAR2(300) ;
14544: Lv_Prof_Srv_Desc VARCHAR2(300);
14545:
14546: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
14547: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
14548:
14549: Lx_React_Durn Gx_ReactDurn;
14550: Lx_React_UOM Gx_ReactUOM;

Line 14547: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);

14543: Lv_Prof_Srv_Name VARCHAR2(300) ;
14544: Lv_Prof_Srv_Desc VARCHAR2(300);
14545:
14546: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
14547: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
14548:
14549: Lx_React_Durn Gx_ReactDurn;
14550: Lx_React_UOM Gx_ReactUOM;
14551: Lv_React_Day VARCHAR2(20);

Line 15033: -- from okc_k_lines_v lines,

15029: -- lines2.start_date start_date,
15030: -- lines2.end_date end_date,
15031: -- to_number(items.object1_id1) object1_id1 ,
15032: -- lines2.dnz_chr_id
15033: -- from okc_k_lines_v lines,
15034: -- okc_k_lines_v lines2,
15035: -- okc_k_items items,
15036: -- cs_business_processes bp
15037: -- where lines.cle_id = p_line_id

Line 15034: -- okc_k_lines_v lines2,

15030: -- lines2.end_date end_date,
15031: -- to_number(items.object1_id1) object1_id1 ,
15032: -- lines2.dnz_chr_id
15033: -- from okc_k_lines_v lines,
15034: -- okc_k_lines_v lines2,
15035: -- okc_k_items items,
15036: -- cs_business_processes bp
15037: -- where lines.cle_id = p_line_id
15038: -- and lines.id = lines2.cle_id

Line 15072: okc_k_lines_v lines2,

15068: lines.dnz_chr_id,
15069: ksl.Standard_Cov_YN Standard_Cov_YN
15070: from okc_k_lines_b lines,
15071: oks_k_lines_b KSL,
15072: okc_k_lines_v lines2,
15073: okc_k_items items,
15074: cs_business_processes bp
15075: where lines.id = p_line_id
15076: and lines.lse_id in (1,14,19)

Line 15105: okc_k_lines_v lines

15101: select hdr.id id,
15102: hdr.start_date start_date,
15103: hdr.end_date end_date
15104: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
15105: okc_k_lines_v lines
15106: where lines.chr_id = hdr.id
15107: and lines.dnz_chr_id = hdr.id
15108: and lines.id = p_line_id;
15109:

Line 15250: from okc_k_lines_v lines,

15246: items2.object1_id1 bt_object1_id1,
15247: items2.jtot_object1_code jtot_object1_code,
15248: okslines2.discount_amount, -- rul.rule_information2 rule_information2,
15249: okslines2.discount_percent -- rul.rule_information4 rule_information4
15250: from okc_k_lines_v lines,
15251: okc_k_lines_v lines2,
15252: okc_k_items items2,
15253: oks_k_lines_b okslines2
15254: -- okc_rule_groups_b rgp,

Line 15251: okc_k_lines_v lines2,

15247: items2.jtot_object1_code jtot_object1_code,
15248: okslines2.discount_amount, -- rul.rule_information2 rule_information2,
15249: okslines2.discount_percent -- rul.rule_information4 rule_information4
15250: from okc_k_lines_v lines,
15251: okc_k_lines_v lines2,
15252: okc_k_items items2,
15253: oks_k_lines_b okslines2
15254: -- okc_rule_groups_b rgp,
15255: -- okc_rules_b rul

Line 15287: from okc_k_lines_v lines,

15283: oksbsch.SUNDAY_FLAG sunday_flag,
15284: to_number(oksbsch.OBJECT1_ID2) labor_item_org_id,
15285: to_number(oksbsch.OBJECT1_ID1) labor_item_id,
15286: oksbsch.HOLIDAY_YN holiday_yn
15287: from okc_k_lines_v lines,
15288: okc_k_lines_v lines2,
15289: oks_billrate_schedules oksbsch
15290: -- okc_rule_groups_v rgp,
15291: -- okc_rules_b rules

Line 15288: okc_k_lines_v lines2,

15284: to_number(oksbsch.OBJECT1_ID2) labor_item_org_id,
15285: to_number(oksbsch.OBJECT1_ID1) labor_item_id,
15286: oksbsch.HOLIDAY_YN holiday_yn
15287: from okc_k_lines_v lines,
15288: okc_k_lines_v lines2,
15289: oks_billrate_schedules oksbsch
15290: -- okc_rule_groups_v rgp,
15291: -- okc_rules_b rules
15292: where lines.id = p_bill_type_id

Line 15578: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;

15574: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
15575: Lv_Prof_Srv_Name VARCHAR2(300) ;
15576: Lv_Prof_Srv_Desc VARCHAR2(300);
15577:
15578: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
15579: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
15580:
15581: Lx_React_Durn Gx_ReactDurn;
15582: Lx_React_UOM Gx_ReactUOM;

Line 15579: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);

15575: Lv_Prof_Srv_Name VARCHAR2(300) ;
15576: Lv_Prof_Srv_Desc VARCHAR2(300);
15577:
15578: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
15579: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
15580:
15581: Lx_React_Durn Gx_ReactDurn;
15582: Lx_React_UOM Gx_ReactUOM;
15583: Lv_React_Day VARCHAR2(20);

Line 18341: OKC_K_LINES_V Sv,

18337: trunc(Cov.End_Date) Cov_End_Date,
18338: trunc(Cov.Date_Terminated) Cov_Date_Terminated,
18339: Sv.Lse_Id Service_Lse_Id
18340: FROM OKC_K_HEADERS_V HD,
18341: OKC_K_LINES_V Sv,
18342: OKC_K_LINES_V Cov,
18343: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18344: OKC_K_LINES_V Clv,
18345: OKC_K_ITEMS items,

Line 18342: OKC_K_LINES_V Cov,

18338: trunc(Cov.Date_Terminated) Cov_Date_Terminated,
18339: Sv.Lse_Id Service_Lse_Id
18340: FROM OKC_K_HEADERS_V HD,
18341: OKC_K_LINES_V Sv,
18342: OKC_K_LINES_V Cov,
18343: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18344: OKC_K_LINES_V Clv,
18345: OKC_K_ITEMS items,
18346: Okx_System_Items_V sys

Line 18344: OKC_K_LINES_V Clv,

18340: FROM OKC_K_HEADERS_V HD,
18341: OKC_K_LINES_V Sv,
18342: OKC_K_LINES_V Cov,
18343: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18344: OKC_K_LINES_V Clv,
18345: OKC_K_ITEMS items,
18346: Okx_System_Items_V sys
18347: WHERE Hd.Id = Sv.chr_id
18348: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 18431: OKC_K_LINES_V Cov,

18427: Sv.Lse_Id Service_Lse_Id
18428: FROM OKC_K_HEADERS_ALL_B HD,
18429: OKC_K_HEADERS_TL HDT, /*bug 7412576 OKC_K_HEADERS_V HD,*/
18430: OKC_K_LINES_B Sv,
18431: OKC_K_LINES_V Cov,
18432: oks_k_lines_b ksl,
18433: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18434: OKC_K_LINES_B Clv,
18435: OKC_K_ITEMS items,

Line 18522: OKC_K_LINES_V Cov,

18518: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
18519: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
18520: OKC_K_LINES_B Sv,
18521: OKS_K_LINES_B KSL,
18522: OKC_K_LINES_V Cov,
18523: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18524: OKC_K_LINES_B Clv,
18525: OKC_K_ITEMS items,
18526: MTL_SYSTEM_ITEMS_B_KFV sys

Line 18611: OKC_K_LINES_V Cov,

18607: FROM OKC_K_HEADERS_ALL_B HD,
18608: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18609: OKC_K_LINES_B Sv,
18610: OKS_K_LINES_B KSL,
18611: OKC_K_LINES_V Cov,
18612: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
18613: OKC_K_ITEMS items,
18614: MTL_SYSTEM_ITEMS_B_KFV sys
18615: WHERE Hd.Id = Sv.chr_id

Line 18695: OKC_K_LINES_V Cov,

18691: FROM OKC_K_HEADERS_ALL_B HD,
18692: OKC_K_HEADERS_TL HDT,/*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18693: OKC_K_LINES_B Sv,
18694: OKS_K_LINES_B KSL,
18695: OKC_K_LINES_V Cov,
18696: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18697: OKC_K_ITEMS items,
18698: MTL_SYSTEM_ITEMS_B_KFV sys
18699: WHERE Hd.Id = Sv.chr_id

Line 18775: OKC_K_LINES_V Cov,

18771: Sv.Lse_Id Service_Lse_Id
18772: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
18773: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
18774: OKC_K_LINES_B Sv,
18775: OKC_K_LINES_V Cov,
18776: oks_k_lines_b ksl,
18777: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18778: OKC_K_ITEMS items,
18779: MTL_SYSTEM_ITEMS_B_KFV sys

Line 18862: OKC_K_LINES_V Cov,

18858: Sv.Lse_Id Service_Lse_Id
18859: FROM OKC_K_HEADERS_ALL_B HD,
18860: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18861: OKC_K_LINES_B Sv,
18862: OKC_K_LINES_V Cov,
18863: oks_k_lines_b ksl,
18864: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18865: OKC_K_ITEMS items,
18866: MTL_SYSTEM_ITEMS_B_KFV sys