APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_TYPE_B

Line 173: ,OKL_STRM_TYPE_B SM

169: ,OKL_CNSLD_AR_STRMS_B ST
170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM
174: ,okl_k_headers_full_v khr
175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul
177: ,okc_rules_b rul_exm

Line 335: OKL_STRM_TYPE_B SM

331: OKL_CNSLD_AR_STRMS_B ST,
332: OKL_CNSLD_AR_HDRS_B HD,
333: OKC_K_HEADERS_ALL_B CN,
334: OKL_CNSLD_AR_LINES_B LN,
335: OKL_STRM_TYPE_B SM
336: WHERE PS.CLASS IN ('INV', 'CM')
337: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
338: AND CN.ID = ST.KHR_ID
339: AND LN.ID = ST.LLN_ID

Line 360: OKL_STRM_TYPE_B SM

356: OKL_CNSLD_AR_STRMS_B ST,
357: OKL_CNSLD_AR_HDRS_B HD,
358: OKC_K_HEADERS_ALL_B CN,
359: OKL_CNSLD_AR_LINES_B LN,
360: OKL_STRM_TYPE_B SM
361: WHERE PS.CLASS IN ('INV', 'CM')
362: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
363: AND CN.ID = ST.KHR_ID
364: AND LN.ID = ST.LLN_ID

Line 594: ,okl_strm_type_b sty

590:
591: CURSOR c_strm_purpose(cp_stream_id IN NUMBER) IS
592: SELECT sty.stream_type_purpose
593: FROM okl_bpd_ar_inv_lines_v arl
594: ,okl_strm_type_b sty
595: WHERE arl.id = cp_stream_id
596: AND arl.sty_id = sty.id;
597:
598: ------------------------------------------------------------