DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 191: FROM AR_PAYMENT_SCHEDULES_ALL PS,

187: -- AND status = 'OP';
188: SELECT MIN(DUE_DATE) min_due_date, COUNT(*) total_os from (
189: SELECT
190: PS.DUE_DATE DUE_DATE
191: FROM AR_PAYMENT_SCHEDULES_ALL PS,
192: OKL_CNSLD_AR_STRMS_B ST ,
193: OKL_CNSLD_AR_LINES_B LN ,
194: OKL_CNSLD_AR_HDRS_B HD ,
195: OKL_STRM_TYPE_B SP ,

Line 215: AR_PAYMENT_SCHEDULES_ALL APS ,

211: OKL_TXD_AR_LN_DTLS_B TXD ,
212: RA_CUSTOMER_TRX_ALL RACTRX ,
213: OKL_STRM_TYPE_B SM ,
214: OKL_TXL_AR_INV_LNS_B TIL ,
215: AR_PAYMENT_SCHEDULES_ALL APS ,
216: OKC_K_HEADERS_ALL_B KHR
217: WHERE
218: --to_char(TXD.ID )= RACTRL.interface_line_attribute14
219: RACTRL.interface_line_attribute14 = (select to_char(TXD.ID)