APPS.OKL_CS_TRANSACTIONS_PVT dependencies on OKL_STRM_TYPE_TL

Line 203: ,OKL_STRM_TYPE_TL STYT

199: from OKL_TRX_AR_INVOICES_B TAI
200: ,OKL_TXL_AR_INV_LNS_B TIL
201: ,OKL_TXD_AR_LN_DTLS_B TLD2
202: ,OKL_TXD_AR_LN_DTLS_B TLD
203: ,OKL_STRM_TYPE_TL STYT
204: ,OKL_XTL_SELL_INVS_V XLS
205: ,OKC_K_HEADERS_V CHR
206: ,OKL_CNSLD_AR_STRMS_B LSM
207: ,OKL_CNSLD_AR_LINES_B LLN

Line 230: ,OKL_STRM_TYPE_TL STYT

226: ,TIL.Amount
227: from OKL_TRX_AR_INVOICES_B TAI
228: ,OKL_TXL_AR_INV_LNS_B TIL2
229: ,OKL_TXL_AR_INV_LNS_B TIL
230: ,OKL_STRM_TYPE_TL STYT
231: ,OKL_XTL_SELL_INVS_V XLS
232: ,OKC_K_HEADERS_V CHR
233: ,OKL_CNSLD_AR_STRMS_B LSM
234: ,OKL_CNSLD_AR_LINES_B LLN

Line 260: ,OKL_STRM_TYPE_TL STYT

256: from OKL_TRX_AR_INVOICES_B TAI
257: ,OKL_TXL_AR_INV_LNS_B TIL
258: ,OKL_TXD_AR_LN_DTLS_B TLD2
259: ,OKL_TXD_AR_LN_DTLS_B TLD
260: ,OKL_STRM_TYPE_TL STYT
261: ,OKC_K_HEADERS_V CHR
262: ,AR_PAYMENT_SCHEDULES_ALL APS
263: ,RA_CUSTOMER_TRX_ALL RACTRX
264: ,RA_CUSTOMER_TRX_LINES_ALL RACTRL

Line 285: ,OKL_STRM_TYPE_TL STYT

281: ,TIL.Amount
282: from OKL_TRX_AR_INVOICES_B TAI
283: ,OKL_TXL_AR_INV_LNS_B TIL
284: ,OKL_TXD_AR_LN_DTLS_B TLD
285: ,OKL_STRM_TYPE_TL STYT
286: ,OKL_XTL_SELL_INVS_V XLS
287: ,OKC_K_HEADERS_V CHR
288: ,OKL_CNSLD_AR_STRMS_B LSM
289: ,OKL_CNSLD_AR_LINES_B LLN

Line 325: ,OKL_STRM_TYPE_TL STYT

321: ,TIL.Amount
322: from OKL_TRX_AR_INVOICES_B TAI
323: ,OKL_TXL_AR_INV_LNS_B TIL
324: ,OKL_TXD_AR_LN_DTLS_B TLD
325: ,OKL_STRM_TYPE_TL STYT
326: ,OKL_XTL_SELL_INVS_V XLS
327: ,OKC_K_HEADERS_V CHR
328: ,OKL_CNSLD_AR_STRMS_B LSM
329: ,OKL_CNSLD_AR_LINES_B LLN

Line 567: FROM okl_strm_type_tl styt, okl_strm_type_b sty

563: FUNCTION get_sty_id (p_sty_purpose IN VARCHAR2, p_khr_id in NUMBER) RETURN NUMBER IS
564:
565: /*CURSOR c_sty IS
566: SELECT sty.id
567: FROM okl_strm_type_tl styt, okl_strm_type_b sty
568: WHERE styt.name = p_sty_name
569: AND styt.language = 'US'
570: AND sty.id = styt.id
571: AND sty.start_date <= TRUNC(SYSDATE)