HXT Variance Table Listing
Description
- Categories
- BI Publisher
- Application
- Time and Labor
- Source
- Variance Table Listing (XML)
- Short Name
- HXT957F_XML
- DB package
- HXT_HXT957F_XMLP_PKG
SQL 21 lines
SELECT VAR_TYPE, FCL_PERIOD, VAR_TYPE_ID, BALANCE_NAME, BALANCE_DIMENSION, BALANCE_LEVEL, DATE_FROM, DATE_TO, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, HIGH, LOW, AVERAGE, HXT_HXT957F_XMLP_PKG.var_type_desformula(HXT_VARIANCES.VAR_TYPE) VAR_TYPE_DES, HXT_HXT957F_XMLP_PKG.var_type_nameformula(HXT_VARIANCES.VAR_TYPE,HXT_VARIANCES.VAR_TYPE_ID) VAR_TYPE_NAME FROM HXT_VARIANCES ORDER BY VAR_TYPE |