DBA Data[Home] [Help]

VIEW: APPS.IGS_PS_USEC_SP_FEES_V

Source

View Text - Preformatted

SELECT USCF.ROWID ROW_ID, USCF.USEC_SP_FEES_ID, USCF.UOO_ID, USCF.FEE_TYPE, FEE.DESCRIPTION FEE_TYPE_DESC, USCF.SP_FEE_AMT, USCF.CLOSED_FLAG, USCF.CREATED_BY, USCF.CREATION_DATE, USCF.LAST_UPDATED_BY, USCF.LAST_UPDATE_DATE, USCF.LAST_UPDATE_LOGIN FROM IGS_PS_USEC_SP_FEES USCF, IGS_FI_FEE_TYPE_ALL FEE WHERE USCF.FEE_TYPE = FEE.FEE_TYPE
View Text - HTML Formatted

SELECT USCF.ROWID ROW_ID
, USCF.USEC_SP_FEES_ID
, USCF.UOO_ID
, USCF.FEE_TYPE
, FEE.DESCRIPTION FEE_TYPE_DESC
, USCF.SP_FEE_AMT
, USCF.CLOSED_FLAG
, USCF.CREATED_BY
, USCF.CREATION_DATE
, USCF.LAST_UPDATED_BY
, USCF.LAST_UPDATE_DATE
, USCF.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_SP_FEES USCF
, IGS_FI_FEE_TYPE_ALL FEE
WHERE USCF.FEE_TYPE = FEE.FEE_TYPE