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_INST_HIST_DETAILS

Line 548: , Oks_inst_hist_details id

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
552: And id.old_subline_id <> id.new_subline_id;

Line 557: , Oks_inst_hist_details 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
561: And id.old_service_line_id <> id.new_service_line_id ;

Line 567: , Oks_inst_hist_details id

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
571: And id.old_contract_id <> id.new_contract_id ;

Line 613: , Oks_inst_hist_details id

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
617: And id.ins_id = ih.id

Line 629: , Oks_inst_hist_details id

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
633: And id.ins_id = ih.id

Line 648: , Oks_inst_hist_details id

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
652: And bill.cle_id = kl.Id

Line 707: , Oks_inst_hist_details id

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
711: And id.ins_id = ih.id

Line 721: , Oks_inst_hist_details id

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
725: And id.ins_id = ih.id

Line 738: , Oks_inst_hist_details id

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
742: And bill.cle_id = kl.Id