AR - 筛选到期余额不为零的发票

View Code 
1 SELECT DECODE(ARPT_SQL_FUNC_UTIL.GET_BALANCE_DUE_AS_OF_DATE(APS.PAYMENT_SCHEDULE_ID,
2                                                             APS.DUE_DATE,
3                                                             APS.CLASS),
4               0,
5               -1,
6               RTA.CUSTOMER_TRX_ID) CUSTOMER_TRX_ID1
7   FROM RA_CUSTOMER_TRX RTA, AR_PAYMENT_SCHEDULES APS
8  WHERE RTA.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID;

posted on 2012-10-09 10:04  Mnid  阅读(319)  评论(0)  编辑  收藏  举报