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 OKC_K_LINES_B

Line 83: --| OKC_K_LINES_B | X | X | X | | | |

79: --| OKS_COVERAGES_PUB | | | | | |X |
80: --+---------------------------------+---+---+---+---+---+----------------------+
81: --| OKC_INST_CND_PUB | | | | | |X |
82: --+---------------------------------+---+---+---+---+---+----------------------+
83: --| OKC_K_LINES_B | X | X | X | | | |
84: --+---------------------------------+---+---+---+---+---+----------------------+
85: --| OKC_K_LINES_TL | | X | | | | |
86: --+---------------------------------+---+---+---+---+---+----------------------+
87: --| OKS_K_LINES_B | X | X | | | | |

Line 1936: From Okc_k_lines_b kl

1932: WHere code = p_sts_code;
1933:
1934: Cursor l_warranty_csr(p_hdr_Id Number) Is
1935: Select lse_id
1936: From Okc_k_lines_b kl
1937: Where chr_id = p_hdr_id
1938: And lse_id in (1,19,14);
1939:
1940:

Line 3281: FROM okc_k_lines_b WHERE id = topline_id) oks_id,

3277: ks.coverage_id,
3278: ks.standard_cov_yn,
3279: st.ste_code line_sts,
3280: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3281: FROM okc_k_lines_b WHERE id = topline_id) oks_id,
3282: topline_id,
3283: Ks.price_uom,
3284: kh.authoring_org_id,
3285: Kl.Line_Number Line_no

Line 3289: okc_k_lines_b kl,

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,
3293: okc_k_headers_all_b kh

Line 3422: INSERT INTO okc_k_lines_b

3418: THEN
3419: -- create okc lines
3420: l_tabsize := srvline_id.COUNT;
3421: FORALL i IN 1 .. l_tabsize
3422: INSERT INTO okc_k_lines_b
3423: (ID,
3424: line_number,
3425: chr_id,
3426: cle_id,

Line 3503: 'After insert into okc_k_lines_b table ');

3499: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3500: THEN
3501: fnd_log.STRING (fnd_log.level_event,
3502: g_module_current || 'oks_mass_update.create_contract_Line',
3503: 'After insert into okc_k_lines_b table ');
3504: END IF;
3505:
3506:
3507: -- insert into okc tl table

Line 3812: FROM okc_k_lines_b WHERE id = subline_id) oks_id,

3808: kl1.start_date srv_sdate,
3809: kl1.end_date srv_edate,
3810: st.ste_code subline_sts,
3811: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3812: FROM okc_k_lines_b WHERE id = subline_id) oks_id,
3813: ks.price_uom,
3814: ks.toplvl_price_qty,
3815: ks.toplvl_uom_code
3816:

Line 3818: okc_k_lines_b kl,

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,
3822: okc_statuses_b st,

Line 3819: okc_k_lines_b kl1,

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,
3822: okc_statuses_b st,
3823: oks_k_headers_b kh

Line 3927: INSERT INTO okc_k_lines_b

