2014年9月15日 星期一

[ Oracle ERP ] AP Invoice PAID BY & PAID_DATE

AP Invoice Actual Payment
FORM: APXIWALL.FMB
VIEW: AP_PAYMENT_SCHEDULES_V
FUNCTION: AP_INVOICE_PAYMENTS_PKG

AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY(AI.INVOICE_ID, APS.PAYMENT_NUM) PAID_BY,
       AP_INVOICE_PAYMENTS_PKG.GET_PAID_DATE(AI.INVOICE_ID, APS.PAYMENT_NUM) PAID_DATE,
       AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_ID(AI.INVOICE_ID,
                                              APS.PAYMENT_NUM) PAYMENT_ID,
       AP_INVOICE_PAYMENTS_PKG.GET_PAYMENT_TYPE(AI.INVOICE_ID,
                                                APS.PAYMENT_NUM) PAYMENT_TYPE,






沒有留言:

張貼留言