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 OKC_K_HEADERS_ALL_B

Line 58: FROM okc_k_headers_all_b chr

54: ,chr.sts_code sts_code
55: ,hr_org.NAME hr_org_name
56: ,khr.pdt_id pdt_id
57: ,chr.scs_code scs_code
58: FROM okc_k_headers_all_b chr
59: ,okl_k_headers khr
60: ,hr_all_organization_units hr_org
61: WHERE khr.id = l_khr_id
62: AND chr.id = khr.id

Line 121: ,okc_k_headers_all_b ia_chr

117: ,ia_chr.contract_number ia_contract_number
118: ,ia_chr.START_DATE ia_start_date
119: ,ia_pdt.NAME ia_product_name
120: FROM okl_pool_contents ia_pool_c
121: ,okc_k_headers_all_b ia_chr
122: ,okl_k_headers ia_khr
123: ,okl_products ia_pdt
124: ,okl_pools_all ia_pool
125: WHERE ia_pool_c.sty_code = p_sty_type

Line 204: FROM okc_k_headers_all_b chr_cr_master

200: ,decode(chr_cr_master.scs_code,'MASTER_LEASE'
201: ,chr_cr_master.contract_number, NULL) master_lease_number
202: ,decode(chr_cr_master.scs_code,'MASTER_LEASE'
203: ,chr_cr_master.id, TO_NUMBER(NULL)) master_lease_id
204: FROM okc_k_headers_all_b chr_cr_master
205: ,okc_governances governances
206: WHERE governances.dnz_chr_id = l_khr_id
207: AND governances.chr_id_referred = chr_cr_master.ID
208: AND chr_cr_master.scs_code in ('CREDITLINE_CONTRACT', 'MASTER_LEASE');

Line 214: FROM okc_k_headers_all_b crline_sub_chr

210: -- Sometimes credit line may be associated with Master Lease instead with a contract
211: CURSOR c_creditline_sub_csr (l_mla_chr_id NUMBER)
212: IS
213: SELECT crline_sub_chr.contract_number
214: FROM okc_k_headers_all_b crline_sub_chr
215: ,okc_governances crline_gov
216: WHERE crline_gov.dnz_chr_id = l_mla_chr_id
217: AND crline_gov.chr_id_referred = crline_sub_chr.id
218: AND crline_sub_chr.scs_code = 'CREDITLINE_CONTRACT';

Line 224: FROM okc_k_headers_all_b vp_chr

220: -- Cursor to fetch the Vendor Program Agreement Number
221: CURSOR c_vendor_program_number_csr (p_khr_id NUMBER)
222: IS
223: SELECT vp_chr.contract_number
224: FROM okc_k_headers_all_b vp_chr
225: ,okl_k_headers khr
226: WHERE vp_chr.id = khr.khr_id
227: AND vp_chr.scs_code = 'PROGRAM'
228: AND khr.id = p_khr_id;

Line 357: FROM okc_k_headers_all_b khr

353: CURSOR c_inventory_org_id_csr( p_khr_id NUMBER )
354: IS
355: SELECT khr.inv_organization_id inv_organization_id
356: ,hrb.NAME hrb_name
357: FROM okc_k_headers_all_b khr
358: ,hr_all_organization_units hrb
359: WHERE khr.id = p_khr_id
360: AND hrb.organization_id = khr.inv_organization_id;
361:

Line 366: ,okc_k_headers_all_b cntrct

362: CURSOR c_khr_to_ledger_id_csr( p_khr_id NUMBER )
363: IS
364: SELECT set_of_books_id ledger_id
365: FROM okl_sys_acct_opts_all sysop
366: ,okc_k_headers_all_b cntrct
367: WHERE cntrct.id = p_khr_id
368: AND cntrct.authoring_org_id = sysop.org_id;
369:
370: -- for khr category and attributes

Line 580: FROM okc_k_headers_all_b invc

576: ,pol.pool_number inv_agrmnt_pool_number
577: ,invc.currency_code inv_agrmnt_currency_code
578: ,invc.START_DATE inv_agrmnt_effective_from
579: ,invc.sts_code inv_agrmnt_status_code
580: FROM okc_k_headers_all_b invc
581: ,okl_k_headers invk
582: ,okl_pools_all pol
583: WHERE invc.id = invk.id
584: AND invc.scs_code = G_INVESTOR

Line 988: l_cust_acct_id okc_k_headers_all_b.cust_acct_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;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;
992: l_acc_sources_rec asev_rec_type;

Line 989: l_rent_ia_chr_id okc_k_headers_all_b.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;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;
992: l_acc_sources_rec asev_rec_type;
993: -- Local Variables for enabling the Debug Statements

Line 990: l_res_ia_chr_id okc_k_headers_all_b.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;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;
992: l_acc_sources_rec asev_rec_type;
993: -- Local Variables for enabling the Debug Statements
994: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

Line 991: l_master_lease_id okc_k_headers_all_b.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;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;
992: l_acc_sources_rec asev_rec_type;
993: -- Local Variables for enabling the Debug Statements
994: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
995: l_debug_enabled VARCHAR2(10);

Line 8262: ,okc_k_headers_all_b chr

8258: ,chr.contract_number contract_number
8259: ,COUNT(fa_dep.asset_id) no_of_assets
8260: FROM fa_deprn_summary fa_dep
8261: ,fa_books fa_books
8262: ,okc_k_headers_all_b chr
8263: WHERE -- Predicates on fa_deprn_summary
8264: fa_dep.book_type_code = p_book_type_code
8265: AND fa_dep.period_counter = p_period_counter
8266: AND fa_dep.deprn_source_code = 'DEPRN'

Line 8277: -- Join conditions between fa_books and okc_k_headers_all_b

8273: AND fa_books.contract_id IS NOT NULL
8274: -- Join Conditions between fa_deprn_summary and fa_books
8275: AND fa_dep.asset_id = fa_books.asset_id
8276: AND fa_dep.book_type_code = fa_books.book_type_code
8277: -- Join conditions between fa_books and okc_k_headers_all_b
8278: AND fa_books.contract_id = chr.id
8279: GROUP BY chr.id, CHR.contract_number
8280: ORDER BY COUNT(fa_dep.asset_id) DESC;
8281: