Product: | PO - Purchasing |
---|---|
Description: | View on FND_LOOKUPS for receiving routing types |
Implementation/DBA Data: |
![]() |
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'