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 1931: From Okc_k_lines_b kl

1927: WHere code = p_sts_code;
1928:
1929: Cursor l_warranty_csr(p_hdr_Id Number) Is
1930: Select lse_id
1931: From Okc_k_lines_b kl
1932: Where chr_id = p_hdr_id
1933: And lse_id in (1,19,14);
1934:
1935:

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

3272: ks.coverage_id,
3273: ks.standard_cov_yn,
3274: st.ste_code line_sts,
3275: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3276: FROM okc_k_lines_b WHERE id = topline_id) oks_id,
3277: topline_id,
3278: Ks.price_uom,
3279: kh.authoring_org_id,
3280: Kl.Line_Number Line_no

Line 3284: okc_k_lines_b kl,

3280: Kl.Line_Number Line_no
3281:
3282:
3283: FROM oks_instance_k_dtls_temp temp,
3284: okc_k_lines_b kl,
3285: okc_k_items itm,
3286: oks_k_lines_v ks,
3287: okc_statuses_b st,
3288: okc_k_headers_all_b kh

Line 3417: INSERT INTO okc_k_lines_b

3413: THEN
3414: -- create okc lines
3415: l_tabsize := srvline_id.COUNT;
3416: FORALL i IN 1 .. l_tabsize
3417: INSERT INTO okc_k_lines_b
3418: (ID,
3419: line_number,
3420: chr_id,
3421: cle_id,

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

3494: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3495: THEN
3496: fnd_log.STRING (fnd_log.level_event,
3497: g_module_current || 'oks_mass_update.create_contract_Line',
3498: 'After insert into okc_k_lines_b table ');
3499: END IF;
3500:
3501:
3502: -- insert into okc tl table

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

3803: kl1.start_date srv_sdate,
3804: kl1.end_date srv_edate,
3805: st.ste_code subline_sts,
3806: (SELECT okc_p_util.raw_to_number (SYS_GUID ())
3807: FROM okc_k_lines_b WHERE id = subline_id) oks_id,
3808: ks.price_uom,
3809: ks.toplvl_price_qty,
3810: ks.toplvl_uom_code
3811:

Line 3813: okc_k_lines_b kl,

3809: ks.toplvl_price_qty,
3810: ks.toplvl_uom_code
3811:
3812: FROM oks_instance_k_dtls_temp temp,
3813: okc_k_lines_b kl,
3814: okc_k_lines_b kl1,
3815: okc_k_items itm,
3816: oks_k_lines_v ks,
3817: okc_statuses_b st,

Line 3814: okc_k_lines_b kl1,

3810: ks.toplvl_uom_code
3811:
3812: FROM oks_instance_k_dtls_temp temp,
3813: okc_k_lines_b kl,
3814: okc_k_lines_b kl1,
3815: okc_k_items itm,
3816: oks_k_lines_v ks,
3817: okc_statuses_b st,
3818: oks_k_headers_b kh

Line 3922: INSERT INTO okc_k_lines_b

3918: THEN
3919:
3920: l_tabsize := subline_id.COUNT;
3921: FORALL i IN 1 .. l_tabsize
3922: INSERT INTO okc_k_lines_b
3923: (ID,
3924: line_number,
3925: --chr_id,
3926: cle_id,

Line 4491: , okc_k_lines_b line

4487: ,ki.object1_id1 srv_itm
4488: ,St.ste_code
4489: ,kl.start_date
4490: From Oks_instance_k_dtls_temp temp
4491: , okc_k_lines_b line
4492: , Okc_k_lines_b Kl
4493: , oks_k_lines_b Ks
4494: , Okc_k_items Ki
4495: , Okc_statuses_b St

Line 4492: , Okc_k_lines_b Kl

4488: ,St.ste_code
4489: ,kl.start_date
4490: From Oks_instance_k_dtls_temp temp
4491: , okc_k_lines_b line
4492: , Okc_k_lines_b Kl
4493: , oks_k_lines_b Ks
4494: , Okc_k_items Ki
4495: , Okc_statuses_b St
4496: Where line.id = temp.new_serviceline_id

Line 4519: , Okc_k_lines_b Kl

4515: , Okc_k_headers_all_b Kh
4516: , Okc_k_headers_all_b OKH
4517: , Okc_statuses_b St
4518: , Okc_statuses_b OSt
4519: , Okc_k_lines_b Kl
4520: , Oks_k_headers_b Ks
4521: Where Kh.Id = temp.new_contract_id
4522: And OKH.Id = temp.contract_id
4523: And Ks.chr_id = Kh.id

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

4994: End loop;
4995:
4996: Forall l in srvline_id.first..srvline_id.last
4997: Update oks_k_lines_b
4998: set tax_amount = (select nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
4999: where kl.cle_id = srvline_id(l) and ks.cle_id = kl.id)
5000: Where cle_id = srvline_id(l);
5001: End If;
5002:

Line 5107: UPDATE okc_k_lines_b

5103: fnd_file.put_line(fnd_file.log,'(OKS) -> Header status updated to ( '
5104: || l_sts_code ||' ) successfully');
5105:
5106:
5107: UPDATE okc_k_lines_b
5108: SET sts_code = l_sts_code
5109: WHERE dnz_chr_id = qa_contract_id ;
5110:
5111: fnd_file.put_line(fnd_file.log,'(OKS) -> Line status updated to ( '

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

5326:
5327: End Loop; -- Contracts
5328: Forall k in contract_id.first..contract_id.last
5329: Update oks_k_headers_b
5330: Set tax_amount = (select Nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
5331: where kl.dnz_chr_id = contract_id(k) and ks.cle_id = kl.id and kl.lse_id in (9,25))
5332: Where chr_id = contract_id(k);
5333:
5334: x_return_status := l_return_status;

Line 5911: , okc_k_lines_b line

5907: Select Distinct temp.topline_id
5908: ,St.ste_code
5909: ,line.start_date
5910: From Oks_instance_k_dtls_temp temp
5911: , okc_k_lines_b line
5912: , Okc_statuses_b St
5913: Where line.id = temp.Topline_id
5914: And temp.contract_id = p_contract_id
5915: And St.code = line.sts_code;

Line 6122: okc_k_lines_b kl,

6118: Kh.inv_organization_id
6119: FROM okc_k_items ki,
6120: okc_k_headers_all_b kh,
6121: oks_k_headers_b ks,
6122: okc_k_lines_b kl,
6123: okc_statuses_b st,
6124: okc_statuses_b Hst,
6125: oks_k_lines_b ks1,
6126: oks_k_lines_b ks2,

Line 6127: okc_k_lines_b kl2,

6123: okc_statuses_b st,
6124: okc_statuses_b Hst,
6125: oks_k_lines_b ks1,
6126: oks_k_lines_b ks2,
6127: okc_k_lines_b kl2,
6128: oks_instance_temp tmp,
6129: okc_k_party_roles_b party
6130: WHERE ki.object1_id1 = to_char(tmp.old_customer_product_id)
6131: AND tmp.trf = 'Y'

Line 6213: okc_k_lines_b sl,

6209:
6210: FROM okc_k_items ki,
6211: okc_k_headers_all_b kh,
6212: oks_k_headers_b ks,
6213: okc_k_lines_b sl,
6214: okc_k_lines_b Tl,
6215: oks_k_lines_b okl,
6216: oks_k_lines_b okl1,
6217: okc_statuses_b st,

Line 6214: okc_k_lines_b Tl,

6210: FROM okc_k_items ki,
6211: okc_k_headers_all_b kh,
6212: oks_k_headers_b ks,
6213: okc_k_lines_b sl,
6214: okc_k_lines_b Tl,
6215: oks_k_lines_b okl,
6216: oks_k_lines_b okl1,
6217: okc_statuses_b st,
6218: okc_k_party_roles_b party,

Line 6292: okc_k_lines_b kl,

6288: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6289: Kh.inv_organization_id
6290: FROM okc_k_items ki,
6291: okc_k_headers_all_b kh,
6292: okc_k_lines_b kl,
6293: okc_statuses_b st,
6294: oks_instance_temp tmp,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,

Line 6295: okc_k_lines_b tl,

6291: okc_k_headers_all_b kh,
6292: okc_k_lines_b kl,
6293: okc_statuses_b st,
6294: oks_instance_temp tmp,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,
6297: Okc_statuses_b Hst,
6298: Okc_statuses_b Lst
6299: WHERE tmp.trm = 'Y'

Line 6356: okc_k_lines_b kl,

6352:
6353:
6354: FROM okc_k_items ki,
6355: okc_k_headers_all_b kh,
6356: okc_k_lines_b kl,
6357: okc_k_lines_b tl,
6358: okc_statuses_b st,
6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,

Line 6357: okc_k_lines_b tl,

6353:
6354: FROM okc_k_items ki,
6355: okc_k_headers_all_b kh,
6356: okc_k_lines_b kl,
6357: okc_k_lines_b tl,
6358: okc_statuses_b st,
6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,
6361: okc_k_party_roles_b party,

Line 6425: okc_k_lines_b kl,

6421:
6422:
6423: FROM okc_k_items ki,
6424: okc_k_headers_all_b kh,
6425: okc_k_lines_b kl,
6426: okc_statuses_b st,
6427: oks_instance_temp tmp,
6428: okc_k_lines_b tl,
6429: oks_k_lines_v ksl,

Line 6428: okc_k_lines_b tl,

6424: okc_k_headers_all_b kh,
6425: okc_k_lines_b kl,
6426: okc_statuses_b st,
6427: oks_instance_temp tmp,
6428: okc_k_lines_b tl,
6429: oks_k_lines_v ksl,
6430: oks_k_lines_b ks11
6431: WHERE tmp.idc = 'Y'
6432: AND NVL(tmp.trm, 'N') = 'N'

Line 6498: FROM okc_k_lines_b line

6494: IS
6495: SELECT distinct temp.topline_id
6496: ,line.start_date,
6497: line.end_date
6498: FROM okc_k_lines_b line
6499: , oks_instance_k_dtls_temp temp
6500: WHERE line.ID = temp.topline_id;
6501:
6502: CURSOR check_renewal_link (

Line 6571: FROM okc_k_lines_b

6567: (SELECT sts_code
6568: FROM okc_k_headers_all_b
6569: WHERE ID = new_contract_id),
6570: (SELECT start_date
6571: FROM okc_k_lines_b
6572: WHERE ID = new_serviceline_id),
6573: (SELECT end_date
6574: FROM okc_k_lines_b
6575: WHERE ID = new_serviceline_id),

Line 6574: FROM okc_k_lines_b

6570: (SELECT start_date
6571: FROM okc_k_lines_b
6572: WHERE ID = new_serviceline_id),
6573: (SELECT end_date
6574: FROM okc_k_lines_b
6575: WHERE ID = new_serviceline_id),
6576: (SELECT price_negotiated
6577: FROM okc_k_lines_b
6578: WHERE ID = new_subline_id)

Line 6577: FROM okc_k_lines_b

6573: (SELECT end_date
6574: FROM okc_k_lines_b
6575: WHERE ID = new_serviceline_id),
6576: (SELECT price_negotiated
6577: FROM okc_k_lines_b
6578: WHERE ID = new_subline_id)
6579: FROM oks_instance_k_dtls_temp a,
6580: oks_instance_history b
6581: WHERE b.batch_id = p_batch_id

Line 6591: From Okc_k_lines_b Kl

6587:
6588: Cursor l_subline_invtext_csr Is
6589: Select Kl.Id
6590: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,3))||kl.start_date||' - '|| kl.end_date)
6591: From Okc_k_lines_b Kl
6592: ,Oks_k_lines_v Ksl
6593: ,OKs_instance_k_dtls_temp temp
6594: Where kl.id = temp.subline_id
6595: And Ksl.cle_id = Kl.id;

Line 6603: , okc_K_lines_b line

6599: From (select line.cle_id topline_id
6600: , min(line.start_date) start_date
6601: , max(line.end_date) end_date
6602: From OKs_instance_k_dtls_temp temp
6603: , okc_K_lines_b line
6604: Where line.cle_id = temp.topline_id
6605: And line.lse_id = 18
6606: group by line.cle_id) a;
6607:

Line 6611: From Okc_k_lines_b Kl

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

Line 6623: , okc_k_lines_b line

6619: From (Select line.dnz_chr_id contract_id
6620: ,min(line.start_date) start_date
6621: , max(line.end_date) end_date
6622: From OKs_instance_k_dtls_temp temp
6623: , okc_k_lines_b line
6624: Where line.dnz_chr_id = temp.contract_id
6625: And line.lse_id = 14
6626: group by line.dnz_chr_id) a;
6627:

Line 6633: , okc_k_lines_b line

6629: CURSOR get_srv_details_csr(p_contract_id Number) IS
6630: Select Distinct temp.topline_id
6631: ,St.ste_code
6632: From Oks_instance_k_dtls_temp temp
6633: , okc_k_lines_b line
6634: , Okc_statuses_b St
6635: Where line.id = temp.Topline_id
6636: And temp.contract_id = p_contract_id
6637: And St.code = line.sts_code;

Line 7283: Okc_k_lines_b lines_b,

7279: fnd_global.login_id,
7280: lines_b.date_cancelled, --Date cancelled,
7281: 'TERM'
7282: from oks_instance_history ins_hist,
7283: Okc_k_lines_b lines_b,
7284: okc_k_headers_all_b hdr
7285: Where ins_hist.batch_id = p_batch_id
7286: and instance_id = custprod_id(i) and lines_b.id = subline_id (i)
7287: And hdr.id =contract_id (i) ) ;

