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 OKC_K_LINES_B

Line 50: ,Okc_K_Lines_B SV

46: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
47: ,okscov.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
48: ,okscov.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists
49: FROM Okc_K_Headers_B HD
50: ,Okc_K_Lines_B SV
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

Line 51: ,Okc_K_Lines_B CL

47: ,okscov.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
48: ,okscov.pm_sch_exists_yn PM_Schedule_Exists --rul.rule_information2 PM_Schedule_Exists
49: FROM Okc_K_Headers_B HD
50: ,Okc_K_Lines_B SV
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

Line 92: ,Okc_K_Lines_B BPL

88: AND (Cx_BP_Id IS NULL
89: OR
90: EXISTS (SELECT '*'
91: FROM Okc_K_Items ITM
92: ,Okc_K_Lines_B BPL
93: ,Okc_K_Lines_B CV
94: WHERE CV.Cle_Id = SV.Id
95: AND CV.Lse_Id IN (2,15,20)
96: AND BPL.Cle_Id = CV.Id

Line 93: ,Okc_K_Lines_B CV

89: OR
90: EXISTS (SELECT '*'
91: FROM Okc_K_Items ITM
92: ,Okc_K_Lines_B BPL
93: ,Okc_K_Lines_B CV
94: WHERE CV.Cle_Id = SV.Id
95: AND CV.Lse_Id IN (2,15,20)
96: AND BPL.Cle_Id = CV.Id
97: AND ITM.Cle_Id = BPL.Id

Line 129: ,Okc_K_Lines_B SV

125: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
126: ,okssrv.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
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

Line 130: ,Okc_K_Lines_B CL

126: ,okssrv.pm_program_id PM_Program_Id --rul.object1_id1 PM_Program_Id
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

Line 161: ,Okc_K_Lines_B BPL

157: AND (Cx_BP_Id IS NULL
158: OR
159: EXISTS (SELECT '*'
160: FROM Okc_K_Items ITM
161: ,Okc_K_Lines_B BPL
162: WHERE BPL.Cle_Id = OKSSRV.Coverage_ID
163: AND BPL.Lse_Id IN (3,16,21)
164: AND ITM.Cle_Id = BPL.Id
165: AND ITM.Object1_Id1 = TO_CHAR(Cx_BP_Id)

Line 184: OKC_K_lines_b cov,

180: okscov.pm_program_id PROGRAM_ID, --pma.object3_id1 PROGRAM_ID,
181: pmact.activity_id ACTIVITY_ID, --pma.object1_id1 ACTIVITY_ID,
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,

Line 217: OKC_K_lines_b srv,

213: okssrv.pm_program_id PROGRAM_ID,
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)

Line 484: FROM Okc_K_lines_B

480: IS
481:
482: CURSOR Lx_SrvLine(Cx_SrvLine_Id IN Gx_OKS_Id) IS
483: SELECT Dnz_Chr_Id
484: FROM Okc_K_lines_B
485: WHERE Id = Cx_SrvLine_Id;
486:
487: Lx_Inp_Rec CONSTANT OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02 := P_Inp_Rec;
488: Lx_Return_Status Gx_Ret_Sts DEFAULT G_RET_STS_SUCCESS;

Line 766: FROM Okc_K_lines_B cov,

762: sch.SCHEDULE_DATE,
763: sch.SCHEDULE_DATE_FROM,
764: sch.SCHEDULE_DATE_TO,
765: cov.end_date cov_end_date
766: FROM Okc_K_lines_B cov,
767: Oks_PM_Schedules sch,
768: -- rule rearchitecure changes
769: -- okc_rule_groups_b rgp,
770: -- OKC_rules_b pmp

Line 806: FROM Okc_K_lines_B srv,

802: sch.SCHEDULE_DATE,
803: sch.SCHEDULE_DATE_FROM,
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

Line 809: okc_k_lines_b cov

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
813: AND srv.id = sch.cle_id

Line 836: FROM Okc_K_lines_B cov,

832: sch.SCHEDULE_DATE,
833: sch.SCHEDULE_DATE_FROM,
834: sch.SCHEDULE_DATE_TO,
835: cov.end_date cov_end_date
836: FROM Okc_K_lines_B cov,
837: Oks_PM_Schedules sch,
838: -- rule rearchitecure changes
839: -- okc_rule_groups_b rgp,
840: -- OKC_rules_b pma

Line 880: FROM Okc_K_lines_B srv,

876: sch.SCHEDULE_DATE,
877: sch.SCHEDULE_DATE_FROM,
878: sch.SCHEDULE_DATE_TO,
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

Line 881: Okc_K_lines_B cov,

877: sch.SCHEDULE_DATE_FROM,
878: sch.SCHEDULE_DATE_TO,
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

Line 915: FROM Okc_K_lines_B cov,

911: sch.SCHEDULE_DATE,
912: sch.SCHEDULE_DATE_FROM,
913: sch.SCHEDULE_DATE_TO,
914: cov.end_date cov_end_date
915: FROM Okc_K_lines_B cov,
916: Oks_PM_Schedules sch,
917: -- rule rearchitecture changes
918: -- okc_rule_groups_b rgp,
919: -- OKC_rules_b pma

Line 956: FROM Okc_K_lines_B srv,

952: sch.SCHEDULE_DATE,
953: sch.SCHEDULE_DATE_FROM,
954: sch.SCHEDULE_DATE_TO,
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

Line 957: Okc_K_lines_B cov,

953: sch.SCHEDULE_DATE_FROM,
954: sch.SCHEDULE_DATE_TO,
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

Line 979: from Okc_K_lines_B srv,

975: -- Added by Jvorugan for Bug:5357010
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

Line 1223: FROM Okc_K_lines_B cle1,

1219: --
1220: /*
1221: CURSOR Lx_PM_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER) IS
1222: SELECT pm_conf_req_yn PM_ConfReq --Rule_Information1 PM_ConfReq
1223: FROM Okc_K_lines_B cle1,
1224: Okc_K_lines_B cle2,
1225: -- rule rearchitecture changes
1226: -- Okc_Rule_Groups_B rgp,
1227: -- Okc_Rules_B rul

Line 1224: Okc_K_lines_B cle2,

1220: /*
1221: CURSOR Lx_PM_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER) IS
1222: SELECT pm_conf_req_yn PM_ConfReq --Rule_Information1 PM_ConfReq
1223: FROM Okc_K_lines_B cle1,
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

Line 1249: FROM Okc_K_lines_B cle1,

1245: --
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);

Line 1263: FROM Okc_K_lines_B cle1,

1259: --
1260: /*
1261: CURSOR Lx_Act_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER,CX_Activity_Id IN NUMBER) IS
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

Line 1264: Okc_K_lines_B cle2,

1260: /*
1261: CURSOR Lx_Act_ConfReq(Cx_SrvLine_Id IN Gx_OKS_Id,CX_Program_Id IN NUMBER,CX_Activity_Id IN NUMBER) IS
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,

Line 1294: FROM Okc_K_lines_B cle1,

1290: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
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

Line 1382: okc_k_lines_b cle,

1378: /*
1379: CURSOR Lx_PM_exist(Cx_PM_Id IN NUMBER) IS
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

Line 1383: okc_k_lines_b covcle,

1379: CURSOR Lx_PM_exist(Cx_PM_Id IN NUMBER) IS
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

Line 1399: okc_k_lines_b cle,

1395: --
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

Line 1418: okc_k_lines_b cle,

1414: CURSOR Lx_Act_exist(Cx_Act_Id IN NUMBER) IS
1415: select
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

Line 1419: okc_k_lines_b covcle,

1415: select
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

Line 1436: okc_k_lines_b cle,

1432: CURSOR Lx_Act_exist(Cx_Act_Id IN NUMBER) IS
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