SELECT '_KF:INV:MICG:IT' , IT.INACTIVE_DATE , IT.DESCRIPTION , '_DF:INV:MTL_ITEM_CATALOG_GROUPS:IT' , IT.ITEM_CATALOG_GROUP_ID , IT.CREATION_DATE , IT.CREATED_BY , IT.LAST_UPDATE_DATE , IT.LAST_UPDATED_BY FROM MTL_ITEM_CATALOG_GROUPS IT with read only
SELECT '_KF:INV:MICG:IT'
, IT.INACTIVE_DATE
, IT.DESCRIPTION
, '_DF:INV:MTL_ITEM_CATALOG_GROUPS:IT'
, IT.ITEM_CATALOG_GROUP_ID
, IT.CREATION_DATE
, IT.CREATED_BY
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATED_BY
FROM MTL_ITEM_CATALOG_GROUPS IT WITH READ ONLY
|
|
|