API to Fetch Hold Release Date for AP Invoice
Hi Team,
is there any standard api or function available to fetch the release date from AP_HOLDS_V ?
I see that view is using the logic to print release date as below
DECODE (AH.RELEASE_LOOKUP_CODE, NULL, NULL, AH.LAST_UPDATE_DATE)
I need to extract invoices which were on-hold a specific date. The date can be in past or present. Expectation is that whatever date user is providing, code should be able to fetch the invoice if the invoice was on hold on that date.
Regards,
Shareef.