Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_ROUTING_HIST_ATTRIBS_V |
SELECT RHA.ROWID ROW_ID
, RHA.ROUTING_HIST_ATTRIB_ID
, RHA.ROUTING_HISTORY_ID
, RHA.ATTRIBUTE_ID
, ATV.ATTRIBUTE_NAME
, NVL(RHA.FROM_CHAR
, NVL(FND_DATE.DATE_TO_DISPLAYDATE(RHA.FROM_DATE)
, TO_CHAR(RHA.FROM_NUMBER))) FROM_COL
, NVL(RHA.TO_CHAR
, NVL(FND_DATE.DATE_TO_DISPLAYDATE(RHA.TO_DATE)
, TO_CHAR(RHA.TO_NUMBER))) TO_COL
, NVL(RHA.VALUE_CHAR
, NVL(FND_DATE.DATE_TO_DISPLAYDATE(RHA.VALUE_DATE)
, TO_CHAR(RHA.VALUE_NUMBER))) VALUE_COL
, RHA.RANGE_TYPE_CD
, RHA.CREATED_BY
, RHA.CREATION_DATE
, RHA.LAST_UPDATED_BY
, RHA.LAST_UPDATE_DATE
, RHA.LAST_UPDATE_LOGIN
, RHA.OBJECT_VERSION_NUMBER
FROM PQH_ROUTING_HIST_ATTRIBS RHA
, PQH_ATTRIBUTES_VL ATV
WHERE RHA.ATTRIBUTE_ID = ATV.ATTRIBUTE_ID