Line 7532: UPDATE okc_k_lines_b

7528: END IF;
7529:
7530: -- Update the topline amount
7531: FORALL i IN 1 .. new_line_id.COUNT
7532: UPDATE okc_k_lines_b
7533: SET price_negotiated =
7534: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7535: FROM okc_k_lines_b
7536: WHERE cle_id = new_line_id (i)

Line 7535: FROM okc_k_lines_b

7531: FORALL i IN 1 .. new_line_id.COUNT
7532: UPDATE okc_k_lines_b
7533: SET price_negotiated =
7534: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7535: FROM okc_k_lines_b
7536: WHERE cle_id = new_line_id (i)
7537: AND lse_id IN (9, 25))
7538: WHERE ID = new_line_id (i);
7539:

Line 7547: FROM okc_k_lines_b

7543: FORALL i IN 1 .. new_contract_id.COUNT
7544: UPDATE okc_k_headers_all_b
7545: SET estimated_amount =
7546: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7547: FROM okc_k_lines_b
7548: WHERE dnz_chr_id = new_contract_id (i)
7549: AND lse_id IN (1, 19))
7550: WHERE ID = new_contract_id (i);
7551:

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

7655: x_return_status := l_return_status;
7656:
7657: RAISE g_exception_halt_validation;
7658: END IF;
7659: Update okc_k_lines_b set date_renewed = trf_date(1)
7660: Where id = l_object_line_id
7661: And date_renewed is null;
7662:
7663: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);

