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

Line 32: okl_strm_type_v sty,

28: cursor next_bill_date_csr( p_khr_id IN NUMBER ) IS
29: SELECT MIN(ste.stream_element_date)
30: FROM OKL_STRM_ELEMENTS ste,
31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,
35: okc_k_lines_b kle,
36: okc_statuses_b khs,

Line 799: okl_strm_type_v sty,

795: SELECT CHR.id
796: FROM okl_txd_ar_ln_dtls_b tld,
797: okl_txl_ar_inv_lns_b til,
798: okl_trx_ar_invoices_b tai,
799: okl_strm_type_v sty,
800: okc_k_headers_b CHR
801: WHERE tai.trx_status_code = 'SUBMITTED'
802: AND tai.khr_id = CHR.id
803: AND til.tai_id = tai.id

Line 823: okl_strm_type_v sty,

819: WHERE id IN (
820: SELECT CHR.id
821: FROM okl_txl_ar_inv_lns_b til,
822: okl_trx_ar_invoices_b tai,
823: okl_strm_type_v sty,
824: okc_k_headers_b CHR
825: WHERE tai.trx_status_code = 'SUBMITTED'
826: AND tai.khr_id = CHR.id
827: AND til.tai_id = tai.id

Line 945: OKL_STRM_TYPE_V STY,

941: COUNT(STE.ID) LINE_COUNT
942: FROM
943: OKL_STRM_ELEMENTS STE,
944: OKL_STREAMS STM,
945: OKL_STRM_TYPE_V STY,
946: OKL_PARALLEL_PROCESSES OPP
947: WHERE
948: OPP.ASSIGNED_PROCESS = p_seq_next AND
949: OPP.OBJECT_TYPE = 'CONTRACT' AND

Line 1004: OKL_STRM_TYPE_V STY,

1000: OKL_TXD_AR_LN_DTLS_B TLD,
1001: OKL_TXL_AR_INV_LNS_B TIL,
1002: OKL_TRX_AR_INVOICES_B TAI,
1003: OKC_K_HEADERS_B CHR,
1004: OKL_STRM_TYPE_V STY,
1005: OKL_PARALLEL_PROCESSES OPP
1006: WHERE tai.trx_status_code = 'SUBMITTED'
1007: AND tai.khr_id = CHR.id
1008: AND til.tai_id = tai.id

Line 1025: OKL_STRM_TYPE_V STY,

1021: FROM
1022: OKL_TXL_AR_INV_LNS_B TIL,
1023: OKL_TRX_AR_INVOICES_B TAI,
1024: OKC_K_HEADERS_B CHR,
1025: OKL_STRM_TYPE_V STY,
1026: OKL_PARALLEL_PROCESSES OPP
1027: WHERE tai.trx_status_code = 'SUBMITTED'
1028: AND tai.khr_id = CHR.id
1029: AND til.tai_id = tai.id

Line 3189: okl_strm_type_v sty

3185: FROM okl_invoice_formats_v inf,
3186: okl_invoice_types_v ity,
3187: okl_invc_line_types_v ilt,
3188: okl_invc_frmt_strms_v frs,
3189: okl_strm_type_v sty
3190: WHERE inf.id = p_format_id
3191: AND ity.inf_id = inf.id
3192: AND ilt.ity_id = ity.id
3193: AND frs.ilt_id = ilt.id

Line 3218: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;

3214: AND inf.ilt_id = ilt.id;
3215:
3216: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
3217: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
3218: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
3219:
3220: l_old_cnr_id NUMBER;
3221: l_old_lln_id NUMBER;
3222: l_cnt NUMBER;

Line 3227: FROM okl_strm_type_v;

3223:
3224: -- Get all Streams and cache locally
3225: CURSOR strm_csr_perf IS
3226: SELECT id, name
3227: FROM okl_strm_type_v;
3228:
3229: TYPE stream_rec_type IS RECORD (
3230: id okl_strm_type_v.id%TYPE,
3231: name okl_strm_type_v.name%TYPE);

Line 3230: id okl_strm_type_v.id%TYPE,

3226: SELECT id, name
3227: FROM okl_strm_type_v;
3228:
3229: TYPE stream_rec_type IS RECORD (
3230: id okl_strm_type_v.id%TYPE,
3231: name okl_strm_type_v.name%TYPE);
3232:
3233: TYPE stream_table IS TABLE OF stream_rec_type
3234: INDEX BY BINARY_INTEGER;

Line 3231: name okl_strm_type_v.name%TYPE);

3227: FROM okl_strm_type_v;
3228:
3229: TYPE stream_rec_type IS RECORD (
3230: id okl_strm_type_v.id%TYPE,
3231: name okl_strm_type_v.name%TYPE);
3232:
3233: TYPE stream_table IS TABLE OF stream_rec_type
3234: INDEX BY BINARY_INTEGER;
3235:

Line 3257: okl_strm_type_v sty

3253: FROM okl_invoice_formats_v inf,
3254: okl_invoice_types_v ity,
3255: okl_invc_line_types_v ilt,
3256: okl_invc_frmt_strms_v frs,
3257: okl_strm_type_v sty
3258: WHERE ity.inf_id = inf.id
3259: AND ilt.ity_id = ity.id
3260: AND frs.ilt_id = ilt.id
3261: AND sty.id = frs.sty_id

Line 3293: sty_name okl_strm_type_v.name%type,

3289: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3290: ilt_id okl_invc_line_types_v.id%type,
3291: sequence_number okl_invc_line_types_v.sequence_number%type,
3292: ilt_name okl_invc_line_types_v.name%type,
3293: sty_name okl_strm_type_v.name%type,
3294: sty_id okl_invc_frmt_strms_v.sty_id%type);
3295:
3296: TYPE inv_format_table IS TABLE OF inv_format_type
3297: INDEX BY BINARY_INTEGER;

Line 4118: FROM okl_strm_type_v

4114: WHERE id = p_id;
4115:
4116: CURSOR strm_csr ( p_id NUMBER ) IS
4117: SELECT name
4118: FROM okl_strm_type_v
4119: WHERE id = p_id;
4120:
4121: l_contract_number okc_k_headers_b.contract_number%TYPE;
4122: l_stream_name1 okl_strm_type_v.name%TYPE;

Line 4122: l_stream_name1 okl_strm_type_v.name%TYPE;

4118: FROM okl_strm_type_v
4119: WHERE id = p_id;
4120:
4121: l_contract_number okc_k_headers_b.contract_number%TYPE;
4122: l_stream_name1 okl_strm_type_v.name%TYPE;
4123:
4124:
4125: l_temp_khr_id NUMBER;
4126: