SELECT aabl.aging_bucket_line_id, aabl.report_heading1 || aabl.report_heading2, aabl.bucket_sequence_num, arp.amount_due_remaining, arp.invoice_currency_code, arp.invoice_currency_code, arp.amount_due_remaining, arp.invoice_currency_code, 0, arp.amount_due_remaining, arp.invoice_currency_code, 0, arp.amount_due_remaining, arp.invoice_currency_code, 0, arp.amount_due_remaining, arp.invoice_currency_code, 0 FROM ar_payment_schedules arp, ar_aging_buckets aab, ar_aging_bucket_lines aabl WHERE 1 = 2
SELECT AABL.AGING_BUCKET_LINE_ID
, AABL.REPORT_HEADING1 || AABL.REPORT_HEADING2
, AABL.BUCKET_SEQUENCE_NUM
, ARP.AMOUNT_DUE_REMAINING
, ARP.INVOICE_CURRENCY_CODE
, ARP.INVOICE_CURRENCY_CODE
, ARP.AMOUNT_DUE_REMAINING
, ARP.INVOICE_CURRENCY_CODE
, 0
, ARP.AMOUNT_DUE_REMAINING
, ARP.INVOICE_CURRENCY_CODE
, 0
, ARP.AMOUNT_DUE_REMAINING
, ARP.INVOICE_CURRENCY_CODE
, 0
, ARP.AMOUNT_DUE_REMAINING
, ARP.INVOICE_CURRENCY_CODE
, 0
FROM AR_PAYMENT_SCHEDULES ARP
, AR_AGING_BUCKETS AAB
, AR_AGING_BUCKET_LINES AABL
WHERE 1 = 2
|
|
|