[Home] [Help]
View: IGI_SAP_DEPT_APPROVERS_V
Product: | IGI - Public Sector Financials International |
Description: | Provides information about department approvers responsible for Secondary Invoice Approvals. |
Implementation/DBA Data: |
APPS.IGI_SAP_DEPT_APPROVERS_V
|
View Text
SELECT SDA.APPROVER_ID
, FU.USER_NAME
, SDA.START_DATE_ACTIVE
, SDA.END_DATE_ACTIVE
, SDA.GROUP_ID
, HR.FULL_NAME
, SDA.CREATION_DATE
, SDA.CREATED_BY
, SDA.LAST_UPDATE_LOGIN
, SDA.LAST_UPDATE_DATE
, SDA.LAST_UPDATED_BY
, SDA.ROWID
FROM FND_USER FU
, HR_EMPLOYEES HR
, IGI_SAP_DEPARTMENT_APPROVERS SDA
WHERE SDA.APPROVER_ID = FU.USER_ID
AND FU.EMPLOYEE_ID = HR.EMPLOYEE_ID(+)
Columns
Name |
APPROVER_ID |
USER_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
GROUP_ID |
FULL_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
ROW_ID |