Product: | ITG - Internet Procurement Enterprise Connector |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID
, RANGE_ID
, ACTION_ID
, COPY_ID
, MAP_ID
, LOW_VALUE
, HIGH_VALUE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, TO_DATE(NULL)
, TO_DATE(NULL)
, -1
, '-1'
FROM ITG_TRANSFER_RULE_RANGES UNION ALL SELECT ROWID
, -1
, -1
, -1
, -1
, CHILD_FLEX_VALUE_LOW
, CHILD_FLEX_VALUE_HIGH
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, FLEX_VALUE_SET_ID
, PARENT_FLEX_VALUE
FROM FND_FLEX_VALUE_HIERARCHIES