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_MASS_UPDATE_PVT dependencies on OKS_INSTANCE_K_DTLS_TEMP

Line 51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |

47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |
48: --+---------------------------------+---+---+---+---+---+----------------------+
49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |
50: --+---------------------------------+---+---+---+---+---+----------------------+
51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |
52: --+---------------------------------+---+---+---+---+---+----------------------+
53: --| OKS_K_SALES_CREDITS_V | X | | | | | |
54: --+---------------------------------+---+---+---+---+---+----------------------+
55: --| OKC_K_ACCESSES_V | X | | | | | |

Line 1781: From Oks_instance_k_dtls_temp

1777: And cls.opn_code in ('RENEWAL','REN_CON');
1778:
1779: Cursor check_renis_xfd(p_contract_id Number) Is
1780: Select 'x'
1781: From Oks_instance_k_dtls_temp
1782: Where contract_id = p_contract_id
1783: And new_contract_id is not null;
1784:
1785: l_renewal_id Number;

Line 1856: FROM oks_instance_k_dtls_temp temp1

1852: ks.period_start hdr_period_start,
1853: ks.period_type hdr_period_type,
1854: gov.isa_agreement_id agreement_id,
1855: (SELECT MIN (temp1.new_start_date)
1856: FROM oks_instance_k_dtls_temp temp1
1857: WHERE temp1.contract_id = temp.contract_id) hdr_sdate,
1858: (SELECT MAX (temp1.new_end_date)
1859: FROM oks_instance_k_dtls_temp temp1
1860: WHERE temp1.contract_id = temp.contract_id) hdr_edate,

Line 1859: FROM oks_instance_k_dtls_temp temp1

1855: (SELECT MIN (temp1.new_start_date)
1856: FROM oks_instance_k_dtls_temp temp1
1857: WHERE temp1.contract_id = temp.contract_id) hdr_sdate,
1858: (SELECT MAX (temp1.new_end_date)
1859: FROM oks_instance_k_dtls_temp temp1
1860: WHERE temp1.contract_id = temp.contract_id) hdr_edate,
1861: kh.contract_number contract_number,
1862: kh.contract_number_modifier,
1863: get_modifier(temp.contract_id),

Line 1870: oks_instance_k_dtls_temp temp,

1866: ks.price_uom
1867:
1868: FROM okc_k_headers_all_b kh,
1869: oks_k_headers_b ks,
1870: oks_instance_k_dtls_temp temp,
1871: okc_statuses_b st,
1872: okc_governances gov
1873: WHERE kh.ID = temp.contract_id
1874: AND temp.new_contract_id is not null

Line 1888: oks_instance_k_dtls_temp temp

1884: sc.sales_credit_type_id1,
1885: sc.PERCENT,
1886: sc.sales_group_id
1887: FROM oks_k_sales_credits_v sc,
1888: oks_instance_k_dtls_temp temp
1889: WHERE sc.chr_id = temp.contract_id
1890: AND sc.cle_id IS NULL
1891: AND temp.new_contract_id IS NOT NULL;
1892:

Line 1900: oks_instance_k_dtls_temp temp

