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_PROGRAMS_PVT dependencies on OKC_K_LINES_B

Line 1274: okc_k_lines_b

1270: CURSOR CU_ORIG_COV_ID IS
1271: SELECT
1272: orig_system_id1 id
1273: FROM
1274: okc_k_lines_b
1275: WHERE
1276: id=p_contract_line_id;
1277: -- AND lse_id IN (2,15,20); commented by jvorugan as pm is associated with contract line
1278: cr_orig_cov_id cu_orig_cov_id%ROWTYPE;

Line 1284: FROM OKC_K_LINES_B

1280: CURSOR Cur_NewCovDet IS
1281: SELECT ID,
1282: START_DATE , --COV.START_DATE START_DATE,
1283: END_DATE --COV.END_DATE END_DATE,
1284: FROM OKC_K_LINES_B
1285: WHERE id=p_contract_line_id;
1286: -- AND lse_id IN (2,15,20); commented by jvorugan as pm is associated with contract line
1287:
1288: NewCovDet_Rec Cur_NewCovDet%ROWTYPE;

Line 1644: from okc_k_lines_b

1640: IS
1641:
1642: CURSOR CU_CLE_ID is
1643: select id
1644: from okc_k_lines_b
1645: where id=p_contract_line_id;
1646: -- and lse_id in (2,15,20); commented by jvorugan as pm is associated with contract line
1647: CR_CLE_ID CU_CLE_ID%ROWTYPE;
1648: --not used

