BI Publisher – SQL Get Profile Options Values Get information on a profile option SELECT * FROM FND_PROFILE_OPTIONS_B WHERE PROFILE_OPTION_NAME = ‘{profile option name}’ Get… Read More »BI Publisher – SQL Get Profile Options Values
BI Publisher – SQL for Opportunities Get Sales Method SELECT * FROM MOO_SALES_METHOD_TL WHERE name LIKE ‘%%’ SELECT DISTINCT SALES_METHOD_ID, NAME FROM MOO_SALES_METHOD_TL Get Sales Stages select * from MOO_STG_B SELECT A.SALES_METHOD_ID, TL.NAME as METHOD_NAME, B.STG_ID as SALES_STAGE_ID,… Read More »BI Publisher – SQL for Opportunities
BI Publisher – SQL For Collecting info about an Contact SELECT contact.party_id, contact.PARTY_NUMBER, (CASE WHEN contact.PERSON_NAME IS NULL THEN ‘NO DATA’ ELSE contact.PERSON_NAME END) AS… Read More »BI Publisher – SQL For Collecting info about an Contact
BI Publisher – SQL For Collecting info about an Account SELECT hz_organization_profiles.party_id, hz_party_sites.location_id, hz_organization_profiles.party_number, hz_organization_profiles.organization_name, hz_locations.address1, hz_locations.city, hz_locations.country, hz_party_sites.END_DATE_ACTIVE, hz_party_sites.STATUS, ( CASE WHEN hz_organization_profiles.preferred_contact_person_id IS… Read More »BI Publisher – SQL For Collecting info about an Account
BI Publisher – SQL For Account with Details about Opty and SRs SELECT HZ_ORGANIZATION_PROFILES.PARTY_ID, HZ_PARTY_SITES.LOCATION_ID, HZ_ORGANIZATION_PROFILES.PARTY_NUMBER, HZ_ORGANIZATION_PROFILES.ORGANIZATION_NAME, HZ_LOCATIONS.ADDRESS1, HZ_LOCATIONS.CITY, HZ_LOCATIONS.COUNTRY, (SELECT COUNT(*) FROM FUSION.MOO_OPTY WHERE… Read More »BI Publisher – SQL For Account with Details about Opty and SRs
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