1896: ac.GROUP_ID,
1897: ac.resource_id,
1898: ac.access_level
1899: FROM okc_k_accesses_v ac,
1900: oks_instance_k_dtls_temp temp
1901: WHERE chr_id = temp.contract_id
1902: AND temp.new_contract_id IS NOT NULL;-- cgopinee bugfix for bug11075156;
1903:
1904: CURSOR l_app_csr (

Line 3271: FROM oks_instance_k_dtls_temp temp1

3267: kl.lse_id lse_id,
3268: kl.line_renewal_type_code renewal_type,
3269: kl.price_unit unit_price,
3270: (SELECT MIN (new_start_date)
3271: FROM oks_instance_k_dtls_temp temp1
3272: WHERE temp1.topline_id = temp.topline_id) new_sdt,
3273: (SELECT MAX (new_end_date)
3274: FROM oks_instance_k_dtls_temp temp1
3275: WHERE temp1.topline_id = temp.topline_id) new_edt,

Line 3274: FROM oks_instance_k_dtls_temp temp1

3270: (SELECT MIN (new_start_date)
3271: FROM oks_instance_k_dtls_temp temp1
3272: WHERE temp1.topline_id = temp.topline_id) new_sdt,
3273: (SELECT MAX (new_end_date)
3274: FROM oks_instance_k_dtls_temp temp1
3275: WHERE temp1.topline_id = temp.topline_id) new_edt,
3276: Ks.invoice_text,
3277: ks.coverage_id,
3278: ks.standard_cov_yn,

Line 3288: FROM oks_instance_k_dtls_temp temp,

3284: kh.authoring_org_id,
3285: Kl.Line_Number Line_no
3286:
3287:
3288: FROM oks_instance_k_dtls_temp temp,
3289: okc_k_lines_b kl,
3290: okc_k_items itm,
3291: oks_k_lines_v ks,
3292: okc_statuses_b st,

Line 3312: oks_instance_k_dtls_temp temp

3308: sc.sales_credit_type_id1,
3309: sc.PERCENT,
3310: sc.sales_group_id
3311: FROM oks_k_sales_credits_v sc,
3312: oks_instance_k_dtls_temp temp
3313: WHERE sc.cle_id = temp.topline_id
3314: AND temp.new_serviceline_id IS NOT NULL;
3315:
3316:

Line 3817: FROM oks_instance_k_dtls_temp temp,

3813: ks.price_uom,
3814: ks.toplvl_price_qty,
3815: ks.toplvl_uom_code
3816:
3817: FROM oks_instance_k_dtls_temp temp,
3818: okc_k_lines_b kl,
3819: okc_k_lines_b kl1,
3820: okc_k_items itm,
3821: oks_k_lines_v ks,

Line 4495: From Oks_instance_k_dtls_temp temp

4491: ,ks.standard_cov_yn
4492: ,ki.object1_id1 srv_itm
4493: ,St.ste_code
4494: ,kl.start_date
4495: From Oks_instance_k_dtls_temp temp
4496: , okc_k_lines_b line
4497: , Okc_k_lines_b Kl
4498: , oks_k_lines_b Ks
4499: , Okc_k_items Ki

Line 4519: From OKs_instance_k_dtls_temp temp

4515: ,Decode(kl.lse_id,18,'WARRANTY','OTHERS')
4516: ,Kh.qcl_id
4517: ,oKh.start_date
4518: ,ks.period_start
4519: From OKs_instance_k_dtls_temp temp
4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt

Line 4536: From Oks_instance_k_dtls_temp temp

4532: And Kl.Id = temp.subline_id;
4533:
4534: CURSOR get_subline_details_csr(p_contract_id Number) IS
4535: Select temp.new_subline_Id
4536: From Oks_instance_k_dtls_temp temp
4537: Where temp.new_contract_id = p_contract_id;
4538: CURSOR get_csi_note_csr (
4539: p_batch_id NUMBER
4540: )

Line 5927: From Oks_instance_k_dtls_temp temp

5923: CURSOR get_srv_details_csr(p_contract_id Number) IS
5924: Select Distinct temp.topline_id
5925: ,St.ste_code
5926: ,line.start_date
5927: From Oks_instance_k_dtls_temp temp
5928: , okc_k_lines_b line
5929: , Okc_statuses_b St
5930: Where line.id = temp.Topline_id
5931: And temp.contract_id = p_contract_id

Line 5940: From OKs_instance_k_dtls_temp temp

5936: , kh.authoring_org_id
5937: , kh.inv_organization_id
5938: , St.ste_code
5939: , Kh.start_date
5940: From OKs_instance_k_dtls_temp temp
5941: , Okc_k_headers_all_b Kh
5942: , Okc_statuses_b St
5943: Where Kh.Id = temp.contract_id
5944: And St.code = Kh.sts_code;

Line 6516: , oks_instance_k_dtls_temp temp

6512: SELECT distinct temp.topline_id
6513: ,line.start_date,
6514: line.end_date
6515: FROM okc_k_lines_b line
6516: , oks_instance_k_dtls_temp temp
6517: WHERE line.ID = temp.topline_id;
6518:
6519: CURSOR check_renewal_link (
6520: p_line_id NUMBER

Line 6596: FROM oks_instance_k_dtls_temp a,

6592: WHERE ID = new_serviceline_id),
6593: (SELECT price_negotiated
6594: FROM okc_k_lines_b
6595: WHERE ID = new_subline_id)
6596: FROM oks_instance_k_dtls_temp a,
6597: oks_instance_history b
6598: WHERE b.batch_id = p_batch_id
6599: AND a.instance_id = b.instance_id
6600: AND b.transaction_type = 'TRF';

Line 6610: ,OKs_instance_k_dtls_temp temp

6606: Select Kl.Id
6607: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,3))||kl.start_date||' - '|| kl.end_date)
6608: From Okc_k_lines_b Kl
6609: ,Oks_k_lines_v Ksl
6610: ,OKs_instance_k_dtls_temp temp
6611: Where kl.id = temp.subline_id
6612: And Ksl.cle_id = Kl.id;
6613:
6614: Cursor L_topline_csr Is

Line 6619: From OKs_instance_k_dtls_temp temp

