[Home] [Help]
255: THEN
256:
257: SELECT org_id
258: INTO l_org_id
259: FROM AR_RECEIVABLE_APPLICATIONS_ALL
260: WHERE receivable_application_id = p_unique_id;
261:
262: ELSIF p_column_name = 'ADJUSTMENT_ID'
263: THEN
1083: select inv_ps.status trx_ps_status,
1084: rcpt_ps.status rcpt_ps_status,
1085: to_char(inv_ps.due_date , 'J') due_date,
1086: inv_ps.amount_applied
1087: from ar_receivable_applications ra,
1088: ar_payment_schedules inv_ps,
1089: ar_payment_schedules rcpt_ps
1090: where ra.receivable_application_id = ra_id
1091: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1183: ra.amount_applied_from,
1184: inv_ps.amount_due_remaining,
1185: ra.earned_discount_taken,
1186: ra.unearned_discount_taken
1187: from ar_receivable_applications ra,
1188: ar_payment_schedules inv_ps,
1189: ar_payment_schedules rcpt_ps
1190: where ra.receivable_application_id = ra_id
1191: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1349: select inv_ps.status trx_ps_status,
1350: cm_ps.status cm_ps_status,
1351: to_char(inv_ps.due_date , 'J') due_date,
1352: inv_ps.amount_applied
1353: from ar_receivable_applications ra,
1354: ar_payment_schedules inv_ps,
1355: ar_payment_schedules cm_ps
1356: where ra.receivable_application_id = ra_id
1357: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id
1444: select inv_ps.status trx_ps_status,
1445: cm_ps.status cm_ps_status,
1446: to_char(inv_ps.due_date , 'J') due_date,
1447: inv_ps.amount_applied
1448: from ar_receivable_applications ra,
1449: ar_payment_schedules inv_ps,
1450: ar_payment_schedules cm_ps
1451: where ra.receivable_application_id = ra_id
1452: and ra.applied_payment_schedule_id = inv_ps.payment_schedule_id