Query to extract Active BOL_NOTES for all Active Customers
SELECT hp.party_name “CUSTOMER_NAME”, fdv.category_description “Catergory Description”, fdv.document_id, fdv.title, fdst.short_text, fdst.media_id, oarev.attribute_name, [...]
Query for Project & Change Order Approval Action History:
SELECT ROWNUM, ACTION_DATE, ACTION, from_user, from_role, to_user, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT ACTION_DATE, ACTION, from_user, from_role, to_user, [...]
API to Load Values in Value Set
API to Load Values into Value Sets DECLARE —————————-Local Variables————————— [...]