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_LA_STREAM_PVT dependencies on OKL_PRODUCTS

Line 3948: okl_products_v pdt

3944: khr.term_duration term,
3945: chr.orig_system_id1
3946: FROM okc_k_headers_v chr,
3947: okl_k_headers khr,
3948: okl_products_v pdt
3949: WHERE khr.id = chr.id
3950: AND chr.id = chrId
3951: AND khr.pdt_id = pdt.id(+);
3952: -- Get the Stream id

Line 6625: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,

6621: and ole.lse_id = cle.lse_id
6622: and ole.id=cle.orig_system_id1;
6623: --smadhava - Bug# 6149951 - Added - End
6624: --Added by vdamerla for bug 6149951
6625: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6626: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6627: SELECT 'Y'
6628: FROM OKL_STRM_TYPE_B sty,
6629: OKL_PROD_STRM_TYPES psty

Line 6654: okl_products pdt

6650: --To get the reporting product id
6651: CURSOR c_get_report_product_id IS
6652: SELECT pdt.reporting_pdt_id
6653: FROM okl_k_headers khr,
6654: okl_products pdt
6655: WHERE khr.id = p_chr_id
6656: AND khr.pdt_id = pdt.id;
6657:
6658: --To check whether the accrual flag is checked or not

Line 6691: l_product_id okl_products.id%TYPE;

6687: AND TXL.QTE_ID = TRX.QTE_ID;
6688:
6689: l_accrual_previous_mnth_yn VARCHAR2(3);
6690: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;
6691: l_product_id okl_products.id%TYPE;
6692: l_temp_term_date DATE;
6693: l_chk_accrual_stream VARCHAR2(1);
6694: l_curr_term_flag VARCHAR2(1);
6695: --end vdamerla

Line 7172: okl_products_v pdt

7168: SELECT 'Y'
7169: FROM DUAL
7170: WHERE EXISTS (SELECT 1
7171: FROM okl_k_headers khr,
7172: okl_products_v pdt
7173: WHERE khr.id = p_chr_id
7174: AND khr.pdt_id = pdt.id
7175: AND pdt.reporting_pdt_id IS NOT NULL);
7176: -- Check for reporting streams for non MGAPP prodcut

Line 9584: okl_products_v pdt,

9580: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
9581: gts.days_in_yr_code
9582: FROM
9583: okl_k_headers khr,
9584: okl_products_v pdt,
9585: okl_ae_tmpt_sets_v aes,
9586: OKL_ST_GEN_TMPT_SETS gts
9587: WHERE
9588: khr.pdt_id = pdt.id AND

Line 11960: okl_products_v pdt,

11956: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
11957: gts.days_in_yr_code
11958: FROM
11959: okl_k_headers khr,
11960: okl_products_v pdt,
11961: okl_ae_tmpt_sets_v aes,
11962: OKL_ST_GEN_TMPT_SETS gts
11963: WHERE
11964: khr.pdt_id = pdt.id AND

Line 13144: okl_products_v pdt,

13140: SELECT
13141: gts.interest_calc_meth_code
13142: FROM
13143: okl_k_headers khr,
13144: okl_products_v pdt,
13145: okl_ae_tmpt_sets_v aes,
13146: OKL_ST_GEN_TMPT_SETS gts
13147: WHERE
13148: khr.pdt_id = pdt.id AND

Line 13215: okl_products_v pdt,

13211: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
13212: gts.days_in_yr_code
13213: FROM
13214: okl_k_headers khr,
13215: okl_products_v pdt,
13216: okl_ae_tmpt_sets_v aes,
13217: OKL_ST_GEN_TMPT_SETS gts
13218: WHERE
13219: khr.pdt_id = pdt.id AND

Line 15290: okl_products_v pdt,

15286: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
15287: gts.days_in_yr_code
15288: FROM
15289: okl_k_headers khr,
15290: okl_products_v pdt,
15291: okl_ae_tmpt_sets_v aes,
15292: OKL_ST_GEN_TMPT_SETS gts
15293: WHERE
15294: khr.pdt_id = pdt.id AND

Line 17553: okl_products_v pdt

17549: chr.currency_code currency_code,
17550: khr.term_duration term
17551: FROM okc_k_headers_v chr,
17552: okl_k_headers khr,
17553: okl_products_v pdt
17554: WHERE khr.id = chr.id
17555: AND chr.id = chrId
17556: AND khr.pdt_id = pdt.id(+);
17557: -- get the Lease Header rule information

Line 17764: okl_products_v pdt,

17760: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
17761: gts.days_in_yr_code
17762: FROM
17763: okl_k_headers khr,
17764: okl_products_v pdt,
17765: okl_ae_tmpt_sets_v aes,
17766: OKL_ST_GEN_TMPT_SETS gts
17767: WHERE
17768: khr.pdt_id = pdt.id AND

Line 21887: okl_products_v pdt

21883: chr.currency_code currency_code,
21884: khr.term_duration term
21885: FROM okc_k_headers_v chr,
21886: okl_k_headers khr,
21887: okl_products_v pdt
21888: WHERE khr.id = chr.id
21889: AND chr.id = chrId
21890: AND khr.pdt_id = pdt.id(+);
21891: -- get the Header rule information

Line 22244: okl_products_v pdt,

22240: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
22241: gts.days_in_yr_code
22242: FROM
22243: okl_k_headers khr,
22244: okl_products_v pdt,
22245: okl_ae_tmpt_sets_v aes,
22246: OKL_ST_GEN_TMPT_SETS gts
22247: WHERE
22248: khr.pdt_id = pdt.id AND