[Home] [Help]
View: ITG_TRANSFER_RULE_MAP_V
Product: | ITG - Internet Procurement Enterprise Connector |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT M.ROWID ROW_ID
, M.MAP_ID
, M.ACTION_ID
, M.TO_VALUE
, 'DETAIL' TRANSFER_LEVEL
, M.RANGE_TYPE_CODE
, M.SYS_ID_NUM
, ID.ID_DESC_SHORT
, M.FROM_VALUE
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.LAST_UPDATE_LOGIN
FROM ITG_TRANSFER_RULE_MAP M
, ITG_CATALOG_OF_IDS ID
WHERE ID.SYS_ID_NUM (+) = M.SYS_ID_NUM
Columns
Name |
ROW_ID |
MAP_ID |
ACTION_ID |
TO_VALUE |
TRANSFER_LEVEL |
RANGE_TYPE_CODE |
SYS_ID_NUM |
ID_DESC_SHORT |
FROM_VALUE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |