11-09-2014, 06:35 PM
Hello,
One of my clients required getting values of invoice status and accounted fields, the query which is used; there are no columns which are getting these values but functions instead.
apps.AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id)
And other is
APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code)
These functions return values are not the same as shown on invoice Form, m too much confused how can handle it.
Thanks,
Chakra
One of my clients required getting values of invoice status and accounted fields, the query which is used; there are no columns which are getting these values but functions instead.
apps.AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id)
And other is
APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code)
These functions return values are not the same as shown on invoice Form, m too much confused how can handle it.
Thanks,
Chakra