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

VIEW: INV.MTL_DEMAND_HISTORIES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
PERIOD_START_DATE DATE
Yes
PERIOD_TYPE NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

STD_WIP_USAGE NUMBER
Yes
CLOSED_FLAG VARCHAR2 (1)
SALES_ORDER_DEMAND NUMBER
Yes
MISCELLANEOUS_ISSUE NUMBER
Yes
INTERORG_ISSUE NUMBER
Yes
C_COLUMN1 VARCHAR2 (240)
C_COLUMN2 VARCHAR2 (240)
C_COLUMN3 VARCHAR2 (240)
C_COLUMN4 VARCHAR2 (240)
C_COLUMN5 VARCHAR2 (240)
N_COLUMN1 NUMBER

N_COLUMN2 NUMBER

N_COLUMN3 NUMBER

N_COLUMN4 NUMBER

N_COLUMN5 NUMBER

D_COLUMN1 DATE

D_COLUMN2 DATE

D_COLUMN3 DATE

D_COLUMN4 DATE

D_COLUMN5 DATE

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_START_DATE
,      PERIOD_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STD_WIP_USAGE
,      CLOSED_FLAG
,      SALES_ORDER_DEMAND
,      MISCELLANEOUS_ISSUE
,      INTERORG_ISSUE
,      C_COLUMN1
,      C_COLUMN2
,      C_COLUMN3
,      C_COLUMN4
,      C_COLUMN5
,      N_COLUMN1
,      N_COLUMN2
,      N_COLUMN3
,      N_COLUMN4
,      N_COLUMN5
,      D_COLUMN1
,      D_COLUMN2
,      D_COLUMN3
,      D_COLUMN4
,      D_COLUMN5
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_DEMAND_HISTORIES#;

Dependencies

[top of page]

INV.MTL_DEMAND_HISTORIES# references the following:

SchemaINV
TableMTL_DEMAND_HISTORIES
INV.MTL_DEMAND_HISTORIES# is referenced by following:

SchemaAPPS
SynonymMTL_DEMAND_HISTORIES