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 10258: -- FROM Okc_K_Lines_V

10254: -- ,Item_Description
10255: -- ,Start_Date
10256: -- ,Get_End_Date_Time(End_Date) End_Date
10257: -- ,Get_End_Date_Time(Date_Terminated) Date_Terminated
10258: -- FROM Okc_K_Lines_V
10259: -- WHERE Cle_Id = Cx_SrvLine_Id
10260: -- AND Lse_Id IN (2,15,20);
10261: --
10262: -- Added for 12.0 Coverage Rearch project (JVARGHES)

Line 10278: ,Okc_K_Lines_V COV

10274: ,Get_End_Date_Time(SVL.End_Date) End_Date
10275: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
10276: FROM Okc_K_Lines_B SVL
10277: ,Oks_K_Lines_B KSL
10278: ,Okc_K_Lines_V COV
10279: WHERE SVL.Id = Cx_SrvLine_Id
10280: AND SVL.Lse_Id in (1,14,19)
10281: AND KSL.Cle_Id = SVL.Id
10282: AND COV.ID = KSL.Coverage_Id

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

10285:
10286: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
10287: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
10288: Lx_Cov_Id Gx_OKS_Id;
10289: Lv_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(240);
10290: Lv_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10291: Ld_Start_Date DATE;
10292: Ld_End_Date DATE;
10293: Ld_Date_Terminated DATE;

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

10286: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
10287: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
10288: Lx_Cov_Id Gx_OKS_Id;
10289: Lv_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(240);
10290: Lv_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10291: Ld_Start_Date DATE;
10292: Ld_End_Date DATE;
10293: Ld_Date_Terminated DATE;
10294: Ld_Eff_End_Date DATE;

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

10685: Ld_Srv_Date_Terminated DATE;
10686: Ld_Srv_Eff_End_Date DATE;
10687:
10688: Lx_Cov_Id Gx_OKS_Id;
10689: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
10690: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10691: Ld_Cov_Start_Date DATE;
10692: Ld_Cov_End_Date DATE;
10693: Ld_Cov_Date_Terminated DATE;

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

10686: Ld_Srv_Eff_End_Date DATE;
10687:
10688: Lx_Cov_Id Gx_OKS_Id;
10689: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
10690: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
10691: Ld_Cov_Start_Date DATE;
10692: Ld_Cov_End_Date DATE;
10693: Ld_Cov_Date_Terminated DATE;
10694: Ld_Cov_Eff_End_Date DATE;

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

12023: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
12024: Lv_Prof_Srv_Name VARCHAR2(300) ;
12025: Lv_Prof_Srv_Desc VARCHAR2(300);
12026:
12027: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
12028: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
12029:
12030: Lx_React_Durn Gx_ReactDurn;
12031: Lx_React_UOM Gx_ReactUOM;

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

12024: Lv_Prof_Srv_Name VARCHAR2(300) ;
12025: Lv_Prof_Srv_Desc VARCHAR2(300);
12026:
12027: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
12028: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
12029:
12030: Lx_React_Durn Gx_ReactDurn;
12031: Lx_React_UOM Gx_ReactUOM;
12032: Lv_React_Day VARCHAR2(20);

Line 14647: FROM okc_k_lines_v bp,

14643:
14644:
14645: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
14646: SELECT 'Y'
14647: FROM okc_k_lines_v bp,
14648: okc_k_items cim,
14649: cs_business_processes cbp
14650: WHERE bp.cle_id = p_coverage_id
14651: AND cim.cle_id = bp.id

Line 15816: -- FROM Okc_K_Lines_V

15812: -- ,Id Coverage_Line_Id
15813: -- ,Start_Date CV_Start_Date
15814: -- ,Get_End_Date_Time(End_Date) Cv_End_Date
15815: -- ,Get_End_Date_Time(Date_Terminated) CV_Date_Terminated
15816: -- FROM Okc_K_Lines_V
15817: -- WHERE Cle_Id = Cx_SrvLine_Id
15818: -- AND Lse_Id IN (2,15,20);
15819: --
15820: --

Line 15832: ,Okc_K_Lines_V CVL

15828: ,Get_End_Date_Time(CVL.End_Date) Cv_End_Date
15829: ,Get_End_Date_Time(CVL.Date_Terminated) CV_Date_Terminated
15830: ,KSL.Standard_Cov_YN
15831: FROM OKS_K_LINES_B KSL
15832: ,Okc_K_Lines_V CVL
15833: WHERE KSL.Cle_Id = Cx_SrvLine_Id
15834: AND KSL.Coverage_Id = CVL.Id
15835: AND CVL.Lse_Id IN (2,15,20);
15836:

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

