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_GENERATE_ACCRUALS_PVT dependencies on OKC_K_HEADERS_B

Line 232: SELECT 'Y' FROM okc_k_headers_b chr

228: RETURN VARCHAR2
229: IS
230: -- A complex query to find out if a contract has syndication
231: CURSOR syndicate_flag_csr(p_contract_id NUMBER) IS
232: SELECT 'Y' FROM okc_k_headers_b chr
233: WHERE id = p_contract_id
234: AND EXISTS
235: (
236: SELECT 'x' FROM okc_k_items cim

Line 247: SELECT 'x' FROM okc_k_headers_b chr2

243: AND cle.id = cim.cle_id
244: )
245: AND EXISTS
246: (
247: SELECT 'x' FROM okc_k_headers_b chr2
248: WHERE chr2.id = cim.dnz_chr_id
249: AND chr2.scs_code = 'SYNDICATION'
250: AND chr2.sts_code not in ('TERMINATED','ABANDONED')
251: )

Line 351: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,

347: CURSOR get_contract_number_csr(p_chr_id NUMBER) IS
348: SELECT a.contract_number,
349: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
350: c.reporting_pdt_id -- MGAAP 7263041
351: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
352: OKL_PRODUCTS C
353: WHERE A.id = p_chr_id
354: AND A.id = B.id
355: AND B.PDT_ID = C.ID;

Line 371: FROM OKC_K_HEADERS_B CHR

