Skip to content

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

VIEW: WSM.WSM_LOT_JOB_INTERFACE#

Object Details
Object Name: WSM_LOT_JOB_INTERFACE#
Object Type: VIEW
Owner: WSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MODE_FLAG NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

GROUP_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

PROCESS_TYPE NUMBER

ORGANIZATION_ID NUMBER

LOAD_TYPE NUMBER
Yes
STATUS_TYPE NUMBER

OLD_STATUS_TYPE NUMBER

LAST_UNIT_COMPLETION_DATE DATE

OLD_COMPLETION_DATE DATE

PROCESSING_WORK_DAYS NUMBER

DAILY_PRODUCTION_RATE NUMBER

LINE_ID NUMBER

PRIMARY_ITEM_ID NUMBER

BOM_REFERENCE_ID NUMBER

ROUTING_REFERENCE_ID NUMBER

BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

WIP_SUPPLY_TYPE NUMBER

CLASS_CODE VARCHAR2 (10)
LOT_NUMBER VARCHAR2 (80)
LOT_CONTROL_CODE NUMBER

JOB_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (240)
FIRM_PLANNED_FLAG NUMBER

ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
DEMAND_CLASS VARCHAR2 (30)
START_QUANTITY NUMBER

OLD_START_QUANTITY NUMBER

WIP_ENTITY_ID NUMBER

REPETITIVE_SCHEDULE_ID NUMBER

ERROR VARCHAR2 (240)
PARENT_GROUP_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
INTERFACE_ID NUMBER

LAST_UPDATED_BY_NAME VARCHAR2 (100)
CREATED_BY_NAME VARCHAR2 (100)
PROCESS_PHASE NUMBER

PROCESS_STATUS NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
FIRST_UNIT_START_DATE DATE

FIRST_UNIT_COMPLETION_DATE DATE

LAST_UNIT_START_DATE DATE

SCHEDULING_METHOD NUMBER

LINE_CODE VARCHAR2 (10)
PRIMARY_ITEM_SEGMENTS VARCHAR2 (2000)
BOM_REFERENCE_SEGMENTS VARCHAR2 (2000)
ROUTING_REFERENCE_SEGMENTS VARCHAR2 (2000)
ROUTING_REVISION VARCHAR2 (3)
BOM_REVISION VARCHAR2 (3)
COMPLETION_SUBINVENTORY VARCHAR2 (10)
COMPLETION_LOCATOR_ID NUMBER

COMPLETION_LOCATOR_SEGMENTS VARCHAR2 (2000)
SCHEDULE_GROUP_ID NUMBER

SCHEDULE_GROUP_NAME VARCHAR2 (30)
BUILD_SEQUENCE NUMBER

PROJECT_ID NUMBER

PROJECT_NAME VARCHAR2 (30)
TASK_ID NUMBER

TASK_NAME VARCHAR2 (20)
NET_QUANTITY NUMBER

DESCRIPTIVE_FLEX_SEGMENTS VARCHAR2 (2000)
PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
PROJECT_COSTED NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

OVERCOMPLETION_TOLERANCE_VALUE NUMBER

KANBAN_CARD_ID NUMBER

PRIORITY NUMBER

DUE_DATE DATE

ALLOW_EXPLOSION VARCHAR2 (1)
HEADER_ID NUMBER
Yes
DELIVERY_ID NUMBER

ERROR_CODE NUMBER

ERROR_MSG VARCHAR2 (2000)
COPRODUCTS_SUPPLY NUMBER

XML_DOCUMENT_ID VARCHAR2 (240)
JOB_TYPE NUMBER

DATE_RELEASED DATE

TRANSACTION_DATE DATE

NUM_OF_CHILDREN NUMBER

Query Text

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


SELECT MODE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      PROCESS_TYPE
,      ORGANIZATION_ID
,      LOAD_TYPE
,      STATUS_TYPE
,      OLD_STATUS_TYPE
,      LAST_UNIT_COMPLETION_DATE
,      OLD_COMPLETION_DATE
,      PROCESSING_WORK_DAYS
,      DAILY_PRODUCTION_RATE
,      LINE_ID
,      PRIMARY_ITEM_ID
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      WIP_SUPPLY_TYPE
,      CLASS_CODE
,      LOT_NUMBER
,      LOT_CONTROL_CODE
,      JOB_NAME
,      DESCRIPTION
,      FIRM_PLANNED_FLAG
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      DEMAND_CLASS
,      START_QUANTITY
,      OLD_START_QUANTITY
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ERROR
,      PARENT_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INTERFACE_ID
,      LAST_UPDATED_BY_NAME
,      CREATED_BY_NAME
,      PROCESS_PHASE
,      PROCESS_STATUS
,      ORGANIZATION_CODE
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      SCHEDULING_METHOD
,      LINE_CODE
,      PRIMARY_ITEM_SEGMENTS
,      BOM_REFERENCE_SEGMENTS
,      ROUTING_REFERENCE_SEGMENTS
,      ROUTING_REVISION
,      BOM_REVISION
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      COMPLETION_LOCATOR_SEGMENTS
,      SCHEDULE_GROUP_ID
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NAME
,      NET_QUANTITY
,      DESCRIPTIVE_FLEX_SEGMENTS
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PROJECT_COSTED
,      END_ITEM_UNIT_NUMBER
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      KANBAN_CARD_ID
,      PRIORITY
,      DUE_DATE
,      ALLOW_EXPLOSION
,      HEADER_ID
,      DELIVERY_ID
,      ERROR_CODE
,      ERROR_MSG
,      COPRODUCTS_SUPPLY
,      XML_DOCUMENT_ID
,      JOB_TYPE
,      DATE_RELEASED
,      TRANSACTION_DATE
,      NUM_OF_CHILDREN
FROM WSM.WSM_LOT_JOB_INTERFACE#;

Dependencies

[top of page]

WSM.WSM_LOT_JOB_INTERFACE# references the following:

SchemaWSM
TableWSM_LOT_JOB_INTERFACE
WSM.WSM_LOT_JOB_INTERFACE# is referenced by following:

SchemaAPPS
SynonymWSM_LOT_JOB_INTERFACE