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 3607: INSERT INTO oks_k_lines_b

3603: END IF;
3604:
3605: -- create oks line
3606: FORALL i IN 1 .. l_tabsize
3607: INSERT INTO oks_k_lines_b
3608: (ID,
3609: cle_id,
3610: dnz_chr_id,
3611: acct_rule_id,

Line 4089: INSERT INTO oks_k_lines_b

4085: END IF;
4086:
4087: -- create oks line
4088: FORALL i IN 1 .. l_tabsize
4089: INSERT INTO oks_k_lines_b
4090: (ID,
4091: cle_id,
4092: dnz_chr_id,
4093: tax_code,

Line 4493: , oks_k_lines_b Ks

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

Line 4696: Update Oks_k_lines_b set coverage_id = l_coverage_id

4692: THEN
4693:
4694: RAISE g_exception_halt_validation;
4695: Else
4696: Update Oks_k_lines_b set coverage_id = l_coverage_id
4697: Where cle_id = srvline_id (Line_ctr);
4698: END IF;
4699:
4700:

Line 4990: Update oks_k_lines_b

4986: Else
4987: l_tax_amount := Nvl(G_RAIL_REC.tax_value,0) ;
4988: End If;
4989:
4990: Update oks_k_lines_b
4991: set tax_amount = l_tax_amount, tax_inclusive_yn = l_tax_inclusive_yn
4992: Where cle_id = subline_id(subline_ctr );
4993:
4994: End loop;

Line 4997: Update oks_k_lines_b

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

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

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,
6127: okc_k_lines_b kl2,
6128: oks_instance_temp tmp,
6129: okc_k_party_roles_b party

Line 6126: oks_k_lines_b ks2,

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

Line 6215: oks_k_lines_b okl,

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

Line 6216: oks_k_lines_b okl1,

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,
6219: oks_instance_temp tmp,
6220: okc_statuses_b Hst

Line 6430: oks_k_lines_b ks11

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

Line 8036: WHERE id = (select id from oks_k_lines_b

8032:
8033: Forall i in 1..sub_line_id.count
8034: UPDATE oks_k_lines_v
8035: SET invoice_text = inv_text(i)
8036: WHERE id = (select id from oks_k_lines_b
8037: where cle_id = sub_line_id(i));
8038:
8039:
8040:

Line 8069: WHERE id = (select id from oks_k_lines_b

8065:
8066: Forall i in 1..top_line_id.count
8067: UPDATE oks_k_lines_tl
8068: SET invoice_text = inv_text(i)
8069: WHERE id = (select id from oks_k_lines_b
8070: where cle_id = top_line_id(i));
8071: -- Update Header dates
8072: header_id.delete;
8073: Open l_Contract_csr;