DBA Data[Home] [Help]

VIEW: APPS.RCV_ROUTING_HEADERS

Source

View Text - Preformatted

SELECT to_number(lookup_code) routing_header_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, meaning routing_name, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, description FROM fnd_lookup_values lv WHERE LANGUAGE = USERENV ('LANG') AND view_application_id = 0 AND security_group_id = 0 AND lookup_type = 'RCV_ROUTING_HEADERS'
View Text - HTML Formatted

SELECT TO_NUMBER(LOOKUP_CODE) ROUTING_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, MEANING ROUTING_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV ('LANG')
AND VIEW_APPLICATION_ID = 0
AND SECURITY_GROUP_ID = 0
AND LOOKUP_TYPE = 'RCV_ROUTING_HEADERS'