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_INSTANCE_HISTORY

Line 547: From Oks_instance_history ih

543: Function Get_actual_transferamount(p_line_id Number, P_batch_id Number, P_line_type Varchar2) return Number Is
544:
545: Cursor l_amt_csr Is
546: Select nvl(instance_amt_new,0)
547: From Oks_instance_history ih
548: , Oks_inst_hist_details id
549: Where ih.batch_id = p_batch_id
550: And id.ins_id = ih.id
551: And id.old_subline_id = p_line_id

Line 556: From Oks_instance_history ih

552: And id.old_subline_id <> id.new_subline_id;
553:
554: Cursor l_line_amt_csr Is
555: Select nvl(sum(instance_amt_new),0)
556: From Oks_instance_history ih
557: , Oks_inst_hist_details id
558: Where ih.batch_id = p_batch_id
559: And id.ins_id = ih.id
560: And id.old_service_line_id = p_line_id

Line 566: From Oks_instance_history ih

562:
563:
564: Cursor l_Hdr_amt_csr Is
565: Select sum(instance_amt_new)
566: From Oks_instance_history ih
567: , Oks_inst_hist_details id
568: Where ih.batch_id = p_batch_id
569: And id.ins_id = ih.id
570: And id.old_contract_id = p_line_id

Line 612: , Oks_instance_history ih

608: Function Get_actual_creditamount(p_line_id Number, P_batch_id Number, P_line_type Varchar2) return Number Is
609: Cursor l_credit_csr Is
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

Line 628: , Oks_instance_history ih

624: Cursor l_tl_credit_csr Is
625:
626: Select nvl(sum(bill.amount),0)
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

Line 647: , Oks_instance_history ih

643: Cursor l_Hdr_credit_csr Is
644: Select nvl(sum(bill.amount),0)
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

Line 706: , Oks_instance_history ih

702:
703: Cursor l_billed_csr Is
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

Line 720: , Oks_instance_history ih

716: Cursor l_tl_billed_csr Is
717:
718: Select nvl(sum(bill.amount),0)
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

Line 737: , Oks_instance_history ih

733: Cursor l_Hdr_billed_csr Is
734: Select nvl(sum(bill.amount),0)
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