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 730: ,okl_trx_contracts_all rel_trx

726: qte.date_accepted quote_accepted_date,
727: qte.qtp_code quote_type
728:
729: FROM okl_trx_types_b trx_b
730: ,okl_trx_contracts_all rel_trx
731: ,okl_trx_quotes_all_b qte
732: ,okl_txl_quote_lines_b qtl
733: WHERE trx_b.trx_type_class = 'TERMINATION'
734: AND trx_b.id = rel_trx.try_id

Line 985: FROM okl_trx_contracts_all tcn

981: ,tcn.set_of_books_id ledger_id
982: ,try.accounting_event_class_code accounting_event_class_code
983: ,try.id try_id
984: ,tcn_type tcn_type
985: FROM okl_trx_contracts_all tcn
986: ,okl_trx_types_b try
987: WHERE tcn.id = p_source_id
988: AND tcn.try_id = try.id
989: AND try.accounting_event_class_code IS NOT NULL;

Line 1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;

1006: l_trx_type_name_rec c_trx_type_name_csr%ROWTYPE;
1007: l_termination_qte_csr_rec c_termination_qte_csr%ROWTYPE;
1008: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
1009: -- Local Variables
1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;

Line 1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;

1007: l_termination_qte_csr_rec c_termination_qte_csr%ROWTYPE;
1008: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
1009: -- Local Variables
1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
1015: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;

Line 1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;

1008: l_inv_agrmnt_details_rec c_inv_agrmnt_details_csr%ROWTYPE;
1009: -- Local Variables
1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
1015: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
1016: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;

Line 1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;

1009: -- Local Variables
1010: l_khr_id okl_trx_contracts_all.khr_id%TYPE;
1011: l_qte_id okl_trx_contracts_all.qte_id%TYPE;
1012: l_pdt_id okl_trx_contracts_all.pdt_id%TYPE;
1013: l_ledger_id okl_trx_contracts_all.set_of_books_id%TYPE;
1014: l_accounting_event_class_code okl_trx_types_b.accounting_event_class_code%TYPE;
1015: l_cust_acct_id okc_k_headers_all_b.cust_acct_id%TYPE;
1016: l_rent_ia_chr_id okc_k_headers_all_b.id%TYPE;
1017: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;

Line 1644: ,okl_trx_contracts_all tcn

1640: ,tcl.sty_id
1641: ,tcn.set_of_books_id ledger_id
1642: ,try.accounting_event_class_code
1643: FROM okl_txl_cntrct_lns_all tcl
1644: ,okl_trx_contracts_all tcn
1645: ,okl_trx_types_b try
1646: WHERE tcl.id = p_source_id
1647: AND tcl.tcn_id = tcn.id
1648: AND try.id = tcn.try_id

Line 2206: FROM okl_trx_contracts_all tcn

2202: SELECT tcn.id tcn_id
2203: ,tcn.khr_id khr_id
2204: ,tcn.set_of_books_id ledger_id
2205: ,try.accounting_event_class_code accounting_event_class_code
2206: FROM okl_trx_contracts_all tcn
2207: ,okl_trx_types_b try
2208: WHERE tcn.id = p_tcn_id
2209: AND tcn.try_id = try.id
2210: AND try.accounting_event_class_code IS NOT NULL;

Line 5111: FROM okl_trx_contracts_all tcn

5107: --
5108: CURSOR get_tai_tcn_qte_id_csr( p_tcn_id NUMBER)
5109: IS
5110: SELECT tcn.qte_id qte_id
5111: FROM okl_trx_contracts_all tcn
5112: WHERE tcn.id = p_tcn_id;
5113: -----------------------------------------------------------------
5114: -- Declare Process Variable
5115: -----------------------------------------------------------------