Line 7664: Update okc_k_lines_b set date_renewed = l_line_date_renewed

7660: Where id = l_object_line_id
7661: And date_renewed is null;
7662:
7663: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7664: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7665: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7666: And date_renewed Is Null;
7667:
7668: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);

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

7661: And date_renewed is null;
7662:
7663: L_line_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_Sublines(l_object_line_id);
7664: Update okc_k_lines_b set date_renewed = l_line_date_renewed
7665: Where id = (select cle_id from okc_k_lines_b where id = l_object_line_id)
7666: And date_renewed Is Null;
7667:
7668: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7669: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed

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

7666: And date_renewed Is Null;
7667:
7668: l_hdr_date_renewed := OKS_IB_UTIL_PVT.Check_renewed_lines(l_object_line_id);
7669: Update okc_k_headers_all_b set date_renewed = l_line_date_renewed
7670: Where id = (select dnz_chr_id from okc_k_lines_b where id = l_object_line_id)
7671: And date_renewed Is Null;
7672:
7673:
7674:

Line 7802: from Oks_instance_history inshist, Okc_k_lines_b line

7798: fnd_global.user_id,
7799: SYSDATE,
7800: fnd_global.login_id,
7801: line.date_cancelled --Date cancelled
7802: from Oks_instance_history inshist, Okc_k_lines_b line
7803: ,okc_k_headers_all_b hdr
7804: Where inshist.instance_id = custprod_id(i)
7805: and batch_id = p_batch_id
7806: And line.id = subline_id(i)

