[Home] [Help]
View: IGI_SAP_INVOICE_CLERK_V
Product: | IGI - Public Sector Financials International |
Description: | Provides information about Secondary Invoice Approval clerks. |
Implementation/DBA Data: |
APPS.IGI_SAP_INVOICE_CLERK_V
|
View Text
SELECT SIC.CLERK_ID
, SIC.GROUP_ID
, FU.USER_NAME
, HR.FULL_NAME
, SIC.START_DATE_ACTIVE
, SIC.END_DATE_ACTIVE
, SIC.CREATION_DATE
, SIC.CREATED_BY
, SIC.LAST_UPDATE_LOGIN
, SIC.LAST_UPDATE_DATE
, SIC.LAST_UPDATED_BY
, SIC.ROWID
FROM FND_USER FU
, HR_EMPLOYEES HR
, IGI_SAP_INVOICE_CLERK SIC
WHERE SIC.CLERK_ID = FU.USER_ID
AND FU.EMPLOYEE_ID = HR.EMPLOYEE_ID(+)
Columns
Name |
CLERK_ID |
GROUP_ID |
USER_NAME |
FULL_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
ROW_ID |