View: IGI_ITR_CHARGE_SERVICE_SS_V

Product:	IGI - Public Sector Financials International
Description:
Implementation/DBA Data:	APPS.IGI_ITR_CHARGE_SERVICE_SS_V

View Text

SELECT SERV.ROWID ROW_ID
, SERV.CHARGE_SERVICE_ID CHARGE_SERVICE_ID
, SERV.CHARGE_CENTER_ID CHARGE_CENTER_ID
, SERV.SERVICE_ID SERVICE_ID
, SERVI.NAME NAME
, SERVI.DESCRIPTION DESCRIPTION
, SERV.CREATION_CCID CREATION_CCID
, SERV.RECEIVING_CCID RECEIVING_CCID
, SERV.START_DATE START_DATE
, SERV.END_DATE END_DATE
, SERV.CREATION_DATE CREATION_DATE
, SERV.CREATED_BY CREATED_BY
, SERV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SERV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SERV.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGI_ITR_SERVICE SERVI
, IGI_ITR_CHARGE_CENTER CC
, IGI_ITR_CHARGE_SERVICE SERV
WHERE SERVI.SERVICE_ID = SERV.SERVICE_ID
AND SERV.CHARGE_CENTER_ID = CC.CHARGE_CENTER_ID

Columns