Search guides, SQL, error codes, and procedures — or browse by topic below.
388 guides · 8 topics
API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...
Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...
Basic SELECTSELECT name, salary FROM employees;All ColumnsSELECT * FROM employees;
SELECT DISTINCT A.APPLICATION_ID , A.application_short_name , b.application_name , c.RESPO...
DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id...
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
Updated Aug 28, 2026
security-parametersLists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Updated Aug 18, 2026
security-parametersLists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Aug 22, 2026
security-parametersLists the Ledgers the current user has direct data access to — used as the LOV source for a "Ledger" report parame...
Updated Aug 22, 2026
security-parametersLists the Fixed Asset Books the current user has data access to — used as the LOV source for a Fixed Assets report...
Updated Aug 22, 2026
security-parametersLists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Aug 22, 2026
Guides filed under this topic.
SELECT b.party_name, a.orig_system_reference AS "Customer REF", d.site_use_code, d.orig_system_refe...
SELECT b.party_name, b.party_type, a.cust_account_id, b.party_id, a.account_number, a...
SELECT a.PARTY_NAME, a.PARTY_ID, a.PARTY_NUMBER, a.PARTY_TYPE, a.ORIG_SYSTEM_REFERENCE,...
SELECT accounts.party_id, accounts.account_name, accounts.account_number, party_sites.party_site_na...
SELECT HZ.PARTY_ID, CUSTOMERACCOUNTSITEPEO.CUST_ACCOUNT_ID, HZ.PARTY_NAME, lOCATIONPEO.ADDRESS_STYL...
SELECT PARTY_ID, Person_last_name, person_first_name, party_number, party_name, statu...
SELECT hzporg.PARTY_NUMBER, hzporg.PARTY_NAME, hzporg.PARTY_TYPE, hZp.Person_last_name, hZp....
SELECT hzo.CONTACT_NUMBER, hzporg.PARTY_NUMBER, hzporg.PARTY_NAME, hzporg.PARTY_TYPE, hzr.su...