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_REPORT_GENERATOR_PVT dependencies on OKL_STREAMS_REP_V

Line 3168: FROM okl_streams_rep_v stm

3164: ,p_activity VARCHAR2)
3165: IS
3166: SELECT stm.khr_id khr_id
3167: ,SUM(se.amount) unbilled_amount
3168: FROM okl_streams_rep_v stm
3169: ,okl_strm_elements se
3170: ,okl_strm_type_v sty
3171: WHERE
3172: stm.khr_id = p_khr_id

Line 6069: okl_streams_rep_v STM,

6065: FROM gl_ledgers gl
6066: WHERE ledger_id = p_ledger_id)
6067: ) STREAM_PERIOD
6068: FROM OKL_STRM_TYPE_V STY,
6069: okl_streams_rep_v STM,
6070: OKL_STRM_ELEMENTS STE,
6071: OKC_K_HEADERS_ALL_B KHR,
6072: OKL_K_HEADERS KH,
6073: OKC_K_LINES_V KLE,

Line 6100: okl_streams_rep_v STM,

6096: and KH.ID = p_khr_id
6097: AND STM.ID IN ( SELECT MAX(ID)
6098: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6099: FROM OKL_STRM_TYPE_V STY,
6100: okl_streams_rep_v STM,
6101: OKL_STRM_ELEMENTS STE,
6102: OKC_K_HEADERS_ALL_B KHR,
6103: OKL_K_HEADERS KH,
6104: OKC_K_LINES_V KLE,

Line 6157: okl_streams_rep_v STM,

6153: FROM gl_ledgers gl
6154: WHERE ledger_id = p_ledger_id)
6155: ) STREAM_PERIOD
6156: FROM OKL_STRM_TYPE_V STY,
6157: okl_streams_rep_v STM,
6158: OKL_STRM_ELEMENTS STE,
6159: OKC_K_HEADERS_ALL_B KHR,
6160: OKL_K_HEADERS KH,
6161: OKC_K_LINES_V KLE,

Line 6188: okl_streams_rep_v STM,

6184: and KH.ID = p_khr_id
6185: AND STM.ID IN ( SELECT MAX(ID)
6186: FROM ( SELECT STM.STY_ID, STM.ID, MAX(DATE_CURRENT)
6187: FROM OKL_STRM_TYPE_V STY,
6188: okl_streams_rep_v STM,
6189: OKL_STRM_ELEMENTS STE,
6190: OKC_K_HEADERS_ALL_B KHR,
6191: OKL_K_HEADERS KH,
6192: OKC_K_LINES_V KLE,

Line 6377: FROM okl_streams_rep_v c,

6373: c.khr_Id khr_Id,
6374: c.kle_Id kle_Id,
6375: c.Sty_Id Sty_Id,
6376: ce.se_Line_Number line_number
6377: FROM okl_streams_rep_v c,
6378: okl_streams_rep_v p,
6379: Okl_strm_Type_v st,
6380: Okl_strm_Elements ce,
6381: Okl_strm_Elements pe,

Line 6378: okl_streams_rep_v p,

6374: c.kle_Id kle_Id,
6375: c.Sty_Id Sty_Id,
6376: ce.se_Line_Number line_number
6377: FROM okl_streams_rep_v c,
6378: okl_streams_rep_v p,
6379: Okl_strm_Type_v st,
6380: Okl_strm_Elements ce,
6381: Okl_strm_Elements pe,
6382: Okc_k_Headers_All_b khr,