Line 1664: WHERE CLE_ID=(select id from okc_k_lines_b where cle_id=p_contract_line_id

1660: ACTIVITY_LINE_ID,
1661: CLE_ID
1662: DNZ_CHR_ID
1663: FROM OKS_PM_STREAM_LEVELS_V PML
1664: WHERE CLE_ID=(select id from okc_k_lines_b where cle_id=p_contract_line_id
1665: and lse_id in (2,15,20));
1666:
1667: CR_STREAM_LEVELS CU_STREAM_LEVELS%ROWTYPE;*/
1668:

Line 1673: FROM OKC_K_LINES_B

1669: CURSOR CU_NewCovDet IS
1670: SELECT ID,
1671: START_DATE, --COV.START_DATE START_DATE,
1672: END_DATE --COV.END_DATE END_DATE,
1673: FROM OKC_K_LINES_B
1674: WHERE ID = p_contract_line_id;
1675: -- and lse_id in (2,15,20); commented by jvorugan as pm is associated with contract line
1676:
1677: CR_NewCovDet Cu_NewCovDet%ROWTYPE;

Line 1733: WHERE CLE_ID =(select id from okc_k_lines_b where cle_id=p_contract_line_id

1729: PROGRAM_ID ,
1730: PROGRAM_UPDATE_DATE,
1731: REQUEST_ID
1732: FROM OKS_PM_SCHEDULES
1733: WHERE CLE_ID =(select id from okc_k_lines_b where cle_id=p_contract_line_id
1734: and lse_id in (2,15,20))
1735: order by nvl(schedule_date,schedule_date_from);*/
1736:
1737: CURSOR Cu_PMSch_PMPPML IS

Line 1762: WHERE CLE_ID= p_contract_line_id --(select id from okc_k_lines_b where cle_id=p_contract_line_id

1758: PROGRAM_ID ,
1759: PROGRAM_UPDATE_DATE,
1760: REQUEST_ID
1761: FROM OKS_PM_SCHEDULES
1762: WHERE CLE_ID= p_contract_line_id --(select id from okc_k_lines_b where cle_id=p_contract_line_id
1763: --and lse_id in (2,15,20)) commented by jvorugan as pm is associated with contract line
1764: and ACTIVITY_LINE_ID is null
1765: order by nvl(schedule_date,schedule_date_from);
1766:

Line 1798: WHERE CLE_ID= p_contract_line_id;--(select id from okc_k_lines_b where cle_id=p_contract_line_id

1794: --CK RUL REVISIT THIS
1795: CURSOR CU_PROGRAM IS
1796: SELECT id,'PMP' TYPE
1797: FROM OKS_K_LINES_B
1798: WHERE CLE_ID= p_contract_line_id;--(select id from okc_k_lines_b where cle_id=p_contract_line_id
1799: -- and lse_id in (2,15,20)); commented by jvorugan as pm is associated with contract line
1800:
1801: CR_PROGRAM CU_PROGRAM%ROWTYPE;
1802:

Line 4337: OKC_K_LINES_B srvcle,

4333: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4334: SELECT srvcle.id
4335: , srvcle.line_number
4336: FROM
4337: OKC_K_LINES_B srvcle,
4338: OKC_K_LINES_B covcle,
4339: OKS_K_LINES_B cov
4340: WHERE
4341: srvcle.chr_id = p_chr_id

Line 4338: OKC_K_LINES_B covcle,

4334: SELECT srvcle.id
4335: , srvcle.line_number
4336: FROM
4337: OKC_K_LINES_B srvcle,
4338: OKC_K_LINES_B covcle,
4339: OKS_K_LINES_B cov
4340: WHERE
4341: srvcle.chr_id = p_chr_id
4342: and srvcle.id=covcle.cle_id

Line 4352: FROM okc_k_lines_b cle,

4348:
4349:
4350: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4351: select 'x' terminate
4352: FROM okc_k_lines_b cle,
4353: oks_k_lines_b pmp,
4354: okx_pm_programs_v opv
4355: WHERE cle.id = pmp.cle_id
4356: and cle.dnz_chr_id = pmp.dnz_chr_id

Line 4365: FROM okc_k_lines_b cle,

4361: l_prog_rec l_prog_csr%ROWTYPE;
4362:
4363: CURSOR l_act_csr(p_cle_id IN NUMBER) IS
4364: select 'x' terminate
4365: FROM okc_k_lines_b cle,
4366: oks_k_lines_b pmp,
4367: oks_pm_activities oksact,
4368: okx_pm_activities_v act
4369: WHERE cle.id = pmp.cle_id

Line 4467: OKC_K_LINES_B srvcle,

4463: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4464: SELECT srvcle.id
4465: , srvcle.line_number
4466: FROM
4467: OKC_K_LINES_B srvcle,
4468: OKC_K_LINES_B covcle,
4469: OKS_K_LINES_B cov
4470: WHERE
4471: srvcle.chr_id = p_chr_id

Line 4468: OKC_K_LINES_B covcle,

4464: SELECT srvcle.id
4465: , srvcle.line_number
4466: FROM
4467: OKC_K_LINES_B srvcle,
4468: OKC_K_LINES_B covcle,
4469: OKS_K_LINES_B cov
4470: WHERE
4471: srvcle.chr_id = p_chr_id
4472: and srvcle.id=covcle.cle_id

Line 4481: FROM okc_k_lines_b cle,

4477: l_cle_rec l_cle_csr%ROWTYPE;
4478:
4479: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4480: select opv.mr_header_id
4481: FROM okc_k_lines_b cle,
4482: oks_k_lines_b pmp,
4483: --okx_pm_programs_v opv
4484: ahl_mr_headers_b opv
4485: WHERE cle.id = pmp.cle_id

Line 4494: FROM okc_k_lines_b cle,

4490: l_prog_rec l_prog_csr%ROWTYPE;
4491:
4492: CURSOR l_act_csr(p_cle_id IN NUMBER) IS
4493: select act.mr_header_id
4494: FROM okc_k_lines_b cle,
4495: oks_k_lines_b pmp,
4496: oks_pm_activities oksact,
4497: ahl_mr_headers_b act
4498: WHERE cle.id = pmp.cle_id

Line 4589: OKC_K_LINES_B srvcle,

4585: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4586: SELECT srvcle.id
4587: , srvcle.line_number
4588: FROM
4589: OKC_K_LINES_B srvcle,
4590: OKC_K_LINES_B covcle,
4591: OKS_K_LINES_B cov
4592: WHERE
4593: srvcle.chr_id = p_chr_id

Line 4590: OKC_K_LINES_B covcle,

4586: SELECT srvcle.id
4587: , srvcle.line_number
4588: FROM
4589: OKC_K_LINES_B srvcle,
4590: OKC_K_LINES_B covcle,
4591: OKS_K_LINES_B cov
4592: WHERE
4593: srvcle.chr_id = p_chr_id
4594: and srvcle.id=covcle.cle_id

Line 4604: OKC_K_LINES_B srvcle,

4600: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4601: SELECT srvcle.id
4602: , srvcle.line_number
4603: FROM
4604: OKC_K_LINES_B srvcle,
4605: OKS_K_LINES_B cov
4606: WHERE
4607: srvcle.chr_id = p_chr_id
4608: and srvcle.id=cov.cle_id

Line 4635: FROM okc_k_lines_b cle,oks_k_lines_b pmp

4631: l_cle_rec l_cle_csr%ROWTYPE;
4632: --not needed
4633: /* CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4634: SELECT pmp.id
4635: FROM okc_k_lines_b cle,oks_k_lines_b pmp
4636: WHERE cle.id = pmp.cle_id
4637: and cle.dnz_chr_id = pmp.dnz_chr_id
4638: and cle.cle_id=p_cle_id
4639: and pmp.pm_program_id is not null;

Line 4647: FROM okc_k_lines_b cle,

4643: /* Modified by Jvorugan for Bug:5215180
4644: CURSOR l_sch_csr(p_cle_id IN NUMBER) IS
4645:
4646: SELECT pms.id
4647: FROM okc_k_lines_b cle,
4648: oks_pm_schedules_v pms
4649: WHERE cle.id = pms.cle_id
4650: and cle.cle_id=p_cle_id
4651: --added condition

Line 4667: FROM okc_k_lines_b cle,

4663: --CK
4664: /* Modified by Jvorugan for Bug:5215180
4665: CURSOR l_act_csr(p_cle_id IN NUMBER) IS
4666: SELECT pma.id
4667: FROM okc_k_lines_b cle,
4668: oks_pm_activities pma
4669: WHERE cle.id = pma.cle_id
4670: and cle.cle_id=p_cle_id;
4671: */

Line 4682: FROM okc_k_lines_b cle,

4678:
4679: /* Modified by JVorugan for Bug:5215180
4680: CURSOR l_actsch_csr(p_cle_id IN NUMBER) IS
4681: SELECT pms.id
4682: FROM okc_k_lines_b cle,
4683: oks_pm_schedules_v pms
4684: WHERE cle.id = pms.cle_id
4685: and cle.cle_id=p_cle_id
4686: and activity_line_id is not null;

Line 4807: OKC_K_LINES_B srvcle,

4803: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4804: SELECT srvcle.id
4805: , srvcle.line_number
4806: FROM
4807: OKC_K_LINES_B srvcle,
4808: OKC_K_LINES_B covcle,
4809: OKS_K_LINES_B cov
4810: WHERE
4811: srvcle.chr_id = p_chr_id

Line 4808: OKC_K_LINES_B covcle,

4804: SELECT srvcle.id
4805: , srvcle.line_number
4806: FROM
4807: OKC_K_LINES_B srvcle,
4808: OKC_K_LINES_B covcle,
4809: OKS_K_LINES_B cov
4810: WHERE
4811: srvcle.chr_id = p_chr_id
4812: and srvcle.id=covcle.cle_id

Line 4821: OKC_K_LINES_B srvcle,

4817: CURSOR l_cle_csr(p_chr_id IN NUMBER) IS
4818: SELECT srvcle.id
4819: , srvcle.line_number
4820: FROM
4821: OKC_K_LINES_B srvcle,
4822: OKS_K_LINES_B cov
4823: WHERE
4824: srvcle.chr_id = p_chr_id
4825: and srvcle.id=cov.cle_id

Line 4835: FROM okc_k_lines_b cle,

4831:
4832: --Cursor to fetch activities for the program defined in CMRO
4833: CURSOR l_prog_csr(p_cle_id IN NUMBER) IS
4834: SELECT act.id1 activity_id
4835: FROM okc_k_lines_b cle,
4836: oks_k_lines_b okscle,
4837: okx_pm_activities_v act
4838: WHERE cle.id = okscle.cle_id
4839: and cle.dnz_chr_id = okscle.dnz_chr_id

Line 4849: FROM okc_k_lines_b cle,

4845:
4846: --Cursor to fetch activities for the program associated with the service line
4847: CURSOR l_act_csr(p_cle_id IN NUMBER) IS
4848: SELECT oksact.activity_id
4849: FROM okc_k_lines_b cle,
4850: oks_k_lines_b okscle,
4851: oks_pm_activities_v oksact
4852: WHERE cle.id = okscle.cle_id
4853: and cle.dnz_chr_id = okscle.dnz_chr_id