[Home] [Help]
View: 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
Name |
ROW_ID |
CHARGE_SERVICE_ID |
CHARGE_CENTER_ID |
SERVICE_ID |
NAME |
DESCRIPTION |
CREATION_CCID |
RECEIVING_CCID |
START_DATE |
END_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |