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_K_LINES_B

Line 87: --| OKS_K_LINES_B | X | X | | | | |

83: --| OKC_K_LINES_B | X | X | X | | | |
84: --+---------------------------------+---+---+---+---+---+----------------------+
85: --| OKC_K_LINES_TL | | X | | | | |
86: --+---------------------------------+---+---+---+---+---+----------------------+
87: --| OKS_K_LINES_B | X | X | | | | |
88: --+---------------------------------+---+---+---+---+---+----------------------+
89: --| OKS_K_LINES_TL | | X | | | | |
90: --+---------------------------------+---+---+---+---+---+----------------------+
91: --| OKS_BILLING_PROFILES_B | X | | | | | |

Line 3612: INSERT INTO oks_k_lines_b

3608: END IF;
3609:
3610: -- create oks line
3611: FORALL i IN 1 .. l_tabsize
3612: INSERT INTO oks_k_lines_b
3613: (ID,
3614: cle_id,
3615: dnz_chr_id,
3616: acct_rule_id,

Line 4094: INSERT INTO oks_k_lines_b

4090: END IF;
4091:
4092: -- create oks line
4093: FORALL i IN 1 .. l_tabsize
4094: INSERT INTO oks_k_lines_b
4095: (ID,
4096: cle_id,
4097: dnz_chr_id,
4098: tax_code,

Line 4498: , oks_k_lines_b Ks

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
4502: And Kl.Id = temp.topline_id

Line 4701: Update Oks_k_lines_b set coverage_id = l_coverage_id

4697: THEN
4698:
4699: RAISE g_exception_halt_validation;
4700: Else
4701: Update Oks_k_lines_b set coverage_id = l_coverage_id
4702: Where cle_id = srvline_id (Line_ctr);
4703: END IF;
4704:
4705:

Line 4995: Update oks_k_lines_b

4991: Else
4992: l_tax_amount := Nvl(G_RAIL_REC.tax_value,0) ;
4993: End If;
4994:
4995: Update oks_k_lines_b
4996: set tax_amount = l_tax_amount, tax_inclusive_yn = l_tax_inclusive_yn
4997: Where cle_id = subline_id(subline_ctr );
4998:
4999: End loop;

Line 5002: Update oks_k_lines_b

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

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 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 6142: oks_k_lines_b ks1,

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,
6144: okc_k_lines_b kl2,
6145: oks_instance_temp tmp,
6146: okc_k_party_roles_b party

Line 6143: oks_k_lines_b ks2,

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,
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)

Line 6232: oks_k_lines_b okl,

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,
6236: oks_instance_temp tmp,

Line 6233: oks_k_lines_b okl1,

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,
6236: oks_instance_temp tmp,
6237: okc_statuses_b Hst

Line 6447: oks_k_lines_b ks11

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'
6450: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6451: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 8059: WHERE id = (select id from oks_k_lines_b

8055: SET invoice_text = inv_text(i),
8056: last_updated_by = fnd_global.user_id,
8057: last_update_date = SYSDATE,
8058: last_update_login = fnd_global.login_id
8059: WHERE id = (select id from oks_k_lines_b
8060: where cle_id = sub_line_id(i))
8061: AND klt.language = USERENV('LANG');
8062: END IF; --Added for Bug#14183916
8063:

Line 8098: WHERE id = (select id from oks_k_lines_b

8094: SET invoice_text = inv_text(i),
8095: last_updated_by = fnd_global.user_id,
8096: last_update_date = SYSDATE,
8097: last_update_login = fnd_global.login_id
8098: WHERE id = (select id from oks_k_lines_b
8099: where cle_id = top_line_id(i));
8100: -- Update Header dates
8101: header_id.delete;
8102: Open l_Contract_csr;