15909: Lv_Srv_Description VARCHAR2(300) ; --Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
15910: Lv_Prof_Srv_Name VARCHAR2(300) ;
15911: Lv_Prof_Srv_Desc VARCHAR2(300);
15912:
15913: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
15914: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
15915:
15916: Lx_React_Durn Gx_ReactDurn;
15917: Lx_React_UOM Gx_ReactUOM;

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

15910: Lv_Prof_Srv_Name VARCHAR2(300) ;
15911: Lv_Prof_Srv_Desc VARCHAR2(300);
15912:
15913: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
15914: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
15915:
15916: Lx_React_Durn Gx_ReactDurn;
15917: Lx_React_UOM Gx_ReactUOM;
15918: Lv_React_Day VARCHAR2(20);

Line 16436: -- from okc_k_lines_v lines,

16432: -- lines2.start_date start_date,
16433: -- lines2.end_date end_date,
16434: -- to_number(items.object1_id1) object1_id1 ,
16435: -- lines2.dnz_chr_id
16436: -- from okc_k_lines_v lines,
16437: -- okc_k_lines_v lines2,
16438: -- okc_k_items items,
16439: -- cs_business_processes bp
16440: -- where lines.cle_id = p_line_id

Line 16437: -- okc_k_lines_v lines2,

16433: -- lines2.end_date end_date,
16434: -- to_number(items.object1_id1) object1_id1 ,
16435: -- lines2.dnz_chr_id
16436: -- from okc_k_lines_v lines,
16437: -- okc_k_lines_v lines2,
16438: -- okc_k_items items,
16439: -- cs_business_processes bp
16440: -- where lines.cle_id = p_line_id
16441: -- and lines.id = lines2.cle_id

Line 16475: okc_k_lines_v lines2,

16471: lines.dnz_chr_id,
16472: ksl.Standard_Cov_YN Standard_Cov_YN
16473: from okc_k_lines_b lines,
16474: oks_k_lines_b KSL,
16475: okc_k_lines_v lines2,
16476: okc_k_items items,
16477: cs_business_processes bp
16478: where lines.id = p_line_id
16479: and lines.lse_id in (1,14,19)

Line 16508: okc_k_lines_v lines

16504: select hdr.id id,
16505: hdr.start_date start_date,
16506: hdr.end_date end_date
16507: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
16508: okc_k_lines_v lines
16509: where lines.chr_id = hdr.id
16510: and lines.dnz_chr_id = hdr.id
16511: and lines.id = p_line_id;
16512:

Line 16653: from okc_k_lines_v lines,

16649: items2.object1_id1 bt_object1_id1,
16650: items2.jtot_object1_code jtot_object1_code,
16651: okslines2.discount_amount, -- rul.rule_information2 rule_information2,
16652: okslines2.discount_percent -- rul.rule_information4 rule_information4
16653: from okc_k_lines_v lines,
16654: okc_k_lines_v lines2,
16655: okc_k_items items2,
16656: oks_k_lines_b okslines2
16657: -- okc_rule_groups_b rgp,

Line 16654: okc_k_lines_v lines2,

16650: items2.jtot_object1_code jtot_object1_code,
16651: okslines2.discount_amount, -- rul.rule_information2 rule_information2,
16652: okslines2.discount_percent -- rul.rule_information4 rule_information4
16653: from okc_k_lines_v lines,
16654: okc_k_lines_v lines2,
16655: okc_k_items items2,
16656: oks_k_lines_b okslines2
16657: -- okc_rule_groups_b rgp,
16658: -- okc_rules_b rul

Line 16690: from okc_k_lines_v lines,

16686: oksbsch.SUNDAY_FLAG sunday_flag,
16687: to_number(oksbsch.OBJECT1_ID2) labor_item_org_id,
16688: to_number(oksbsch.OBJECT1_ID1) labor_item_id,
16689: oksbsch.HOLIDAY_YN holiday_yn
16690: from okc_k_lines_v lines,
16691: okc_k_lines_v lines2,
16692: oks_billrate_schedules oksbsch
16693: -- okc_rule_groups_v rgp,
16694: -- okc_rules_b rules

Line 16691: okc_k_lines_v lines2,

16687: to_number(oksbsch.OBJECT1_ID2) labor_item_org_id,
16688: to_number(oksbsch.OBJECT1_ID1) labor_item_id,
16689: oksbsch.HOLIDAY_YN holiday_yn
16690: from okc_k_lines_v lines,
16691: okc_k_lines_v lines2,
16692: oks_billrate_schedules oksbsch
16693: -- okc_rule_groups_v rgp,
16694: -- okc_rules_b rules
16695: where lines.id = p_bill_type_id

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

17164: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
17165: Lv_Prof_Srv_Name VARCHAR2(300) ;
17166: Lv_Prof_Srv_Desc VARCHAR2(300);
17167:
17168: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
17169: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
17170:
17171: Lx_React_Durn Gx_ReactDurn;
17172: Lx_React_UOM Gx_ReactUOM;

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

