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

VIEW: FLM.FLM_EKB_DEMAND_INTERFACE#

Object Details
Object Name: FLM_EKB_DEMAND_INTERFACE#
Object Type: VIEW
Owner: FLM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
INVENTORY_ITEM_ID NUMBER

ITEM_SEGMENTS VARCHAR2 (2000)
SUBINVENTORY VARCHAR2 (10)
LOCATOR_ID NUMBER

LOCATOR_SEGMENTS VARCHAR2 (2000)
PULL_SEQUENCE_ID NUMBER

DEMAND_DATE DATE

DEMAND_QUANTITY NUMBER

AVERAGE_DEMAND NUMBER

DEMAND_START_DATE DATE

DEMAND_END_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_LOGIN NUMBER

ERROR VARCHAR2 (2000)
PROCESS_STATUS NUMBER

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 INTERFACE_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR_SEGMENTS
,      PULL_SEQUENCE_ID
,      DEMAND_DATE
,      DEMAND_QUANTITY
,      AVERAGE_DEMAND
,      DEMAND_START_DATE
,      DEMAND_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_LOGIN
,      ERROR
,      PROCESS_STATUS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM FLM.FLM_EKB_DEMAND_INTERFACE#;

Dependencies

[top of page]

FLM.FLM_EKB_DEMAND_INTERFACE# references the following:

SchemaFLM
TableFLM_EKB_DEMAND_INTERFACE
FLM.FLM_EKB_DEMAND_INTERFACE# is referenced by following:

SchemaAPPS
SynonymFLM_EKB_DEMAND_INTERFACE