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 OKL_PROD_QLTY_VAL_UV

Line 331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

327:
328: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
329: ,p_date IN DATE) RETURN VARCHAR2 IS
330:
331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
332: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
333: SELECT pdt.quality_val revenue_recognition_method
334: FROM OKL_PROD_QLTY_VAL_UV pdt,
335: OKL_K_HEADERS_FULL_V khr

Line 334: FROM OKL_PROD_QLTY_VAL_UV pdt,

330:
331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
332: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
333: SELECT pdt.quality_val revenue_recognition_method
334: FROM OKL_PROD_QLTY_VAL_UV pdt,
335: OKL_K_HEADERS_FULL_V khr
336: WHERE khr.id = p_chr_id
337: AND khr.pdt_id = pdt.pdt_id
338: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'

Line 9015: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

9011: l_data_found BOOLEAN := FALSE;
9012: l_num_workers NUMBER;
9013: l_worker_id VARCHAR2(2000);
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,

Line 9020: OKL_PROD_QLTY_VAL_UV pdt

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')
9023: AND chr.id = khr.id
9024: AND khr.pdt_id = pdt.pdt_id

Line 9094: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

9090:
9091: -- -- Cursor to select contracts for accrual processing
9092: -- -- modified cursor to select only lease contracts
9093: -- -- bug#2618966
9094: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
9095: CURSOR accrual_contract_csr IS
9096: SELECT chr.id
9097: ,chr.contract_number
9098: ,chr.start_date

Line 9110: OKL_PROD_QLTY_VAL_UV pdt

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
9113: AND chr.scs_code = 'LEASE'
9114: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 10055: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

10051: l_accrual_date DATE;
10052: l_process_accrual_rec process_accrual_rec_type;
10053: l_rev_rec_method VARCHAR2(2000);
10054:
10055: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10056: CURSOR accrual_contract_csr (p_khr_id NUMBER) IS
10057: SELECT chr.contract_number
10058: ,chr.start_date
10059: ,chr.sts_code

Line 10071: OKL_PROD_QLTY_VAL_UV pdt

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
10074: AND chr.scs_code = 'LEASE'
10075: AND chr.sts_code IN ('BOOKED','EVERGREEN')