HXT Variance Table Listing

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Variance Table Listing (XML)
Short Name: HXT957F_XML
DB package: HXT_HXT957F_XMLP_PKG
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