[Home] [Help]
View: HR_FR_ALTERNATE_LOOKUPS
View Text
SELECT UT.BUSINESS_GROUP_ID
, UT.USER_TABLE_NAME
, UC.USER_COLUMN_NAME
, UR.ROW_LOW_RANGE_OR_NAME
, UCI.VALUE
, GREATEST(UR.EFFECTIVE_START_DATE
, UCI.EFFECTIVE_START_DATE)
, LEAST(UR.EFFECTIVE_END_DATE
, UCI.EFFECTIVE_END_DATE)
FROM PAY_USER_TABLES UT
, PAY_USER_ROWS_F UR
, PAY_USER_COLUMNS UC
, PAY_USER_COLUMN_INSTANCES_F UCI
WHERE UT.USER_TABLE_ID = UR.USER_TABLE_ID AND UT.USER_TABLE_ID = UC.USER_TABLE_ID
AND UC.USER_COLUMN_ID = UCI.USER_COLUMN_ID AND UR.USER_ROW_ID = UCI.USER_ROW_ID AND UR.EFFECTIVE_START_DATE <= UCI.EFFECTIVE_END_DATE AND UR.EFFECTIVE_END_DATE >= UCI.EFFECTIVE_START_DATE
Columns
Name |
BUSINESS_GROUP_ID |
LOOKUP_TYPE |
FUNCTION_TYPE |
LOOKUP_CODE |
ALTERNATE_CODE |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |