"Oracle Apps -Learn and grow" ,here we are sharing queries,technical and functional knowledge of oracle Apps.
SELECT DISTINCT
hold_date
, hold_lookup_code
, hold_reason
FROM
ap_holds_all
WHERE
invoice_id = :P_INVOICE_ID
and STATUS_FLAG='S'