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_PAY_INVOICES_DISB_PVT dependencies on OKL_STRM_TYPE_V

Line 1605: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1601: --rkuttiya commented and changed for Billing Architecture
1602: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1603: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1604: --start fix for bug 5040815 by pgomes 24-mar-2006
1605: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1606: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1607: --end fix for bug 5040815 by pgomes 24-mar-2006
1608: --rkuttiya R12 B Billing Architecture commented out the following
1609: --AND lsm.lln_id = lln.id

Line 1682: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1678: --
1679: AND arl.receivables_invoice_id > 0
1680: AND (tld.pay_status_code is NULL OR tld.pay_status_code = 'ERROR')
1681: --start fix for bug 5040815 by pgomes 24-mar-2006
1682: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1683: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1684: --end fix for bug 5040815 by pgomes 24-mar-2006
1685: --rkuttiya commented following for R12 B Billing Architecture
1686: --AND lsm.lln_id = lln.id

Line 1771: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1767: AND til.id = tld.til_id_details
1768: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1769: --
1770: --start fix for bug 5040815 by pgomes 24-mar-2006
1771: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1772: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1773: --end fix for bug 5040815 by pgomes 24-mar-2006
1774: --rkuttiya R12 B Billing Architecture commented out the following
1775: --AND lsm.lln_id = lln.id

Line 1854: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1850: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1851: --rkuttiya added R12B Billing Architecture
1852: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1853: --start fix for bug 5040815 by pgomes 24-mar-2006
1854: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1855: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1856: --end fix for bug 5040815 by pgomes 24-mar-2006
1857: --rkuttiya commented for R12 B Billing Architecture
1858: --AND lsm.lln_id = lln.id

Line 1940: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1936: AND kle.id = til.kle_id
1937: AND arl.receivables_invoice_id > 0
1938: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1939: --start fix for bug 5040815 by pgomes 24-mar-2006
1940: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1941: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1942: --end fix for bug 5040815 by pgomes 24-mar-2006
1943: --rkuttiya R12 B Billing Architecture commented the following
1944: --AND lsm.lln_id = lln.id

Line 2019: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

2015: AND sub_kle.chr_id is null
2016: AND sub_kle.id = til.kle_id
2017: AND arl.receivables_invoice_id > 0
2018: --start fix for bug 5040815 by pgomes 24-mar-2006
2019: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2020: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2021: --end fix for bug 5040815 by pgomes 24-mar-2006
2022: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
2023: --rkuttiya R12 B Billing Architecture commented out following

Line 2091: okl_strm_type_v sty,

2087: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2088: khl.legal_entity_id
2089: FROM okl_strm_elements ste,
2090: okl_streams stm,
2091: okl_strm_type_v sty,
2092: okc_k_headers_b khr,
2093: okl_k_headers khl,
2094: hr_operating_units hou,
2095: okc_k_lines_b kle,

Line 2111: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v

2107: AND ste.date_disbursed IS NULL
2108: AND stm.active_yn = 'Y'
2109: AND stm.say_code = 'CURR'
2110: --start fix for bug 5040815 by pgomes 24-mar-2006
2111: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2112: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2113: --end fix for bug 5040815 by pgomes 24-mar-2006
2114: AND sty.id = stm.sty_id
2115: AND sty.billable_yn = 'Y'

Line 2164: okl_strm_type_v sty,

2160: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2161: khl.legal_entity_id
2162: FROM okl_strm_elements ste,
2163: okl_streams stm,
2164: okl_strm_type_v sty,
2165: okc_k_headers_b khr,
2166: okl_k_headers khl,
2167: hr_operating_units hou,
2168: okc_k_lines_b kle,

Line 2185: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v

2181: AND ste.date_disbursed IS NULL
2182: AND stm.active_yn = 'Y'
2183: AND stm.say_code = 'CURR'
2184: --start fix for bug 5040815 by pgomes 24-mar-2006
2185: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2186: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2187: --end fix for bug 5040815 by pgomes 24-mar-2006
2188: AND sty.id = stm.sty_id
2189: AND sty.billable_yn = 'Y'

Line 2617: okl_strm_type_v SM,

2613: --rkuttiya R12 B Billing Architecture commented
2614: --OKL_CNSLD_AR_STRMS_B ST,
2615: okl_bpd_ar_inv_lines_v ST,
2616: --OKL_STRM_TYPE_TL SM,
2617: okl_strm_type_v SM,
2618: OKC_K_HEADERS_B CN
2619: WHERE
2620: PS.CLASS IN ('INV') AND
2621: ST.INVOICE_ID = PS.CUSTOMER_TRX_ID AND