VIEW: APPS.HXTFV_VARIANCES

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ var_type variance_type ,hr_general.decode_lookup('HXT_VARIANCE_PERIOD',var.fcl_period) variance_period ,var.high high_threshold ,var.average average_threshold ,var.low low_threshold ,var.date_from start_date ,var.date_to end_date ,orgT.name organization_name ,var.balance_name balance_name ,var.balance_dimension balance_dimension ,var.balance_level balance_level ,locT.location_code location_name ,pet.element_name element_name /*******/ /* Ids */ /*******/ ,var.element_type_id element_type_id ,var.location_id location_id ,var.organization_id organization_id ,var.var_type_id variance_type_id FROM hxt_variances var ,hr_all_organization_units_tl orgT ,hr_locations_all_tl locT ,pay_element_types_f pet WHERE var.organization_id = orgT.organization_id (+) AND var.location_id = locT.location_id (+) AND var.element_type_id = pet.element_type_id (+) AND locT.language (+) = userenv('LANG') AND orgT.language (+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ VAR_TYPE VARIANCE_TYPE
, HR_GENERAL.DECODE_LOOKUP('HXT_VARIANCE_PERIOD'
, VAR.FCL_PERIOD) VARIANCE_PERIOD
, VAR.HIGH HIGH_THRESHOLD
, VAR.AVERAGE AVERAGE_THRESHOLD
, VAR.LOW LOW_THRESHOLD
, VAR.DATE_FROM START_DATE
, VAR.DATE_TO END_DATE
, ORGT.NAME ORGANIZATION_NAME
, VAR.BALANCE_NAME BALANCE_NAME
, VAR.BALANCE_DIMENSION BALANCE_DIMENSION
, VAR.BALANCE_LEVEL BALANCE_LEVEL
, LOCT.LOCATION_CODE LOCATION_NAME
, PET.ELEMENT_NAME ELEMENT_NAME /*******/ /* IDS */ /*******/
, VAR.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, VAR.LOCATION_ID LOCATION_ID
, VAR.ORGANIZATION_ID ORGANIZATION_ID
, VAR.VAR_TYPE_ID VARIANCE_TYPE_ID
FROM HXT_VARIANCES VAR
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_LOCATIONS_ALL_TL LOCT
, PAY_ELEMENT_TYPES_F PET
WHERE VAR.ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND VAR.LOCATION_ID = LOCT.LOCATION_ID (+)
AND VAR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID (+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ORGT.LANGUAGE (+) = USERENV('LANG') WITH READ ONLY