An Oracle-APEX-plugin that provides dynamic input items for an easy way to display and edit JSON-data in an APEX-application. The field-items are dynamically generate based on a JSON-schema. The ...
AND PRH.CREATION_DATE BETWEEN PPF1.EFFECTIVE_START_DATE AND PPF1.EFFECTIVE_END_DATE AND PPF2.AGENT_ID(+) = MSI.BUYER_ID AND (:P_PRAPPROVE_FROM_DT IS NULL OR TRUNC(PRH.APPROVED_DATE) BETWEEN ...