VIEW: APPS.PQH_ROUTING_HIST_ATTRIBS_V

Source

View Text - Preformatted

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, 1), to_char(rha.from_number))) from_col , nvl(rha.to_char, nvl(fnd_date.date_to_displaydate(rha.to_date, 1), to_char(rha.to_number))) to_col , nvl(rha.value_char, nvl(fnd_date.date_to_displaydate(rha.value_date, 1), 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

View Text - HTML Formatted

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
, 1)
, TO_CHAR(RHA.FROM_NUMBER))) FROM_COL
, NVL(RHA.TO_CHAR
, NVL(FND_DATE.DATE_TO_DISPLAYDATE(RHA.TO_DATE
, 1)
, TO_CHAR(RHA.TO_NUMBER))) TO_COL
, NVL(RHA.VALUE_CHAR
, NVL(FND_DATE.DATE_TO_DISPLAYDATE(RHA.VALUE_DATE
, 1)
, 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