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 OKS_K_LINES_B

Line 222: from oks_k_lines_b

218:
219: CURSOR cu_line IS
220: SELECT
221: id,object_version_number,dnz_chr_id
222: from oks_k_lines_b
223: where cle_id=p_cle_id;
224: cr_line cu_line%ROWTYPE;
225: CURSOR cu_activities IS
226: SELECT

Line 286: FROM OKS_K_LINES_B

282: cr_act_stream_levels cu_act_stream_levels%ROWTYPE;
283: -- Added part of 12.0 to validate the PM program exist before generating schedule
284: CURSOR CU_CHECK_PM_PROGRAM_EXIST IS
285: SELECT pm_program_id
286: FROM OKS_K_LINES_B
287: WHERE CLE_ID = p_template_cle_id;
288: CR_CHECK_PM_PROGRAM_EXIST CU_CHECK_PM_PROGRAM_EXIST%ROWTYPE;
289:
290: -- Added by jvorugan for Bug:5080930

Line 602: 'update Oks_k_lines_b ');

598: OKC_API.set_message
599: (G_APP_NAME,
600: G_REQUIRED_VALUE,
601: G_COL_NAME_TOKEN,
602: 'update Oks_k_lines_b ');
603:
604: Raise G_EXCEPTION_HALT_VALIDATION;
605: END IF;
606:

Line 1797: FROM OKS_K_LINES_B

1793: order by nvl(schedule_date,schedule_date_from);
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;

Line 4339: OKS_K_LINES_B cov

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
4343: and covcle.id=cov.cle_id

Line 4353: oks_k_lines_b pmp,

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
4357: and pmp.pm_program_id= opv.id1

Line 4366: oks_k_lines_b pmp,

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
4370: and cle.dnz_chr_id = pmp.dnz_chr_id

Line 4469: OKS_K_LINES_B cov

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
4473: and covcle.id=cov.cle_id

Line 4482: oks_k_lines_b pmp,

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
4486: and cle.dnz_chr_id = pmp.dnz_chr_id

Line 4495: oks_k_lines_b pmp,

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
4499: and cle.dnz_chr_id = pmp.dnz_chr_id

Line 4591: OKS_K_LINES_B cov

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
4595: and covcle.id=cov.cle_id

Line 4605: OKS_K_LINES_B cov

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
4609: and cov.pm_program_id is not null

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 4809: OKS_K_LINES_B cov

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
4813: and covcle.id=cov.cle_id

Line 4822: OKS_K_LINES_B cov

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
4826: and cov.pm_program_id is not null

Line 4836: oks_k_lines_b okscle,

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
4840: and okscle.pm_program_id= act.program_id

Line 4850: oks_k_lines_b okscle,

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
4854: and cle.id=oksact.cle_id