DBA Data[Home] [Help] [Dependency Information]

VIEW: INV.MTL_ITEM_CATEGORIES_INTERFACE#

Object Details
Object Name: MTL_ITEM_CATEGORIES_INTERFACE#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

CATEGORY_SET_ID NUMBER

CATEGORY_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORGANIZATION_ID NUMBER

TRANSACTION_ID NUMBER

PROCESS_FLAG NUMBER

CATEGORY_SET_NAME VARCHAR2 (30)
CATEGORY_NAME VARCHAR2 (81)
ORGANIZATION_CODE VARCHAR2 (3)
ITEM_NUMBER VARCHAR2 (81)
TRANSACTION_TYPE VARCHAR2 (10)
SET_PROCESS_ID NUMBER
Yes
OLD_CATEGORY_ID NUMBER

OLD_CATEGORY_NAME VARCHAR2 (81)
SOURCE_SYSTEM_ID NUMBER

SOURCE_SYSTEM_REFERENCE VARCHAR2 (255)
CHANGE_ID NUMBER

CHANGE_LINE_ID NUMBER

BUNDLE_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

INV.MTL_ITEM_CATEGORIES_INTERFACE# references the following:

SchemaINV
TableMTL_ITEM_CATEGORIES_INTERFACE
INV.MTL_ITEM_CATEGORIES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMTL_ITEM_CATEGORIES_INTERFACE