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_PM_ACTIVITIES

Line 186: oks_pm_activities pmact,

182: pmact.sch_exists_yn SCHEDULE_EXISTS --pma.rule_information3 SCHEDULE_EXISTS
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

Line 218: oks_pm_activities pmact,

214: pmact.activity_id ACTIVITY_ID,
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

Line 842: oks_pm_activities pmact

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)
846: AND cov.dnz_chr_id = sch.dnz_chr_id

Line 884: oks_pm_activities pmact

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
888: and cov.id = okssrv.coverage_id

Line 921: oks_pm_activities pmact

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)
925: AND cov.dnz_chr_id = sch.dnz_chr_id

Line 960: oks_pm_activities pmact

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
964: and cov.id = okssrv.coverage_id

Line 980: oks_pm_activities pmact

976: cursor check_act_sch_exist(Cx_SrvLine_Id IN Gx_OKS_Id,Cx_Activity_Id IN NUMBER)
977: is
978: select pmact.sch_exists_yn
979: from Okc_K_lines_B srv,
980: oks_pm_activities pmact
981: where srv.id = Cx_SrvLine_Id
982: and srv.lse_id in (1,14,19)
983: and pmact.cle_id = srv.id
984: and pmact.select_yn = 'Y'

Line 1267: oks_pm_activities pmact

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
1271: WHERE cle1.Id = Cx_SrvLine_Id

Line 1296: oks_pm_activities pmact

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)
1300: and pmact.cle_id = cle1.id

Line 1420: oks_pm_activities act,

1416: sts.ste_code
1417: from
1418: okc_k_lines_b cle,
1419: okc_k_lines_b covcle,
1420: oks_pm_activities act,
1421: okc_statuses_b sts
1422: where
1423: cle.id=covcle.cle_id
1424: and cle.sts_code=sts.code

Line 1437: oks_pm_activities act,

1433: select
1434: sts.ste_code
1435: from
1436: okc_k_lines_b cle,
1437: oks_pm_activities act,
1438: okc_statuses_b sts
1439: where
1440: cle.sts_code = sts.code
1441: and cle.id = act.cle_id