Line 7906: , okc_k_lines_b line

7902: SYSDATE,
7903: fnd_global.login_id
7904: from Oks_instance_history inshist
7905: , okc_k_headers_all_b hdr
7906: , okc_k_lines_b line
7907: , okc_k_lines_b subline
7908: Where inshist.instance_id = custprod_id(i)
7909: and batch_id = p_batch_id
7910: and hdr.id = new_contract_id(i)

Line 7907: , okc_k_lines_b subline

7903: fnd_global.login_id
7904: from Oks_instance_history inshist
7905: , okc_k_headers_all_b hdr
7906: , okc_k_lines_b line
7907: , okc_k_lines_b subline
7908: Where inshist.instance_id = custprod_id(i)
7909: and batch_id = p_batch_id
7910: and hdr.id = new_contract_id(i)
7911: and line.id = new_line_id(i)

Line 8018: UPDATE okc_k_lines_b

8014: END LOOP;
8015:
8016: -- Update Subline dates
8017: FORALL i IN 1 .. subline_id.COUNT
8018: UPDATE okc_k_lines_b
8019: SET start_date = idc_date (i),
8020: end_date = new_edt (i),
8021: sts_code = get_status (idc_date (i), new_edt (i))
8022:

Line 8051: UPDATE okc_k_lines_b

