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_STRM_TYPE_B

Line 195: OKL_STRM_TYPE_B SP ,

191: FROM AR_PAYMENT_SCHEDULES_ALL PS,
192: OKL_CNSLD_AR_STRMS_B ST ,
193: OKL_CNSLD_AR_LINES_B LN ,
194: OKL_CNSLD_AR_HDRS_B HD ,
195: OKL_STRM_TYPE_B SP ,
196: OKC_K_HEADERS_ALL_B CN
197: WHERE PS.CLASS IN ('INV', 'CM')
198: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
199: AND LN.ID = ST.LLN_ID

Line 213: OKL_STRM_TYPE_B SM ,

209: APS.DUE_DATE DUE_DATE
210: FROM RA_CUSTOMER_TRX_LINES_ALL RACTRL,
211: OKL_TXD_AR_LN_DTLS_B TXD ,
212: RA_CUSTOMER_TRX_ALL RACTRX ,
213: OKL_STRM_TYPE_B SM ,
214: OKL_TXL_AR_INV_LNS_B TIL ,
215: AR_PAYMENT_SCHEDULES_ALL APS ,
216: OKC_K_HEADERS_ALL_B KHR
217: WHERE

Line 422: FROM OKL_STRM_TYPE_B sty,

418: FROM OKC_K_HEADERS_B CHR
419: WHERE id = p_chr_id
420: AND EXISTS (
421: SELECT 1
422: FROM OKL_STRM_TYPE_B sty,
423: --OKL_STREAMS stm,
424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,

Line 499: okl_strm_type_b sty

495: SELECT NVL(rul2.rule_information10,'N') arrears_yn
496: FROM okc_rule_groups_b rgp,
497: okc_rules_b rul1,
498: okc_rules_b rul2,
499: okl_strm_type_b sty
500: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
501: AND rul2.rule_information_category = 'LASLL'
502: AND rul2.rgp_id = rgp.id
503: AND rgp.cle_id IS NULL

Line 1004: -- on okl_strm_type_b for bug# 2475123

1000: ,p_accrual_rule_yn IN VARCHAR2) IS
1001:
1002:
1003: -- modified cursor where clause and removed accrue_yn attribute check
1004: -- on okl_strm_type_b for bug# 2475123
1005: -- added sty.accrual_yn = 'Y' for ER 2872216.
1006: CURSOR select_streams_csr(p_ctr_id NUMBER, p_accrue_from_date DATE, p_accrue_till_date DATE) IS
1007: SELECT sty.id,
1008: stytl.name,

Line 1013: FROM OKL_STRM_TYPE_B sty,

1009: stm.id stream_id,
1010: ste.id stream_element_id,
1011: ste.amount,
1012: stm.kle_id
1013: FROM OKL_STRM_TYPE_B sty,
1014: OKL_STRM_TYPE_TL stytl,
1015: --OKL_STREAMS stm,
1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1017: OKL_STRM_ELEMENTS ste,

Line 1046: FROM OKL_STRM_TYPE_B sty,

1042: stm.id stream_id,
1043: ste.id stream_element_id,
1044: ste.amount,
1045: stm.kle_id
1046: FROM OKL_STRM_TYPE_B sty,
1047: OKL_STRM_TYPE_TL stytl,
1048: --OKL_STREAMS stm,
1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1050: OKL_STRM_ELEMENTS ste,

Line 2385: FROM OKL_STRM_TYPE_B

2381:
2382: -- cursor to retrieve accrual rule value
2383: CURSOR accrual_rule_csr (p_sty_id NUMBER) IS
2384: SELECT accrual_yn
2385: FROM OKL_STRM_TYPE_B
2386: WHERE id = p_sty_id;
2387:
2388: --Added by bkatraga for bug 13332631
2389: CURSOR last_status_csr(p_khr_id NUMBER) IS

Line 3082: FROM OKL_STRM_TYPE_B sty,

3078: ste.id ste_id,
3079: ste.amount amount,
3080: stm.kle_id
3081: ,stm.id stm_id -- Bug : 9001154
3082: FROM OKL_STRM_TYPE_B sty,
3083: --OKL_STREAMS stm,
3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,

Line 3120: FROM OKL_STRM_TYPE_B sty,

3116: ste.amount amount,
3117: stm.kle_id
3118: ,stm.id stm_id -- Bug : 9001154
3119:
3120: FROM OKL_STRM_TYPE_B sty,
3121: --OKL_STREAMS stm,
3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,

Line 3158: FROM OKL_STRM_TYPE_B sty,

3154: ste.id ste_id,
3155: ste.amount amount,
3156: stm.kle_id
3157: ,stm.id stm_id -- Bug : 9001154
3158: FROM OKL_STRM_TYPE_B sty,
3159: --OKL_STREAMS stm,
3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,

Line 3196: FROM OKL_STRM_TYPE_B sty,

3192: ste.id ste_id,
3193: ste.amount amount,
3194: stm.kle_id
3195: ,stm.id stm_id -- Bug : 9001154
3196: FROM OKL_STRM_TYPE_B sty,
3197: --OKL_STREAMS stm,
3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,

Line 6301: okl_strm_type_b sty

6297: CURSOR last_accrual_date_csr(p_contract_id NUMBER) IS
6298: SELECT MAX(sel.stream_element_date)
6299: FROM okl_strm_elements sel,
6300: okl_streams stm,
6301: okl_strm_type_b sty
6302: WHERE stm.khr_id = p_contract_id
6303: AND sel.stm_id = stm.id
6304: AND stm.say_code = 'CURR'
6305: AND stm.sty_id = sty.id