HXT Variance Table Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Variance Table Listing (XML)
Short Name: HXT957F_XML
DB package: HXT_HXT957F_XMLP_PKG
Run HXT Variance Table Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
HXT Earning Variance Calculation HXT Organization Variance Calc HXT Location Variance Calculation HXT Total Table Entries HXT Earning Policy Table Listing HXT Rotation Plan Table Listing HXT Work Plan Table Listing HXT Holiday Calendar Table HXT Prem. Interaction Plcy Tbl Lst
Blitz Report™

Blitz Report™ provides multiple benefits: