[Home] [Help]
939: select inv_ps.status trx_ps_status,
940: rcpt_ps.status rcpt_ps_status,
941: to_char(inv_ps.due_date , 'J') due_date,
942: inv_ps.amount_applied
943: from ar_receivable_applications ra,
944: ar_payment_schedules inv_ps,
945: ar_payment_schedules rcpt_ps
946: where ra.receivable_application_id = ra_id
947: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1032: ra.amount_applied_from,
1033: inv_ps.amount_due_remaining,
1034: ra.earned_discount_taken,
1035: ra.unearned_discount_taken
1036: from ar_receivable_applications ra,
1037: ar_payment_schedules inv_ps,
1038: ar_payment_schedules rcpt_ps
1039: where ra.receivable_application_id = ra_id
1040: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1192: select inv_ps.status trx_ps_status,
1193: cm_ps.status cm_ps_status,
1194: to_char(inv_ps.due_date , 'J') due_date,
1195: inv_ps.amount_applied
1196: from ar_receivable_applications ra,
1197: ar_payment_schedules inv_ps,
1198: ar_payment_schedules cm_ps
1199: where ra.receivable_application_id = ra_id
1200: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1282: select inv_ps.status trx_ps_status,
1283: cm_ps.status cm_ps_status,
1284: to_char(inv_ps.due_date , 'J') due_date,
1285: inv_ps.amount_applied
1286: from ar_receivable_applications ra,
1287: ar_payment_schedules inv_ps,
1288: ar_payment_schedules cm_ps
1289: where ra.receivable_application_id = ra_id
1290: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id