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_PM_ENTITLEMENTS_PVT dependencies on OKS_K_LINES_B

Line 55: ,oks_k_lines_b okscov -- 11.5.10 rule rearchitecture changes

51: ,Okc_K_Lines_B CL
52: ,okc_k_lines_v cov
53: -- ,okc_rule_groups_b rgp -- 11.5.10 rule rearchitecture changes
54: -- ,okc_rules_b rul -- 11.5.10 rule rearchitecture changes
55: ,oks_k_lines_b okscov -- 11.5.10 rule rearchitecture changes
56: WHERE sv.id = cov.cle_id
57: -- rule rearchitecture changes
58: and cov.id = okscov.cle_id
59: and okscov.pm_program_id is not null

Line 131: ,oks_k_lines_b okssrv

127: ,okssrv.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists
128: FROM Okc_K_Headers_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
129: ,Okc_K_Lines_B SV
130: ,Okc_K_Lines_B CL
131: ,oks_k_lines_b okssrv
132: WHERE sv.id = okssrv.cle_id
133: and okssrv.pm_program_id is not null
134: AND HD.Id = Cx_Chr_Id
135: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 187: oks_k_lines_b okscov

183: FROM
184: OKC_K_lines_b cov,
185: -- rule rearchitecture changes
186: oks_pm_activities pmact,
187: oks_k_lines_b okscov
188: -- OKC_Rule_Groups_B rgp,
189: -- OKC_rules_b pma
190: -- rule rearchitecture changes
191: WHERE cov.cle_Id = Cx_SrvLine_Id

Line 219: oks_k_lines_b okssrv

215: pmact.sch_exists_yn SCHEDULE_EXISTS
216: FROM
217: OKC_K_lines_b srv,
218: oks_pm_activities pmact,
219: oks_k_lines_b okssrv
220: WHERE srv.Id = Cx_SrvLine_Id
221: AND srv.lse_id in (1,14,19)
222: and srv.id = pmact.cle_id
223: and pmact.select_yn = 'Y'

Line 771: oks_k_lines_b okscov

767: Oks_PM_Schedules sch,
768: -- rule rearchitecure changes
769: -- okc_rule_groups_b rgp,
770: -- OKC_rules_b pmp
771: oks_k_lines_b okscov
772: -- rule rearchitecture changes
773: WHERE cov.cle_Id =Cx_SrvLine_Id --nvl(Cx_SrvLine_Id,cov.cle_Id)
774: AND cov.lse_id in (2,15,20)
775: AND cov.dnz_chr_id = sch.dnz_chr_id

Line 808: oks_k_lines_b okssrv,

804: sch.SCHEDULE_DATE_TO,
805: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
806: FROM Okc_K_lines_B srv,
807: Oks_PM_Schedules sch,
808: oks_k_lines_b okssrv,
809: okc_k_lines_b cov
810: WHERE srv.Id = Cx_SrvLine_Id
811: AND srv.lse_id in (1,14,19)
812: AND srv.dnz_chr_id = sch.dnz_chr_id

Line 841: oks_k_lines_b okscov,

837: Oks_PM_Schedules sch,
838: -- rule rearchitecure changes
839: -- okc_rule_groups_b rgp,
840: -- OKC_rules_b pma
841: oks_k_lines_b okscov,
842: oks_pm_activities pmact
843: -- rule rearchitecture changes
844: WHERE cov.cle_Id =Cx_SrvLine_Id --nvl(Cx_SrvLine_Id,cov.cle_Id)
845: AND cov.lse_id in (2,15,20)

Line 883: oks_k_lines_b okssrv,

879: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
880: FROM Okc_K_lines_B srv,
881: Okc_K_lines_B cov,
882: Oks_PM_Schedules sch,
883: oks_k_lines_b okssrv,
884: oks_pm_activities pmact
885: WHERE srv.Id = Cx_SrvLine_Id
886: AND srv.lse_id in (1,14,19)
887: and okssrv.cle_id = srv.id

Line 920: oks_k_lines_b okscov,