6615: Select distinct a.Topline_id, a.start_date, a.end_date
6616: From (select line.cle_id topline_id
6617: , min(line.start_date) start_date
6618: , max(line.end_date) end_date
6619: From OKs_instance_k_dtls_temp temp
6620: , okc_K_lines_b line
6621: Where line.cle_id = temp.topline_id
6622: And line.lse_id = 18
6623: group by line.cle_id) a;

Line 6630: ,OKs_instance_k_dtls_temp temp

6626: Select distinct Kl.Id
6627: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,1))||kl.start_date||' - '|| kl.end_date)
6628: From Okc_k_lines_b Kl
6629: ,Oks_k_lines_v Ksl
6630: ,OKs_instance_k_dtls_temp temp
6631: Where kl.id = temp.topline_id
6632: And Ksl.cle_id = Kl.id;
6633:
6634: Cursor L_contract_csr Is

Line 6639: From OKs_instance_k_dtls_temp temp

6635: Select distinct a.Contract_id, a.start_date, a.end_date
6636: From (Select line.dnz_chr_id contract_id
6637: ,min(line.start_date) start_date
6638: , max(line.end_date) end_date
6639: From OKs_instance_k_dtls_temp temp
6640: , okc_k_lines_b line
6641: Where line.dnz_chr_id = temp.contract_id
6642: And line.lse_id = 14
6643: group by line.dnz_chr_id) a;

Line 6649: From Oks_instance_k_dtls_temp temp

6645:
6646: CURSOR get_srv_details_csr(p_contract_id Number) IS
6647: Select Distinct temp.topline_id
6648: ,St.ste_code
6649: From Oks_instance_k_dtls_temp temp
6650: , okc_k_lines_b line
6651: , Okc_statuses_b St
6652: Where line.id = temp.Topline_id
6653: And temp.contract_id = p_contract_id

Line 6661: From OKs_instance_k_dtls_temp temp

6657: Select distinct temp.contract_id
6658: , kh.authoring_org_id
6659: , kh.inv_organization_id
6660: , St.ste_code
6661: From OKs_instance_k_dtls_temp temp
6662: , Okc_k_headers_all_b Kh
6663: , Okc_statuses_b St
6664: Where Kh.Id = temp.contract_id
6665: And St.code = Kh.sts_code;

Line 7035: INSERT INTO oks_instance_k_dtls_temp

7031: l_return_status := OKC_API.G_RET_STS_ERROR;
7032: RAISE G_EXCEPTION_HALT_VALIDATION;
7033: END IF;
7034: FORALL i IN contract_id.FIRST .. contract_id.LAST
7035: INSERT INTO oks_instance_k_dtls_temp
7036: (parent_id,
7037: contract_id,
7038: topline_id,
7039: subline_id,

Line 7390: Delete Oks_Instance_k_dtls_temp where parent_id = p_batch_id;

7386: l_return_status := OKC_API.G_RET_STS_ERROR;
7387: RAISE G_EXCEPTION_HALT_VALIDATION;
7388: END IF;
7389:
7390: Delete Oks_Instance_k_dtls_temp where parent_id = p_batch_id;
7391:
7392: FORALL i IN contract_id.FIRST .. contract_id.LAST
7393: INSERT INTO oks_instance_k_dtls_temp
7394: (parent_id,

Line 7393: INSERT INTO oks_instance_k_dtls_temp

7389:
7390: Delete Oks_Instance_k_dtls_temp where parent_id = p_batch_id;
7391:
7392: FORALL i IN contract_id.FIRST .. contract_id.LAST
7393: INSERT INTO oks_instance_k_dtls_temp
7394: (parent_id,
7395: contract_id,
7396: topline_id,
7397: subline_id,

Line 7976: INSERT INTO oks_instance_k_dtls_temp

7972:
7973: CLOSE get_k_for_idc_csr;
7974: IF Contract_id.count > 0 THEN --Added for Bug#14183916
7975: FORALL i IN contract_id.FIRST .. contract_id.LAST
7976: INSERT INTO oks_instance_k_dtls_temp
7977: (parent_id,
7978: contract_id,
7979: topline_id,
7980: subline_id,

Line 8229: FROM oks_instance_k_dtls_temp a,

8225: fnd_global.user_id,
8226: SYSDATE,
8227: fnd_global.login_id,
8228: p_batch_id
8229: FROM oks_instance_k_dtls_temp a,
8230: csi_item_instances b
8231: WHERE a.instance_id = b.instance_id);
8232:
8233: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');

Line 8373: INSERT INTO oks_instance_k_dtls_temp

8369: CLOSE get_k_for_trm_csr;
8370:
8371: IF Contract_id.Count > 0 THEN --Added for Bug#14183916
8372: FORALL i IN contract_id.FIRST .. contract_id.LAST
8373: INSERT INTO oks_instance_k_dtls_temp
8374: (parent_id,
8375: contract_id,
8376: topline_id,
8377: subline_id,