17165: Lv_Prof_Srv_Name VARCHAR2(300) ;
17166: Lv_Prof_Srv_Desc VARCHAR2(300);
17167:
17168: Lv_Cov_Name Okc_K_Lines_V.Name%TYPE; --VARCHAR2(150) ;
17169: Lv_Cov_Description Okc_K_Lines_V.Item_Description%TYPE; --VARCHAR2(1995);
17170:
17171: Lx_React_Durn Gx_ReactDurn;
17172: Lx_React_UOM Gx_ReactUOM;
17173: Lv_React_Day VARCHAR2(20);

Line 20629: OKC_K_LINES_V Sv,

20625: trunc(Cov.End_Date) Cov_End_Date,
20626: trunc(Cov.Date_Terminated) Cov_Date_Terminated,
20627: Sv.Lse_Id Service_Lse_Id
20628: FROM OKC_K_HEADERS_V HD,
20629: OKC_K_LINES_V Sv,
20630: OKC_K_LINES_V Cov,
20631: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20632: OKC_K_LINES_V Clv,
20633: OKC_K_ITEMS items,

Line 20630: OKC_K_LINES_V Cov,

20626: trunc(Cov.Date_Terminated) Cov_Date_Terminated,
20627: Sv.Lse_Id Service_Lse_Id
20628: FROM OKC_K_HEADERS_V HD,
20629: OKC_K_LINES_V Sv,
20630: OKC_K_LINES_V Cov,
20631: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20632: OKC_K_LINES_V Clv,
20633: OKC_K_ITEMS items,
20634: Okx_System_Items_V sys

Line 20632: OKC_K_LINES_V Clv,

20628: FROM OKC_K_HEADERS_V HD,
20629: OKC_K_LINES_V Sv,
20630: OKC_K_LINES_V Cov,
20631: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20632: OKC_K_LINES_V Clv,
20633: OKC_K_ITEMS items,
20634: Okx_System_Items_V sys
20635: WHERE Hd.Id = Sv.chr_id
20636: AND Hd.Id = nvl(P_Id,Hd.Id)

Line 20719: OKC_K_LINES_V Cov,

20715: Sv.Lse_Id Service_Lse_Id
20716: FROM OKC_K_HEADERS_ALL_B HD,
20717: OKC_K_HEADERS_TL HDT, /*bug 7412576 OKC_K_HEADERS_V HD,*/
20718: OKC_K_LINES_B Sv,
20719: OKC_K_LINES_V Cov,
20720: oks_k_lines_b ksl,
20721: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20722: OKC_K_LINES_B Clv,
20723: OKC_K_ITEMS items,

Line 20810: OKC_K_LINES_V Cov,

20806: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
20807: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
20808: OKC_K_LINES_B Sv,
20809: OKS_K_LINES_B KSL,
20810: OKC_K_LINES_V Cov,
20811: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20812: OKC_K_LINES_B Clv,
20813: OKC_K_ITEMS items,
20814: MTL_SYSTEM_ITEMS_B_KFV sys

Line 20899: OKC_K_LINES_V Cov,

20895: FROM OKC_K_HEADERS_ALL_B HD,
20896: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
20897: OKC_K_LINES_B Sv,
20898: OKS_K_LINES_B KSL,
20899: OKC_K_LINES_V Cov,
20900: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
20901: OKC_K_ITEMS items,
20902: MTL_SYSTEM_ITEMS_B_KFV sys
20903: WHERE Hd.Id = Sv.chr_id

Line 20983: OKC_K_LINES_V Cov,

20979: FROM OKC_K_HEADERS_ALL_B HD,
20980: OKC_K_HEADERS_TL HDT,/*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
20981: OKC_K_LINES_B Sv,
20982: OKS_K_LINES_B KSL,
20983: OKC_K_LINES_V Cov,
20984: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20985: OKC_K_ITEMS items,
20986: MTL_SYSTEM_ITEMS_B_KFV sys
20987: WHERE Hd.Id = Sv.chr_id

Line 21127: OKC_K_LINES_V Cov,

21123: Sv.Lse_Id Service_Lse_Id
21124: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
21125: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
21126: OKC_K_LINES_B Sv,
21127: OKC_K_LINES_V Cov,
21128: oks_k_lines_b ksl,
21129: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21130: OKC_K_ITEMS items,
21131: MTL_SYSTEM_ITEMS_B_KFV sys

Line 21214: OKC_K_LINES_V Cov,

21210: Sv.Lse_Id Service_Lse_Id
21211: FROM OKC_K_HEADERS_ALL_B HD,
21212: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
21213: OKC_K_LINES_B Sv,
21214: OKC_K_LINES_V Cov,
21215: oks_k_lines_b ksl,
21216: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21217: OKC_K_ITEMS items,
21218: MTL_SYSTEM_ITEMS_B_KFV sys