Posts by Mohammed Irfan

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, oarev.attribute_valfdst.short_textue FROM apps.fnd_documents_vl fdv, apps.fnd_documents_short_text fdst, apps.oe_attachment_rules_v oarv, apps.oe_attachment_rule_elements_v oarev, apps.hz_cust_site_uses_all hcsua, apps.hz_cust_acct_sites_all hcasa, apps.hz_cust_accounts hca, apps.hz_parties hp WHERE…

Read More

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, to_role, Details, SEQUENCE, NOTIFICATION_ID, ACTION_TYPE FROM (SELECT c.comment_date DATE1, TO_CHAR(c.comment_date,’DD-MON-RRRR HH24:MI:SS’)…

Read More

API to Load Values in Value Set

API to Load Values into Value Sets DECLARE —————————-Local Variables————————— l_enabled_flag VARCHAR2 (2); l_summary_flag VARCHAR2 (2); l_who_type FND_FLEX_LOADER_APIS.WHO_TYPE; l_user_id NUMBER := FND_GLOBAL.USER_ID; l_login_id NUMBER := FND_GLOBAL.LOGIN_ID; l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; l_value_set_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;…

Read More

OIC Steps to create Visual builder instance

oic-steps-to-create-visual-builder-instance

Read More