VIEW: APPS.IGI_ITR_CHARGE_SERVICE_SS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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