3923: THEN
3924:
3925: l_tabsize := subline_id.COUNT;
3926: FORALL i IN 1 .. l_tabsize
3927: INSERT INTO okc_k_lines_b
3928: (ID,
3929: line_number,
3930: --chr_id,
3931: cle_id,

Line 4496: , okc_k_lines_b line

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
4500: , Okc_statuses_b St

Line 4497: , Okc_k_lines_b Kl

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
4500: , Okc_statuses_b St
4501: Where line.id = temp.new_serviceline_id

Line 4524: , Okc_k_lines_b Kl

4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt
4524: , Okc_k_lines_b Kl
4525: , Oks_k_headers_b Ks
4526: Where Kh.Id = temp.new_contract_id
4527: And OKH.Id = temp.contract_id
4528: And Ks.chr_id = Kh.id

Line 5003: set tax_amount = (select nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl

4999: End loop;
5000: END IF; --Added for Bug#14183916
5001: Forall l in srvline_id.first..srvline_id.last
5002: Update oks_k_lines_b
5003: set tax_amount = (select nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
5004: where kl.cle_id = srvline_id(l) and ks.cle_id = kl.id)
5005: Where cle_id = srvline_id(l);
5006: End If;
5007:

Line 5122: UPDATE okc_k_lines_b

5118: fnd_file.put_line(fnd_file.log,'(OKS) -> Header status updated to ( '
5119: || l_sts_code ||' ) successfully');
5120:
5121:
5122: UPDATE okc_k_lines_b
5123: SET sts_code = l_sts_code
5124: WHERE dnz_chr_id = qa_contract_id ;
5125:
5126: fnd_file.put_line(fnd_file.log,'(OKS) -> Line status updated to ( '

Line 5347: Set tax_amount = (select Nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl

5343: END IF; --Added for Bug#14183916
5344: IF Contract_id.count > 0 THEN --Added for Bug#14183916
5345: Forall k in contract_id.first..contract_id.last
5346: Update oks_k_headers_b
5347: Set tax_amount = (select Nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
5348: where kl.dnz_chr_id = contract_id(k) and ks.cle_id = kl.id and kl.lse_id in (9,25))
5349: Where chr_id = contract_id(k);
5350: END IF; --Added for Bug#14183916
5351: x_return_status := l_return_status;

Line 5928: , okc_k_lines_b line

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
5932: And St.code = line.sts_code;

Line 6139: okc_k_lines_b kl,

6135: Kh.inv_organization_id
6136: FROM okc_k_items ki,
6137: okc_k_headers_all_b kh,
6138: oks_k_headers_b ks,
6139: okc_k_lines_b kl,
6140: okc_statuses_b st,
6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,
6143: oks_k_lines_b ks2,

Line 6144: okc_k_lines_b kl2,

6140: okc_statuses_b st,
6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,
6143: oks_k_lines_b ks2,
6144: okc_k_lines_b kl2,
6145: oks_instance_temp tmp,
6146: okc_k_party_roles_b party
6147: WHERE ki.object1_id1 = to_char(tmp.old_customer_product_id)
6148: AND tmp.trf = 'Y'

Line 6230: okc_k_lines_b sl,

6226:
6227: FROM okc_k_items ki,
6228: okc_k_headers_all_b kh,
6229: oks_k_headers_b ks,
6230: okc_k_lines_b sl,
6231: okc_k_lines_b Tl,
6232: oks_k_lines_b okl,
6233: oks_k_lines_b okl1,
6234: okc_statuses_b st,

Line 6231: okc_k_lines_b Tl,

6227: FROM okc_k_items ki,
6228: okc_k_headers_all_b kh,
6229: oks_k_headers_b ks,
6230: okc_k_lines_b sl,
6231: okc_k_lines_b Tl,
6232: oks_k_lines_b okl,
6233: oks_k_lines_b okl1,
6234: okc_statuses_b st,
6235: okc_k_party_roles_b party,

Line 6309: okc_k_lines_b kl,

6305: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6306: Kh.inv_organization_id
6307: FROM okc_k_items ki,
6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,
6310: okc_statuses_b st,
6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,

Line 6312: okc_k_lines_b tl,

6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,
6310: okc_statuses_b st,
6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,
6314: Okc_statuses_b Hst,
6315: Okc_statuses_b Lst
6316: WHERE tmp.trm = 'Y'

Line 6373: okc_k_lines_b kl,

6369:
6370:
6371: FROM okc_k_items ki,
6372: okc_k_headers_all_b kh,
6373: okc_k_lines_b kl,
6374: okc_k_lines_b tl,
6375: okc_statuses_b st,
6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,

Line 6374: okc_k_lines_b tl,

6370:
6371: FROM okc_k_items ki,
6372: okc_k_headers_all_b kh,
6373: okc_k_lines_b kl,
6374: okc_k_lines_b tl,
6375: okc_statuses_b st,
6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,
6378: okc_k_party_roles_b party,

Line 6442: okc_k_lines_b kl,

6438:
6439:
6440: FROM okc_k_items ki,
6441: okc_k_headers_all_b kh,
6442: okc_k_lines_b kl,
6443: okc_statuses_b st,
6444: oks_instance_temp tmp,
6445: okc_k_lines_b tl,
6446: oks_k_lines_v ksl,

Line 6445: okc_k_lines_b tl,

6441: okc_k_headers_all_b kh,
6442: okc_k_lines_b kl,
6443: okc_statuses_b st,
6444: oks_instance_temp tmp,
6445: okc_k_lines_b tl,
6446: oks_k_lines_v ksl,
6447: oks_k_lines_b ks11
6448: WHERE tmp.idc = 'Y'
6449: AND NVL(tmp.trm, 'N') = 'N'

Line 6515: FROM okc_k_lines_b line

6511: IS
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 (

Line 6588: FROM okc_k_lines_b

6584: (SELECT sts_code
6585: FROM okc_k_headers_all_b
6586: WHERE ID = new_contract_id),
6587: (SELECT start_date
6588: FROM okc_k_lines_b
6589: WHERE ID = new_serviceline_id),
6590: (SELECT end_date
6591: FROM okc_k_lines_b
6592: WHERE ID = new_serviceline_id),

Line 6591: FROM okc_k_lines_b

6587: (SELECT start_date
6588: FROM okc_k_lines_b
6589: WHERE ID = new_serviceline_id),
6590: (SELECT end_date
6591: FROM okc_k_lines_b
6592: WHERE ID = new_serviceline_id),
6593: (SELECT price_negotiated
6594: FROM okc_k_lines_b
6595: WHERE ID = new_subline_id)

Line 6594: FROM okc_k_lines_b

6590: (SELECT end_date
6591: FROM okc_k_lines_b
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

Line 6608: From Okc_k_lines_b Kl

6604:
6605: Cursor l_subline_invtext_csr Is
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;

Line 6620: , okc_K_lines_b line

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;
6624:

Line 6628: From Okc_k_lines_b Kl

6624:
6625: Cursor l_invoice_text_csr Is
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;

Line 6640: , okc_k_lines_b line

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;
6644:

Line 6650: , okc_k_lines_b line

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
6654: And St.code = line.sts_code;

Line 7300: Okc_k_lines_b lines_b,

7296: fnd_global.login_id,
7297: lines_b.date_cancelled, --Date cancelled,
7298: 'TERM'
7299: from oks_instance_history ins_hist,
7300: Okc_k_lines_b lines_b,
7301: okc_k_headers_all_b hdr
7302: Where ins_hist.batch_id = p_batch_id
7303: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)
7304: And hdr.id =contract_id (i) ) ;

Line 7549: UPDATE okc_k_lines_b

7545: END IF;
7546:
7547: -- Update the topline amount
7548: FORALL i IN 1 .. new_line_id.COUNT
7549: UPDATE okc_k_lines_b
7550: SET price_negotiated =
7551: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7552: FROM okc_k_lines_b
7553: WHERE cle_id = new_line_id (i)

Line 7552: FROM okc_k_lines_b

7548: FORALL i IN 1 .. new_line_id.COUNT
7549: UPDATE okc_k_lines_b
7550: SET price_negotiated =
7551: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7552: FROM okc_k_lines_b
7553: WHERE cle_id = new_line_id (i)
7554: AND lse_id IN (9, 25))
7555: WHERE ID = new_line_id (i);
7556:

Line 7564: FROM okc_k_lines_b

7560: FORALL i IN 1 .. new_contract_id.COUNT
7561: UPDATE okc_k_headers_all_b
7562: SET estimated_amount =
7563: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7564: FROM okc_k_lines_b
7565: WHERE dnz_chr_id = new_contract_id (i)
7566: AND lse_id IN (1, 19))
7567: WHERE ID = new_contract_id (i);
7568:

Line 7676: Update okc_k_lines_b set date_renewed = trf_date(1)

7672: x_return_status := l_return_status;
7673:
7674: RAISE g_exception_halt_validation;
7675: END IF;
7676: Update okc_k_lines_b set date_renewed = trf_date(1)
7677: Where id = l_object_line_id
7678: And date_renewed is null;
7679:
7680: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);

Line 7681: Update okc_k_lines_b set date_renewed = l_line_date_renewed

7677: Where id = l_object_line_id
7678: And date_renewed is null;
7679:
7680: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7681: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7683: And date_renewed Is Null;
7684:
7685: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);

