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

VIEW: WIP.WIP_SO_ALLOCATIONS_TEMP#

Object Details
Object Name: WIP_SO_ALLOCATIONS_TEMP#
Object Type: VIEW
Owner: WIP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ALLOCATION_ID NUMBER
Yes
WIP_ENTITY_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
DEMAND_SOURCE_HEADER_ID NUMBER
Yes
DEMAND_SOURCE_LINE VARCHAR2 (30)
USER_LINE_NUM VARCHAR2 (30)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
USER_DELIVERY VARCHAR2 (30)
QUANTITY_ALLOCATED NUMBER
Yes
QUANTITY_COMPLETED NUMBER
Yes
DEMAND_CLASS VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

GROUP_ID NUMBER

ACTION_CODE VARCHAR2 (30)
QUANTITY_CHANGED NUMBER

BOM_REVISION VARCHAR2 (3)
PRIMARY_ITEM_ID NUMBER

REQUIREMENT_DATE DATE

LINE_UOM VARCHAR2 (3)
Query Text

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


SELECT ALLOCATION_ID
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      USER_LINE_NUM
,      DEMAND_SOURCE_DELIVERY
,      USER_DELIVERY
,      QUANTITY_ALLOCATED
,      QUANTITY_COMPLETED
,      DEMAND_CLASS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      ACTION_CODE
,      QUANTITY_CHANGED
,      BOM_REVISION
,      PRIMARY_ITEM_ID
,      REQUIREMENT_DATE
,      LINE_UOM
FROM WIP.WIP_SO_ALLOCATIONS_TEMP#;

Dependencies

[top of page]

WIP.WIP_SO_ALLOCATIONS_TEMP# references the following:

SchemaWIP
TableWIP_SO_ALLOCATIONS_TEMP
WIP.WIP_SO_ALLOCATIONS_TEMP# is referenced by following:

SchemaAPPS
SynonymWIP_SO_ALLOCATIONS_TEMP