8047:
8048: Close l_topline_csr;
8049:
8050: Forall i in 1..top_line_id.count
8051: UPDATE okc_k_lines_b
8052: SET start_date = line_new_Sdate (i),
8053: end_date = line_new_edate (i),
8054: sts_code = get_status (line_new_Sdate(i), line_new_edate(i))
8055: --invoice_text = inv_text(i)

Line 8278: , okc_k_lines_b line

8274: SYSDATE,
8275: fnd_global.login_id,
8276: null
8277: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8278: , okc_k_lines_b line
8279: , okc_k_lines_b subline
8280: WHERE a.batch_id = p_batch_id
8281: AND a.transaction_type = 'IDC'
8282: AND a.instance_id = custprod_id(i)

Line 8279: , okc_k_lines_b subline

8275: fnd_global.login_id,
8276: null
8277: FROM oks_instance_history a, Okc_k_headers_all_b hdr
8278: , okc_k_lines_b line
8279: , okc_k_lines_b subline
8280: WHERE a.batch_id = p_batch_id
8281: AND a.transaction_type = 'IDC'
8282: AND a.instance_id = custprod_id(i)
8283: And hdr.id = contract_id(i)

Line 8610: Okc_k_lines_b line,

8606: SYSDATE,
8607: fnd_global.login_id,
8608: line.date_cancelled
8609: FROM oks_instance_history a,
8610: Okc_k_lines_b line,
8611: Okc_k_headers_all_b hdr
8612: WHERE a.batch_id = p_batch_id
8613: AND a.transaction_type = 'TRM'
8614: AND a.instance_id = custprod_id(i)