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_IB_UTIL_PVT dependencies on OKS_BILL_CONT_LINES

Line 614: , Oks_bill_cont_lines bcl

610: Select NVL (SUM (bill.amount), 0)
611: From Oks_bill_sub_lines bill
612: , Oks_instance_history ih
613: , Oks_inst_hist_details id
614: , Oks_bill_cont_lines bcl
615: Where bill.cle_id = id.old_subline_id
616: And ih.batch_id = p_batch_id
617: And id.ins_id = ih.id
618: And id.old_subline_id = p_line_id

Line 631: , Oks_bill_cont_lines bcl

627: From Oks_bill_sub_lines bill
628: , Oks_instance_history ih
629: , Oks_inst_hist_details id
630: , Okc_k_lines_b Kl
631: , Oks_bill_cont_lines bcl
632: Where ih.batch_id = p_batch_id
633: And id.ins_id = ih.id
634: And bill.cle_id = Kl.Id
635: And Kl.cle_Id = id.old_service_line_id

Line 649: , Oks_bill_cont_lines bcl

645: From Okc_k_lines_b kl
646: , Oks_bill_sub_lines bill
647: , Oks_instance_history ih
648: , Oks_inst_hist_details id
649: , Oks_bill_cont_lines bcl
650: Where ih.batch_id = p_batch_id
651: And id.ins_id = ih.id
652: And bill.cle_id = kl.Id
653: And Kl.dnz_chr_id = id.old_contract_id

Line 708: , Oks_bill_cont_lines bcl

704: Select NVL (SUM (bill.amount), 0)
705: From Oks_bill_sub_lines bill
706: , Oks_instance_history ih
707: , Oks_inst_hist_details id
708: , Oks_bill_cont_lines bcl
709: Where bill.cle_id = id.old_subline_id
710: And ih.batch_id = p_batch_id
711: And id.ins_id = ih.id
712: And id.old_subline_id = p_line_id

Line 723: , Oks_bill_cont_lines bcl

719: From Oks_bill_sub_lines bill
720: , Oks_instance_history ih
721: , Oks_inst_hist_details id
722: , Okc_k_lines_b Kl
723: , Oks_bill_cont_lines bcl
724: Where ih.batch_id = p_batch_id
725: And id.ins_id = ih.id
726: And bill.cle_id = Kl.Id
727: And Kl.cle_Id = id.old_service_line_id

Line 739: , Oks_bill_cont_lines bcl

735: From Okc_k_lines_b kl
736: , Oks_bill_sub_lines bill
737: , Oks_instance_history ih
738: , Oks_inst_hist_details id
739: , Oks_bill_cont_lines bcl
740: Where ih.batch_id = p_batch_id
741: And id.ins_id = ih.id
742: And bill.cle_id = kl.Id
743: And Kl.dnz_chr_id = id.old_contract_id