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 7622: FROM Okx_System_Items_V CI

7618:
7619: CURSOR Lx_Csr_CovItem(Cx_CovItem_Id IN Gx_OKS_Id
7620: ,Cn_Organization_Id IN NUMBER) IS
7621: SELECT '*'
7622: FROM Okx_System_Items_V CI
7623: WHERE CI.Id1 = Cx_CovItem_Id
7624: -- AND CI.Id2 = Cn_Organization_Id -- Bug# 4735542
7625: AND CI.Serviceable_Product_Flag ='Y';
7626: -- AND CI.Organization_Id = Cn_Organization_Id; -- Bug# 4735542

Line 9713: FROM Okx_System_Items_V XI

9709: ,XI.Description
9710: ,SV.Start_Date
9711: ,Get_End_Date_Time(SV.End_Date) End_Date
9712: ,Get_End_Date_Time(SV.Date_Terminated) Date_Terminated
9713: FROM Okx_System_Items_V XI
9714: ,Okc_K_Items IT
9715: ,Okc_K_Lines_B SV
9716: WHERE SV.Id = Cx_SrvLine_Id
9717: AND SV.Lse_Id IN (1,14,19)

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

9723: AND XI.Organization_Id = Cn_Organization_Id;
9724:
9725: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
9726: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
9727: Lv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(240);
9728: Lv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(40);
9729: Ld_Start_Date DATE;
9730: Ld_End_Date DATE;
9731: Ld_Date_Terminated DATE;

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

9724:
9725: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;
9726: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
9727: Lv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(240);
9728: Lv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(40);
9729: Ld_Start_Date DATE;
9730: Ld_End_Date DATE;
9731: Ld_Date_Terminated DATE;
9732: Ld_Eff_End_Date DATE;

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

10198: Lv_Effective_Falg VARCHAR2(1);
10199:
10200: Ld_CovLvl_Eff_End_Date DATE;
10201:
10202: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;
10203: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
10204: Lv_Prof_Srv_Name VARCHAR2(300) ;
10205: Lv_Prof_Srv_Desc VARCHAR2(300);
10206:

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

10199:
10200: Ld_CovLvl_Eff_End_Date DATE;
10201:
10202: Lv_Srv_Name Okx_System_Items_V.Name%TYPE; --VARCHAR2(150) ;
10203: Lv_Srv_Description Okx_System_Items_V.Description%TYPE; --VARCHAR2(1995);
10204: Lv_Prof_Srv_Name VARCHAR2(300) ;
10205: Lv_Prof_Srv_Desc VARCHAR2(300);
10206:
10207: Ld_Srv_Start_Date DATE;

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

11183: Ld_SRV_Eff_End_Date DATE;
11184: Ld_COV_Eff_End_Date DATE;
11185: Ld_CVL_Eff_End_Date DATE;
11186:
11187: Lv_Srv_Name Okx_System_Items_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:

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

11184: Ld_COV_Eff_End_Date DATE;
11185: Ld_CVL_Eff_End_Date DATE;
11186:
11187: Lv_Srv_Name Okx_System_Items_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) ;

Line 12398: FROM Okx_System_Items_V XI

12394: AND PX.Id2 = PR.Object1_Id2 ))
12395: AND (Cv_Service_Item_Id IS NULL
12396: OR
12397: HB.Id IN ( SELECT SV.Chr_Id
12398: FROM Okx_System_Items_V XI
12399: ,Okc_K_Items IT
12400: ,Okc_K_Lines_B SV
12401: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
12402: AND IT.Cle_Id = SV.Id

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

14537: Ld_SRV_Eff_End_Date DATE;
14538: Ld_COV_Eff_End_Date DATE;
14539: Ld_CVL_Eff_End_Date DATE;
14540:
14541: Lv_Srv_Name VARCHAR2(300) ; --Okx_System_Items_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:

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

14538: Ld_COV_Eff_End_Date DATE;
14539: Ld_CVL_Eff_End_Date DATE;
14540:
14541: Lv_Srv_Name VARCHAR2(300) ; --Okx_System_Items_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) ;

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

15569: Ld_SRV_Eff_End_Date DATE;
15570: Ld_COV_Eff_End_Date DATE;
15571: Ld_CVL_Eff_End_Date DATE;
15572:
15573: Lv_Srv_Name Okx_System_Items_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:

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

15570: Ld_COV_Eff_End_Date DATE;
15571: Ld_CVL_Eff_End_Date DATE;
15572:
15573: Lv_Srv_Name Okx_System_Items_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) ;

Line 18346: Okx_System_Items_V sys

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