VIEW: INV.MTL_ITEM_CATEGORIES_INTERFACE#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_ID CATEGORY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORGANIZATION_ID ORGANIZATION_ID, TRANSACTION_ID TRANSACTION_ID, PROCESS_FLAG PROCESS_FLAG, CATEGORY_SET_NAME CATEGORY_SET_NAME, CATEGORY_NAME CATEGORY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ITEM_NUMBER ITEM_NUMBER, TRANSACTION_TYPE TRANSACTION_TYPE, SET_PROCESS_ID SET_PROCESS_ID, OLD_CATEGORY_ID OLD_CATEGORY_ID, OLD_CATEGORY_NAME OLD_CATEGORY_NAME, SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE, CHANGE_ID CHANGE_ID, CHANGE_LINE_ID CHANGE_LINE_ID, BUNDLE_ID BUNDLE_ID from "INV"."MTL_ITEM_CATEGORIES_INTERFACE"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSACTION_ID TRANSACTION_ID
, PROCESS_FLAG PROCESS_FLAG
, CATEGORY_SET_NAME CATEGORY_SET_NAME
, CATEGORY_NAME CATEGORY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, ITEM_NUMBER ITEM_NUMBER
, TRANSACTION_TYPE TRANSACTION_TYPE
, SET_PROCESS_ID SET_PROCESS_ID
, OLD_CATEGORY_ID OLD_CATEGORY_ID
, OLD_CATEGORY_NAME OLD_CATEGORY_NAME
, SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID
, SOURCE_SYSTEM_REFERENCE SOURCE_SYSTEM_REFERENCE
, CHANGE_ID CHANGE_ID
, CHANGE_LINE_ID CHANGE_LINE_ID
, BUNDLE_ID BUNDLE_ID
FROM "INV"."MTL_ITEM_CATEGORIES_INTERFACE"