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_REBOOK_CM_PVT dependencies on OKL_STREAMS

Line 83: OKL_STREAMS STM,

79: ------------------------------------------------------------
80: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
81: SELECT distinct KHR.ID
82: FROM OKC_K_HEADERS_B KHR,
83: OKL_STREAMS STM,
84: OKL_STRM_TYPE_B STY,
85: OKL_STRM_ELEMENTS SEL
86: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
87: AND KHR.STS_CODE = 'BOOKED'

Line 142: okl_streams stm,

138: ste.amount amount,
139: khr.sts_code sts_code
140: FROM
141: okl_strm_elements ste,
142: okl_streams stm,
143: okl_strm_type_b sty,
144: okc_k_headers_b khr,
145: okl_k_headers khl,
146: okc_k_lines_b kle,

Line 336: u_selv_rec Okl_Streams_Pub.selv_rec_type;

332: r_esdv_rec Okl_Xtd_Sell_Invs_Pub.esdv_rec_type;
333:
334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:

Line 337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;

333:
334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:
341: ------------------------------------------------------------

Line 338: r_selv_rec Okl_Streams_Pub.selv_rec_type;

334:
335: -- Stream elements
336: u_selv_rec Okl_Streams_Pub.selv_rec_type;
337: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
338: r_selv_rec Okl_Streams_Pub.selv_rec_type;
339:
340:
341: ------------------------------------------------------------
342: -- Declare local variables used in the program

Line 1051: OKL_STREAMS STM,

1047: ------------------------------------------------------------
1048: CURSOR rbk_ctrct_csr ( p_contract_number VARCHAR2 ) IS
1049: SELECT distinct KHR.ID
1050: FROM OKC_K_HEADERS_B KHR,
1051: OKL_STREAMS STM,
1052: OKL_STRM_TYPE_B STY,
1053: OKL_STRM_ELEMENTS SEL
1054: WHERE KHR.contract_number = NVL(p_contract_number, contract_number)
1055: AND KHR.STS_CODE = 'BOOKED'

Line 1112: okl_streams stm,

1108: ste.amount amount,
1109: khr.sts_code sts_code
1110: FROM
1111: okl_strm_elements ste,
1112: okl_streams stm,
1113: okl_strm_type_b sty,
1114: okc_k_headers_b khr,
1115: okl_k_headers khl,
1116: okc_k_lines_b kle,

Line 1891: u_selv_rec Okl_Streams_Pub.selv_rec_type;

1887: r_esdv_rec Okl_Xtd_Sell_Invs_Pub.esdv_rec_type;
1888:
1889:
1890: -- Stream elements
1891: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1892: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1893: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1894:
1895:

Line 1892: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;

1888:
1889:
1890: -- Stream elements
1891: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1892: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1893: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1894:
1895:
1896: ------------------------------------------------------------

Line 1893: r_selv_rec Okl_Streams_Pub.selv_rec_type;

1889:
1890: -- Stream elements
1891: u_selv_rec Okl_Streams_Pub.selv_rec_type;
1892: l_init_selv_rec Okl_Streams_Pub.selv_rec_type;
1893: r_selv_rec Okl_Streams_Pub.selv_rec_type;
1894:
1895:
1896: ------------------------------------------------------------
1897: -- Declare local variables used in the program