215: ,OKC_K_HEADERS_V CHR
216: ,OKL_CNSLD_AR_STRMS_B LSM
217: ,OKL_CNSLD_AR_LINES_B LLN
218: ,AR_PAYMENT_SCHEDULES_ALL APS
219: ,OKL_CNSLD_AR_HDRS_B CNR
220: where TAI.ID = p_tai_id
221: AND CHR.ID = p_khr_id
222: AND TIL.TAI_ID =TAI.ID
223: AND TIL.ID = TLD2.TIL_ID_DETAILS
242: ,OKC_K_HEADERS_V CHR
243: ,OKL_CNSLD_AR_STRMS_B LSM
244: ,OKL_CNSLD_AR_LINES_B LLN
245: ,AR_PAYMENT_SCHEDULES_ALL APS
246: ,OKL_CNSLD_AR_HDRS_B CNR
247: where TAI.ID = p_tai_id
248: AND CHR.ID = p_khr_id
249: AND TIL.TAI_ID =TAI.ID
250: AND TIL2.TIL_ID_REVERSES = TIL.ID
297: ,OKC_K_HEADERS_V CHR
298: ,OKL_CNSLD_AR_STRMS_B LSM
299: ,OKL_CNSLD_AR_LINES_B LLN
300: ,AR_PAYMENT_SCHEDULES_ALL APS
301: ,OKL_CNSLD_AR_HDRS_B CNR
302: ,OKC_K_LINES_B CLE
303: ,OKC_LINE_STYLES_B LSE
304: ,OKC_K_ITEMS CIM
305: ,FA_ADDITIONS_B FAA
337: ,OKC_K_HEADERS_V CHR
338: ,OKL_CNSLD_AR_STRMS_B LSM
339: ,OKL_CNSLD_AR_LINES_B LLN
340: ,AR_PAYMENT_SCHEDULES_ALL APS
341: ,OKL_CNSLD_AR_HDRS_B CNR
342: ,OKC_K_LINES_B CLE
343: ,OKC_LINE_STYLES_B LSE
344: ,OKC_K_ITEMS CIM
345: ,FA_ADDITIONS_B FAA