DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 440: ar_payment_schedules_all aps,

436: FROM okl_txd_ar_ln_dtls_b tld,
437: ra_customer_trx_lines_all ractrl,
438: okl_txl_ar_inv_lns_b til,
439: okl_trx_ar_invoices_b tai,
440: ar_payment_schedules_all aps,
441: ar_receivable_applications_all raa,
442: ar_cash_receipts_all cra,
443: okl_strm_type_b sty_ln_pmt,
444: ar_distributions_all ad

Line 472: ar_payment_schedules_all aps,

468: FROM okl_txd_ar_ln_dtls_b tld,
469: ra_customer_trx_lines_all ractrl,
470: okl_txl_ar_inv_lns_b til,
471: okl_trx_ar_invoices_b tai,
472: ar_payment_schedules_all aps,
473: ar_receivable_applications_all raa,
474: ar_cash_receipts_all cra,
475: okl_strm_type_b sty_ln_pmt
476: WHERE tai.trx_status_code = 'PROCESSED'

Line 506: ar_payment_schedules_all aps,

502: FROM okl_txd_ar_ln_dtls_b tld,
503: ra_customer_trx_lines_all ractrl,
504: okl_txl_ar_inv_lns_b til,
505: okl_trx_ar_invoices_b tai,
506: ar_payment_schedules_all aps,
507: ar_receivable_applications_all raa,
508: ra_customer_trx_all cm,
509: okl_strm_type_b sty_ln_pmt,
510: ar_distributions_all ad

Line 538: ar_payment_schedules_all aps,

534: FROM okl_txd_ar_ln_dtls_b tld,
535: ra_customer_trx_lines_all ractrl,
536: okl_txl_ar_inv_lns_b til,
537: okl_trx_ar_invoices_b tai,
538: ar_payment_schedules_all aps,
539: ar_receivable_applications_all raa,
540: ra_customer_trx_all cm,
541: okl_strm_type_b sty_ln_pmt
542: WHERE tai.trx_status_code = 'PROCESSED'

Line 572: ar_payment_schedules_all aps,

568: FROM okl_txd_ar_ln_dtls_b tld,
569: ra_customer_trx_lines_all ractrl,
570: okl_txl_ar_inv_lns_b til,
571: okl_trx_ar_invoices_b tai,
572: ar_payment_schedules_all aps,
573: ar_adjustments_all adj,
574: okl_strm_type_b sty,
575: ar_distributions_all ad
576: WHERE tai.trx_status_code = 'PROCESSED'

Line 606: ar_payment_schedules_all aps,

602: FROM okl_txd_ar_ln_dtls_b tld,
603: ra_customer_trx_lines_all ractrl,
604: okl_txl_ar_inv_lns_b til,
605: okl_trx_ar_invoices_b tai,
606: ar_payment_schedules_all aps,
607: ar_receivable_applications_all raa,
608: ar_cash_receipts_all cra,
609: okl_strm_type_b sty
610: WHERE tai.trx_status_code = 'PROCESSED'

Line 634: ar_payment_schedules_all aps,

630: FROM okl_txd_ar_ln_dtls_b tld,
631: ra_customer_trx_lines_all ractrl,
632: okl_txl_ar_inv_lns_b til,
633: okl_trx_ar_invoices_b tai,
634: ar_payment_schedules_all aps,
635: ar_receivable_applications_all raa,
636: ra_customer_trx_all cm,
637: okl_strm_type_b sty
638: WHERE tai.trx_status_code = 'PROCESSED'

Line 662: ar_payment_schedules_all aps,

658: FROM okl_txd_ar_ln_dtls_b tld,
659: ra_customer_trx_lines_all ractrl,
660: okl_txl_ar_inv_lns_b til,
661: okl_trx_ar_invoices_b tai,
662: ar_payment_schedules_all aps,
663: ar_adjustments_all adj,
664: okl_strm_type_b sty
665: WHERE tai.trx_status_code = 'PROCESSED'
666: AND tai.khr_id = p_contract_id