FND Technical SQL Queries

FND Technical SQL Queries

SELECT oracle_process_id FROM fnd_concurrent_requests WHERE request_id=:Request_id

select * from fnd_user where employee_id=:Employee_id

select * from FND_GRANTS where GRANTEE_KEY=:User_Name

SELECT FU.USER_NAME
FROM APPS.PER_ALL_PEOPLE_F A ,
  APPS.FND_USER FU
WHERE A.PERSON_ID  = 161133
AND FU.EMPLOYEE_ID = a.PERSON_ID
AND sysdate BETWEEN a.EFFECTIVE_START_DATE AND a.EFFECTIVE_END_DATE

SELECT MAX(log_sequence)
           FROM FND_LOG_MESSAGES;

 SELECT log.module, log.message_text
             FROM FND_LOG_MESSAGES LOG,
                          FND_LOG_TRANSACTION_CONTEXT CON
             WHERE CON.TRANSACTION_ID = '29238894'
             AND CON.TRANSACTION_TYPE = 'REQUEST'
             AND CON.TRANSACTION_CONTEXT_ID = LOG.TRANSACTION_CONTEXT_ID
             ORDER BY LOG.LOG_SEQUENCE