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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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