Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CT.ROWID ROW_ID
, PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CT.TRX_NUMBER TRX_NUMBER
, CT.TRX_DATE TRX_DATE
, CT.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AL_CLASS.MEANING AL_CLASS_MEANING
, CT.PURCHASE_ORDER CT_PURCHASE_ORDER
, CT.WAYBILL_NUMBER WAYBILL_NUMBER
, SUM(DECODE(PS.AMOUNT_DUE_REMAINING
, 0
, NULL
, TRUNC(SYSDATE) - PS.DUE_DATE)) DAYS_PAST_DUE
, MIN(PS.DUE_DATE) DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED AMOUNT_APPLIED
, PS.AMOUNT_CREDITED AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA SHIP_VIA
, PS.CUSTOMER_ID CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.CASH_RECEIPT_ID CASH_RECEIPT_ID
, PS.CLASS CLASS
, PS.STATUS STATUS
, PS.RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG
FROM AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX CT
, AR_LOOKUPS AL_CLASS
WHERE PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM' GROUP BY CT.ROWID
, PS.PAYMENT_SCHEDULE_ID
, CT.TRX_NUMBER
, CT.TRX_DATE
, CT.INVOICE_CURRENCY_CODE
, PS.CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID
, PS.CASH_RECEIPT_ID
, PS.CLASS
, PS.STATUS
, PS.RECEIPT_CONFIRMED_FLAG
, AL_CLASS.MEANING
, CT.PURCHASE_ORDER
, CT.WAYBILL_NUMBER
, PS.AMOUNT_DUE_REMAINING
, PS.DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA