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 1655: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v

1651: --rkuttiya commented and changed for Billing Architecture
1652: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1653: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1654: --start fix for bug 5040815 by pgomes 24-mar-2006
1655: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1656: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1657: --end fix for bug 5040815 by pgomes 24-mar-2006
1658: --rkuttiya R12 B Billing Architecture commented out the following
1659: --AND lsm.lln_id = lln.id

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

1728: --
1729: AND arl.receivables_invoice_id > 0
1730: AND (tld.pay_status_code is NULL OR tld.pay_status_code = 'ERROR')
1731: --start fix for bug 5040815 by pgomes 24-mar-2006
1732: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1733: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1734: --end fix for bug 5040815 by pgomes 24-mar-2006
1735: --rkuttiya commented following for R12 B Billing Architecture
1736: --AND lsm.lln_id = lln.id

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

1818: AND til.id = tld.til_id_details
1819: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1820: --
1821: --start fix for bug 5040815 by pgomes 24-mar-2006
1822: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1823: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1824: --end fix for bug 5040815 by pgomes 24-mar-2006
1825: --rkuttiya R12 B Billing Architecture commented out the following
1826: --AND lsm.lln_id = lln.id

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

1903: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1904: --rkuttiya added R12B Billing Architecture
1905: AND (tld.pay_status_code IS NULL OR tld.pay_status_code = 'ERROR')
1906: --start fix for bug 5040815 by pgomes 24-mar-2006
1907: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1908: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1909: --end fix for bug 5040815 by pgomes 24-mar-2006
1910: --rkuttiya commented for R12 B Billing Architecture
1911: --AND lsm.lln_id = lln.id

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

1989: AND kle.id = til.kle_id
1990: AND arl.receivables_invoice_id > 0
1991: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
1992: --start fix for bug 5040815 by pgomes 24-mar-2006
1993: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
1994: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
1995: --end fix for bug 5040815 by pgomes 24-mar-2006
1996: --rkuttiya R12 B Billing Architecture commented the following
1997: --AND lsm.lln_id = lln.id

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

2068: AND sub_kle.chr_id is null
2069: AND sub_kle.id = til.kle_id
2070: AND arl.receivables_invoice_id > 0
2071: --start fix for bug 5040815 by pgomes 24-mar-2006
2072: AND arl.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2073: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2074: --end fix for bug 5040815 by pgomes 24-mar-2006
2075: --AND (lsm.pay_status_code is NULL OR lsm.pay_status_code = 'ERROR')
2076: --rkuttiya R12 B Billing Architecture commented out following

Line 2144: okl_strm_type_v sty,

2140: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2141: khl.legal_entity_id
2142: FROM okl_strm_elements ste,
2143: okl_streams stm,
2144: okl_strm_type_v sty,
2145: okc_k_headers_b khr,
2146: okl_k_headers khl,
2147: hr_operating_units hou,
2148: okc_k_lines_b kle,

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

2160: AND ste.date_disbursed IS NULL
2161: AND stm.active_yn = 'Y'
2162: AND stm.say_code = 'CURR'
2163: --start fix for bug 5040815 by pgomes 24-mar-2006
2164: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2165: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2166: --end fix for bug 5040815 by pgomes 24-mar-2006
2167: AND sty.id = stm.sty_id
2168: AND sty.billable_yn = 'Y'

Line 2217: okl_strm_type_v sty,

2213: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2214: khl.legal_entity_id
2215: FROM okl_strm_elements ste,
2216: okl_streams stm,
2217: okl_strm_type_v sty,
2218: okc_k_headers_b khr,
2219: okl_k_headers khl,
2220: hr_operating_units hou,
2221: okc_k_lines_b kle,

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

2234: AND ste.date_disbursed IS NULL
2235: AND stm.active_yn = 'Y'
2236: AND stm.say_code = 'CURR'
2237: --start fix for bug 5040815 by pgomes 24-mar-2006
2238: AND stm.sty_id NOT IN (SELECT id FROM okl_strm_type_v
2239: WHERE stream_type_purpose in ('LATE_FEE', 'LATE_INTEREST'))
2240: --end fix for bug 5040815 by pgomes 24-mar-2006
2241: AND sty.id = stm.sty_id
2242: AND sty.billable_yn = 'Y'

Line 2670: okl_strm_type_v SM,

2666: --rkuttiya R12 B Billing Architecture commented
2667: --OKL_CNSLD_AR_STRMS_B ST,
2668: okl_bpd_ar_inv_lines_v ST,
2669: --OKL_STRM_TYPE_TL SM,
2670: okl_strm_type_v SM,
2671: OKC_K_HEADERS_B CN
2672: WHERE
2673: PS.CLASS IN ('INV') AND
2674: ST.INVOICE_ID = PS.CUSTOMER_TRX_ID AND