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.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 710: ,okl_trx_contracts_all rel_trx

706: SELECT qte.quote_number quote_number
707: ,qte.date_accepted quote_accepted_date
708: ,qte.qtp_code quote_type
709: FROM okl_trx_types_b trx_b
710: ,okl_trx_contracts_all rel_trx
711: ,okl_trx_quotes_all_b qte
712: WHERE trx_b.trx_type_class = 'RE_LEASE'
713: AND trx_b.id = rel_trx.try_id
714: AND rel_trx.khr_id_new = p_khr_id

Line 958: FROM okl_trx_contracts_all tcn

954: ,tcn.set_of_books_id ledger_id
955: ,try.accounting_event_class_code accounting_event_class_code
956: ,try.id try_id
957: ,tcn_type tcn_type
958: FROM okl_trx_contracts_all tcn
959: ,okl_trx_types_b try
960: WHERE tcn.id = p_source_id
961: AND tcn.try_id = try.id
962: AND try.accounting_event_class_code IS NOT NULL;

Line 983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;

979: l_trx_type_name_rec c_trx_type_name_csr%ROWTYPE;
980: l_termination_qte_csr_rec c_termination_qte_csr%ROWTYPE;
981: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
982: -- Local Variables
983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;

Line 984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;

980: l_termination_qte_csr_rec c_termination_qte_csr%ROWTYPE;
981: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
982: -- Local Variables
983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
988: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;

Line 985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;

981: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
982: -- Local Variables
983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
988: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
989: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;

Line 986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;

982: -- Local Variables
983: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
984: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
985: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
986: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
987: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
988: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
989: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;
990: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;

Line 1617: ,okl_trx_contracts_all tcn

1613: ,tcl.sty_id
1614: ,tcn.set_of_books_id ledger_id
1615: ,try.accounting_event_class_code
1616: FROM okl_txl_cntrct_lns_all tcl
1617: ,okl_trx_contracts_all tcn
1618: ,okl_trx_types_b try
1619: WHERE tcl.id = p_source_id
1620: AND tcl.tcn_id = tcn.id
1621: AND try.id = tcn.try_id

Line 2179: FROM okl_trx_contracts_all tcn

2175: SELECT tcn.id tcn_id
2176: ,tcn.khr_id khr_id
2177: ,tcn.set_of_books_id ledger_id
2178: ,try.accounting_event_class_code accounting_event_class_code
2179: FROM okl_trx_contracts_all tcn
2180: ,okl_trx_types_b try
2181: WHERE tcn.id = p_tcn_id
2182: AND tcn.try_id = try.id
2183: AND try.accounting_event_class_code IS NOT NULL;

Line 5001: FROM okl_trx_contracts_all tcn

4997: --
4998: CURSOR get_tai_tcn_qte_id_csr( p_tcn_id NUMBER)
4999: IS
5000: SELECT tcn.qte_id qte_id
5001: FROM okl_trx_contracts_all tcn
5002: WHERE tcn.id = p_tcn_id;
5003: -----------------------------------------------------------------
5004: -- Declare Process Variable
5005: -----------------------------------------------------------------