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 OKX_SYSTEM_ITEMS_V

Line 8010: FROM Okx_System_Items_V CI

8006:
8007: CURSOR Lx_Csr_CovItem(Cx_CovItem_Id IN Gx_OKS_Id
8008: ,Cn_Organization_Id IN NUMBER) IS
8009: SELECT '*'
8010: FROM Okx_System_Items_V CI
8011: WHERE CI.Id1 = Cx_CovItem_Id
8012: -- AND CI.Id2 = Cn_Organization_Id -- Bug# 4735542
8013: AND CI.Serviceable_Product_Flag ='Y';
8014: -- AND CI.Organization_Id = Cn_Organization_Id; -- Bug# 4735542

Line 10144: FROM Okx_System_Items_V XI

10140: ,XI.Description
10141: ,SV.Start_Date
10142: ,Get_End_Date_Time(SV.End_Date) End_Date
10143: ,Get_End_Date_Time(SV.Date_Terminated) Date_Terminated
10144: FROM Okx_System_Items_V XI
10145: ,Okc_K_Items IT
10146: ,Okc_K_Lines_B SV
10147: WHERE SV.Id = Cx_SrvLine_Id
10148: AND SV.Lse_Id IN (1,14,19)

Line 10158: Lv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(240);

10154: AND XI.Organization_Id = Cn_Organization_Id;
10155:
10156: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
10157: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
10158: Lv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(240);
10159: Lv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(40);
10160: Ld_Start_Date DATE;
10161: Ld_End_Date DATE;
10162: Ld_Date_Terminated DATE;

Line 10159: Lv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(40);

10155:
10156: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
10157: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
10158: Lv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(240);
10159: Lv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(40);
10160: Ld_Start_Date DATE;
10161: Ld_End_Date DATE;
10162: Ld_Date_Terminated DATE;
10163: Ld_Eff_End_Date DATE;

Line 10678: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;

10674: Lv_Effective_Falg VARCHAR2(1);
10675:
10676: Ld_CovLvl_Eff_End_Date DATE;
10677:
10678: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;
10679: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
10680: Lv_Prof_Srv_Name VARCHAR2(300) ;
10681: Lv_Prof_Srv_Desc VARCHAR2(300);
10682:

Line 10679: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);

10675:
10676: Ld_CovLvl_Eff_End_Date DATE;
10677:
10678: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;
10679: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
10680: Lv_Prof_Srv_Name VARCHAR2(300) ;
10681: Lv_Prof_Srv_Desc VARCHAR2(300);
10682:
10683: Ld_Srv_Start_Date DATE;

Line 12022: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;

12018: Ld_SRV_Eff_End_Date DATE;
12019: Ld_COV_Eff_End_Date DATE;
12020: Ld_CVL_Eff_End_Date DATE;
12021:
12022: Lv_Srv_Name Okx_System_Items_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:

Line 12023: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);

12019: Ld_COV_Eff_End_Date DATE;
12020: Ld_CVL_Eff_End_Date DATE;
12021:
12022: Lv_Srv_Name Okx_System_Items_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) ;

Line 13649: FROM Okx_System_Items_V XI

13645: AND PX.Id2 = PR.Object1_Id2 ))
13646: AND (Cv_Service_Item_Id IS NULL
13647: OR
13648: HB.Id IN ( SELECT SV.Chr_Id
13649: FROM Okx_System_Items_V XI
13650: ,Okc_K_Items IT
13651: ,Okc_K_Lines_B SV
13652: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
13653: AND IT.Cle_Id = SV.Id

Line 13696: FROM Okx_System_Items_V XI

13692: AND PX.Id2 = PR.Object1_Id2 ))
13693: AND (Cv_Service_Item_Id IS NULL
13694: OR
13695: HB.Id IN ( SELECT SV.Chr_Id
13696: FROM Okx_System_Items_V XI
13697: ,Okc_K_Items IT
13698: ,Okc_K_Lines_B SV
13699: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
13700: AND IT.Cle_Id = SV.Id

Line 15908: Lv_Srv_Name VARCHAR2(300) ; --Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;

15904: Ld_SRV_Eff_End_Date DATE;
15905: Ld_COV_Eff_End_Date DATE;
15906: Ld_CVL_Eff_End_Date DATE;
15907:
15908: Lv_Srv_Name VARCHAR2(300) ; --Okx_System_Items_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:

Line 15909: Lv_Srv_Description VARCHAR2(300) ; --Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);

15905: Ld_COV_Eff_End_Date DATE;
15906: Ld_CVL_Eff_End_Date DATE;
15907:
15908: Lv_Srv_Name VARCHAR2(300) ; --Okx_System_Items_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) ;

Line 17163: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;

17159: Ld_SRV_Eff_End_Date DATE;
17160: Ld_COV_Eff_End_Date DATE;
17161: Ld_CVL_Eff_End_Date DATE;
17162:
17163: Lv_Srv_Name Okx_System_Items_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:

Line 17164: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);

17160: Ld_COV_Eff_End_Date DATE;
17161: Ld_CVL_Eff_End_Date DATE;
17162:
17163: Lv_Srv_Name Okx_System_Items_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) ;

Line 20634: Okx_System_Items_V sys

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)
20637: and hd.authoring_org_id = nvl(p_authoring_org_id,hd.authoring_org_id) -- multi org security check
20638: AND Sv.lse_id in (1,14,19)