Line 7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)

7678: And date_renewed is null;
7679:
7680: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7681: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7682: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7683: And date_renewed Is Null;
7684:
7685: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7686: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed

Line 7687: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)

7683: And date_renewed Is Null;
7684:
7685: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7686: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed
7687: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)
7688: And date_renewed Is Null;
7689:
7690:
7691:

Line 7819: from Oks_instance_history inshist, Okc_k_lines_b line

7815: fnd_global.user_id,
7816: SYSDATE,
7817: fnd_global.login_id,
7818: line.date_cancelled --Date cancelled
7819: from Oks_instance_history inshist, Okc_k_lines_b line
7820: ,okc_k_headers_all_b hdr
7821: Where inshist.instance_id = custprod_id(i)
7822: and batch_id = p_batch_id
7823: And line.id = subline_id(i)

Line 7923: , okc_k_lines_b line

7919: SYSDATE,
7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr
7923: , okc_k_lines_b line
7924: , okc_k_lines_b subline
7925: Where inshist.instance_id = custprod_id(i)
7926: and batch_id = p_batch_id
7927: and hdr.id = new_contract_id(i)

Line 7924: , okc_k_lines_b subline

7920: fnd_global.login_id
7921: from Oks_instance_history inshist
7922: , okc_k_headers_all_b hdr
7923: , okc_k_lines_b line
7924: , okc_k_lines_b subline
7925: Where inshist.instance_id = custprod_id(i)
7926: and batch_id = p_batch_id
7927: and hdr.id = new_contract_id(i)
7928: and line.id = new_line_id(i)

