BI Publisher – Get the ESS REQUEST LOGS SELECT ESS_REQUEST_ID, ERROR_MESSAGE , JOB_ITEM_STATUS FROM MOW_BATCH_ASGN_JOB_ITEMS WHERE ESS_REQUEST_ID = ‘{Numeric ID of the Request}’ AND JOB_ITEM_STATUS=’-1′ AND rownum
BI Publisher – Get Opportunity Info With account and contact name and phone SELECT o.NAME as Opty_Name, o.OPTY_ID, o.CUST_PARTY_ID, o.PR_CON_PARTY_ID, (select PARTY_NAME FROM HZ_PARTIES WHERE PARTY_ID =… Read More »BI Publisher – Get Opportunity Info With account and contact name and phone
BI Publisher – Get Object Information 1 – Find out in what table is a custom object been stored. select * from fusion.adf_extensible_table_usage where ENTITYDEF_FULLNAME… Read More »BI Publisher – Get Object Information
BI Publisher – Get LOOKUP VALUES SELECT ENTERPRISE_ID, LOOKUP_TYPE, LOOKUP_CODE FROM FND_LOOKUP_VALUES_B WHERE LOOKUP_TYPE = ‘{SomeValue}’
BI Publisher- Get Assignment Rules Get All Rules SELECT * FROM MOW_RULES Get Rule Conditions SELECT * FROM MOW_RULE_CONDITIONS WHERE RULE_GUID = ANY ( SELECT… Read More »BI Publisher- Get Assignment Rules