APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_STRM_TYPE_TL

Line 213: ,OKL_STRM_TYPE_TL STYT

209: from OKL_TRX_AR_INVOICES_B TAI
210: ,OKL_TXL_AR_INV_LNS_B TIL
211: ,OKL_TXD_AR_LN_DTLS_B TLD2
212: ,OKL_TXD_AR_LN_DTLS_B TLD
213: ,OKL_STRM_TYPE_TL STYT
214: ,OKL_XTL_SELL_INVS_V XLS
215: ,OKC_K_HEADERS_V CHR
216: ,OKL_CNSLD_AR_STRMS_B LSM
217: ,OKL_CNSLD_AR_LINES_B LLN

Line 240: ,OKL_STRM_TYPE_TL STYT

236: ,TIL.Amount
237: from OKL_TRX_AR_INVOICES_B TAI
238: ,OKL_TXL_AR_INV_LNS_B TIL2
239: ,OKL_TXL_AR_INV_LNS_B TIL
240: ,OKL_STRM_TYPE_TL STYT
241: ,OKL_XTL_SELL_INVS_V XLS
242: ,OKC_K_HEADERS_V CHR
243: ,OKL_CNSLD_AR_STRMS_B LSM
244: ,OKL_CNSLD_AR_LINES_B LLN

Line 270: ,OKL_STRM_TYPE_TL STYT

266: from OKL_TRX_AR_INVOICES_B TAI
267: ,OKL_TXL_AR_INV_LNS_B TIL
268: ,OKL_TXD_AR_LN_DTLS_B TLD2
269: ,OKL_TXD_AR_LN_DTLS_B TLD
270: ,OKL_STRM_TYPE_TL STYT
271: ,OKC_K_HEADERS_V CHR
272: ,AR_PAYMENT_SCHEDULES_ALL APS
273: ,RA_CUSTOMER_TRX_ALL RACTRX
274: ,RA_CUSTOMER_TRX_LINES_ALL RACTRL

Line 295: ,OKL_STRM_TYPE_TL STYT

291: ,TIL.Amount
292: from OKL_TRX_AR_INVOICES_B TAI
293: ,OKL_TXL_AR_INV_LNS_B TIL
294: ,OKL_TXD_AR_LN_DTLS_B TLD
295: ,OKL_STRM_TYPE_TL STYT
296: ,OKL_XTL_SELL_INVS_V XLS
297: ,OKC_K_HEADERS_V CHR
298: ,OKL_CNSLD_AR_STRMS_B LSM
299: ,OKL_CNSLD_AR_LINES_B LLN

Line 335: ,OKL_STRM_TYPE_TL STYT

331: ,TIL.Amount
332: from OKL_TRX_AR_INVOICES_B TAI
333: ,OKL_TXL_AR_INV_LNS_B TIL
334: ,OKL_TXD_AR_LN_DTLS_B TLD
335: ,OKL_STRM_TYPE_TL STYT
336: ,OKL_XTL_SELL_INVS_V XLS
337: ,OKC_K_HEADERS_V CHR
338: ,OKL_CNSLD_AR_STRMS_B LSM
339: ,OKL_CNSLD_AR_LINES_B LLN

Line 577: FROM okl_strm_type_tl styt, okl_strm_type_b sty

573: FUNCTION get_sty_id (p_sty_purpose IN VARCHAR2, p_khr_id in NUMBER) RETURN NUMBER IS
574:
575: /*CURSOR c_sty IS
576: SELECT sty.id
577: FROM okl_strm_type_tl styt, okl_strm_type_b sty
578: WHERE styt.name = p_sty_name
579: AND styt.language = 'US'
580: AND sty.id = styt.id
581: AND sty.start_date <= TRUNC(SYSDATE)