Line 8035: UPDATE okc_k_lines_b

8031: END LOOP;
8032: /*cgopinee- Added who columns for all update statements for bug10303830 */
8033: -- Update Subline dates
8034: FORALL i IN 1 .. subline_id.COUNT
8035: UPDATE okc_k_lines_b
8036: SET start_date = idc_date (i),
8037: end_date = new_edt (i),
8038: sts_code = get_status (idc_date (i), new_edt (i)),
8039: last_updated_by = fnd_global.user_id,

Line 8074: UPDATE okc_k_lines_b

8070:
8071: Close l_topline_csr;
8072:
8073: Forall i in 1..top_line_id.count
8074: UPDATE okc_k_lines_b
8075: SET start_date = line_new_Sdate (i),
8076: end_date = line_new_edate (i),
8077: sts_code = get_status (line_new_Sdate(i), line_new_edate(i)),
8078: last_updated_by = fnd_global.user_id,

Line 8318: , okc_k_lines_b line

8314: SYSDATE,
8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8318: , okc_k_lines_b line
8319: , okc_k_lines_b subline
8320: WHERE a.batch_id = p_batch_id
8321: AND a.transaction_type = 'IDC'
8322: AND a.instance_id = custprod_id(i)

Line 8319: , okc_k_lines_b subline

8315: fnd_global.login_id,
8316: null
8317: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8318: , okc_k_lines_b line
8319: , okc_k_lines_b subline
8320: WHERE a.batch_id = p_batch_id
8321: AND a.transaction_type = 'IDC'
8322: AND a.instance_id = custprod_id(i)
8323: And hdr.id = contract_id(i)

Line 8653: Okc_k_lines_b line,

8649: SYSDATE,
8650: fnd_global.login_id,
8651: line.date_cancelled
8652: FROM oks_instance_history a,
8653: Okc_k_lines_b line,
8654: Okc_k_headers_all_b hdr
8655: WHERE a.batch_id = p_batch_id
8656: AND a.transaction_type = 'TRM'
8657: AND a.instance_id = custprod_id(i)