367: --Bug 4740605.Added TRUNC
368: CURSOR check_streams_accrual_csr(p_chr_id NUMBER, p_accrue_till_date DATE,
369: p_reporting_pdt_id NUMBER) IS -- MGAAP
370: SELECT 'N'
371: FROM OKC_K_HEADERS_B CHR
372: WHERE id = p_chr_id
373: AND EXISTS (
374: SELECT 1
375: FROM OKL_STRM_TYPE_B sty,

Line 406: FROM OKC_K_HEADERS_B

402: WHERE ID = p_khr_id;
403:
404: CURSOR khr_start_date_csr IS
405: SELECT TRUNC(start_date)
406: FROM OKC_K_HEADERS_B
407: WHERE ID = p_khr_id;
408:
409: --Bug 5036337
410: CURSOR check_actual_trx(p_khr_id NUMBER) IS

Line 1034: FROM OKC_K_HEADERS_B CHR,

1030: -- Get Contract Salesperson
1031: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
1032: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS
1033: SELECT con.object1_id1
1034: FROM OKC_K_HEADERS_B CHR,
1035: OKC_CONTACT_SOURCES cso,
1036: OKC_K_PARTY_ROLES_B kpr,
1037: OKC_CONTACTS con
1038: WHERE CHR.id = cp_chr_id

Line 1063: FROM OKC_K_HEADERS_B

1059:
1060: -- cursor to get bill-to-site of customer at contract level
1061: CURSOR chr_bill_to_site_csr (p_chr_id NUMBER) IS
1062: SELECT bill_to_site_use_id
1063: FROM OKC_K_HEADERS_B
1064: WHERE id = p_chr_id;
1065:
1066: l_sales_person_id OKC_CONTACTS_V.OBJECT1_ID1%TYPE;
1067: l_counter NUMBER := 1;

Line 2258: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

2254: khr.generate_accrual_yn,
2255: khr.generate_accrual_override_yn,
2256: khr.deal_type,
2257: pdt.reporting_pdt_id -- MGAAP 7263014
2258: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2259: OKL_PRODUCTS pdt
2260: WHERE chr.id = p_ctr_id
2261: AND chr.id = khr.id
2262: AND khr.pdt_id = pdt.id;

Line 2818: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

2814: ,khr.currency_conversion_type
2815: ,khr.currency_conversion_rate
2816: ,khr.currency_conversion_date
2817: ,pdt.reporting_pdt_id
2818: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2819: OKL_PRODUCTS pdt --MGAAP 7263041
2820: WHERE chr.id = p_khr_id
2821: AND chr.id = khr.id
2822: AND khr.pdt_id = pdt.id;

Line 3704: FROM OKC_K_HEADERS_B

3700:
3701: -- Cursor to select Contract Number
3702: CURSOR get_contract_number_csr(p_ctr_id NUMBER) IS
3703: SELECT contract_number
3704: FROM OKC_K_HEADERS_B
3705: WHERE id = p_ctr_id;
3706:
3707: -- Cursor to select accrual transactions for cancellation using specified tcn_type
3708: CURSOR reverse_trx_csr IS

Line 3940: FROM OKC_K_HEADERS_B

3936:
3937: -- Cursor to select Contract Number
3938: CURSOR get_contract_number_csr(p_ctr_id NUMBER) IS
3939: SELECT contract_number
3940: FROM OKC_K_HEADERS_B
3941: WHERE id = p_ctr_id;
3942:
3943: -- Cursor to select accrual transactions for cancellation
3944: CURSOR reverse_trx_csr(p_khr_id NUMBER) IS

Line 9018: FROM OKC_K_HEADERS_B chr,

9014:
9015: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
9016: CURSOR chk_update_header_csr is
9017: SELECT chr.contract_number
9018: FROM OKC_K_HEADERS_B chr,
9019: OKL_K_HEADERS khr,
9020: OKL_PROD_QLTY_VAL_UV pdt
9021: WHERE chr.scs_code = 'LEASE'
9022: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 9030: FROM OKC_K_HEADERS_B chr,

9026: AND pdt.quality_val = p_rev_rec_method
9027: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
9028: UNION
9029: SELECT chr.contract_number
9030: FROM OKC_K_HEADERS_B chr,
9031: OKL_K_HEADERS khr
9032: WHERE chr.scs_code = 'INVESTOR'
9033: AND chr.sts_code = 'ACTIVE'
9034: AND chr.id = khr.id

Line 9041: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp

9037:
9038: CURSOR chk_data_volume_csr(p_seq_next VARCHAR2 ) IS
9039: SELECT chr.contract_number contract_number
9040: ,count(cle.id) line_count
9041: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
9042: WHERE opp.object_value = chr.contract_number
9043: AND opp.assigned_process = p_seq_next
9044: AND opp.object_type = 'ACCRUAL_CONTRACT'
9045: AND chr.scs_code = 'LEASE'

Line 9053: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp

9049: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
9050: UNION
9051: SELECT chr.contract_number contract_number
9052: ,count(cle.id) line_count
9053: FROM OKC_K_HEADERS_B chr, OKC_K_LINES_B cle, okl_parallel_processes opp
9054: WHERE opp.object_value = chr.contract_number
9055: AND opp.assigned_process = p_seq_next
9056: AND opp.object_type = 'ACCRUAL_CONTRACT'
9057: AND chr.scs_code = 'INVESTOR'

Line 9108: FROM OKC_K_HEADERS_B chr,

9104: ,chr.currency_code
9105: ,khr.currency_conversion_type
9106: ,khr.currency_conversion_rate
9107: ,khr.currency_conversion_date
9108: FROM OKC_K_HEADERS_B chr,
9109: OKL_K_HEADERS khr,
9110: OKL_PROD_QLTY_VAL_UV pdt
9111: WHERE chr.contract_number = p_contract_number
9112: AND chr.id = khr.id

Line 9132: FROM OKC_K_HEADERS_B chr,

9128: ,chr.currency_code
9129: ,khr.currency_conversion_type
9130: ,khr.currency_conversion_rate
9131: ,khr.currency_conversion_date
9132: FROM OKC_K_HEADERS_B chr,
9133: OKL_K_HEADERS khr
9134: WHERE chr.contract_number = p_contract_number
9135: AND chr.id = khr.id
9136: AND chr.scs_code = 'INVESTOR'

Line 9698: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

9694: ,chr.currency_code
9695: ,khr.currency_conversion_type
9696: ,khr.currency_conversion_rate
9697: ,khr.currency_conversion_date
9698: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
9699: WHERE chr.contract_number = p_khr_num
9700: AND chr.id = khr.id
9701: AND chr.scs_code = 'LEASE'
9702: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 9717: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

9713: ,chr.currency_code
9714: ,khr.currency_conversion_type
9715: ,khr.currency_conversion_rate
9716: ,khr.currency_conversion_date
9717: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
9718: WHERE chr.contract_number = p_khr_num
9719: AND chr.id = khr.id
9720: AND chr.scs_code = 'INVESTOR'
9721: AND chr.sts_code = 'ACTIVE'

Line 9745: TYPE contract_number_tbl_type IS TABLE OF OKC_K_HEADERS_B.contract_number%TYPE INDEX BY BINARY_INTEGER;

9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
9742:
9743: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
9744: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;
9745: TYPE contract_number_tbl_type IS TABLE OF OKC_K_HEADERS_B.contract_number%TYPE INDEX BY BINARY_INTEGER;
9746:
9747: l_contract_num_tbl contract_number_tbl_type;
9748: l_contract_error_tbl contract_error_tbl_type;
9749: l_accrual_contracts_tbl accrual_contracts_tbl_type; -- Bug# 3020763

Line 10069: FROM OKC_K_HEADERS_B chr,

10065: ,khr.currency_conversion_type
10066: ,khr.currency_conversion_rate
10067: ,khr.currency_conversion_date
10068: ,pdt.quality_val revenue_recognition_method
10069: FROM OKC_K_HEADERS_B chr,
10070: OKL_K_HEADERS khr,
10071: OKL_PROD_QLTY_VAL_UV pdt
10072: WHERE chr.id = p_khr_id
10073: AND chr.id = khr.id

Line 10092: FROM OKC_K_HEADERS_B chr,

10088: ,khr.currency_conversion_type
10089: ,khr.currency_conversion_rate
10090: ,khr.currency_conversion_date
10091: ,'STREAMS' revenue_recognition_method
10092: FROM OKC_K_HEADERS_B chr,
10093: OKL_K_HEADERS khr
10094: WHERE chr.id = p_khr_id
10095: AND chr.id = khr.id
10096: AND chr.scs_code = 'INVESTOR'