DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 326: AR_PAYMENT_SCHEDULES_ALL PS

322: OKL_CNSLD_AR_STRMS_B ST,
323: OKL_CNSLD_AR_HDRS_B HD,
324: HZ_CUST_ACCOUNTS CA,
325: OKL_CNSLD_AR_LINES_B LN,
326: AR_PAYMENT_SCHEDULES_ALL PS
327: WHERE PS.CLASS IN ('INV', 'CM')
328: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID AND LN.ID = ST.LLN_ID
329: AND HD.ID = LN.CNR_ID AND CA.CUST_ACCOUNT_ID = HD.IXX_ID
330: AND CN.ID = ST.KHR_ID

Line 352: AR_PAYMENT_SCHEDULES_ALL PS

348: select ST.KHR_ID CONTRACT_ID
349: from
350: OKC_K_HEADERS_ALL_B CN,
351: OKL_CNSLD_AR_STRMS_B ST,
352: AR_PAYMENT_SCHEDULES_ALL PS
353: WHERE PS.CLASS IN ('INV', 'CM')
354: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
355: AND CN.ID = ST.KHR_ID
356: and CN.CONTRACT_NUMBER = cp_contract_num