VIEW: APPS.IGI_SAP_INVOICE_CLERK_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)