916: Oks_PM_Schedules sch,
917: -- rule rearchitecture changes
918: -- okc_rule_groups_b rgp,
919: -- OKC_rules_b pma
920: oks_k_lines_b okscov,
921: oks_pm_activities pmact
922: -- rule rearchitecture changes
923: WHERE cov.cle_Id =Cx_SrvLine_Id --nvl(Cx_SrvLine_Id,cov.cle_Id)
924: AND cov.lse_id in (2,15,20)

Line 959: oks_k_lines_b okssrv,

955: decode(okssrv.STANDARD_COV_YN,'Y',srv.end_date,cov.end_date) cov_end_date
956: FROM Okc_K_lines_B srv,
957: Okc_K_lines_B cov,
958: Oks_PM_Schedules sch,
959: oks_k_lines_b okssrv,
960: oks_pm_activities pmact
961: WHERE srv.Id = Cx_SrvLine_Id
962: AND srv.lse_id in (1,14,19)
963: and srv.id = okssrv.cle_id

Line 1228: oks_k_lines_b okscov

1224: Okc_K_lines_B cle2,
1225: -- rule rearchitecture changes
1226: -- Okc_Rule_Groups_B rgp,
1227: -- Okc_Rules_B rul
1228: oks_k_lines_b okscov
1229: -- rule rearchitecture changes
1230: WHERE cle1.Id = Cx_SrvLine_Id
1231: AND cle2.cle_Id = cle1.Id
1232: AND cle2.lse_id in (2,15,20)

Line 1250: oks_k_lines_b okssrv

1246:
1247: CURSOR Lx_PM_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER) IS
1248: SELECT pm_conf_req_yn PM_ConfReq --Rule_Information1 PM_ConfReq
1249: FROM Okc_K_lines_B cle1,
1250: oks_k_lines_b okssrv
1251: WHERE cle1.Id = Cx_SrvLine_Id
1252: and okssrv.cle_id = cle1.id
1253: AND okssrv.pm_program_id = nvl(CX_Program_Id,okssrv.pm_program_id);
1254:

Line 1266: oks_k_lines_b okscov,

1262: SELECT pmact.Conf_req_yn Act_ConfReq -- PMA.Rule_Information2 Act_ConfReq
1263: FROM Okc_K_lines_B cle1,
1264: Okc_K_lines_B cle2,
1265: -- rule rearchitecture changes
1266: oks_k_lines_b okscov,
1267: oks_pm_activities pmact
1268: -- Okc_Rule_Groups_B rgp,
1269: -- Okc_Rules_B pma
1270: -- rule rearchitecture changes

Line 1295: oks_k_lines_b okssrv,

1291: --
1292: CURSOR Lx_Act_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER,CX_Activity_Id IN NUMBER) IS
1293: SELECT pmact.Conf_req_yn Act_ConfReq -- PMA.Rule_Information2 Act_ConfReq
1294: FROM Okc_K_lines_B cle1,
1295: oks_k_lines_b okssrv,
1296: oks_pm_activities pmact
1297: WHERE cle1.Id = Cx_SrvLine_Id
1298: and okssrv.cle_id = cle1.id
1299: and okssrv.pm_program_id = nvl(CX_Program_Id,okssrv.pm_program_id)

Line 1384: oks_k_lines_b cov,

1380: SELECT sts.ste_code
1381: from
1382: okc_k_lines_b cle,
1383: okc_k_lines_b covcle,
1384: oks_k_lines_b cov,
1385: okc_statuses_b sts
1386: where
1387: cle.id=covcle.cle_id
1388: and covcle.id=cov.cle_id

Line 1400: oks_k_lines_b ksl,

1396: CURSOR Lx_PM_exist(Cx_PM_Id IN NUMBER) IS
1397: SELECT sts.ste_code
1398: from
1399: okc_k_lines_b cle,
1400: oks_k_lines_b ksl,
1401: okc_statuses_b sts
1402: where
1403: cle.id = ksl.cle_id
1404: and cle.sts_code=sts.code