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

TABLE: WMS.WMS_DOCK_APPOINTMENTS_B

Object Details
Object Name: WMS_DOCK_APPOINTMENTS_B
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_DOCK_APPOINTMENTS_B
Subobject Name:
Status: VALID


Base table for WMS dock assignment form. It stores dock door (locator) ID, trip stop ID for outbound appointment, start time, end time, and repetitive information for appointments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_DOCK_APPOINTMENTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCK_APPOINTMENT_ID
WMS_DOCK_APPOINTMENTS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCK_ID
ColumnORGANIZATION_ID
WMS_DOCK_APPOINTMENTS_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRIP_STOP
Columns
Name Datatype Length Mandatory Comments
DOCK_APPOINTMENT_ID NUMBER
Yes Dock appointment identifier
APPOINTMENT_TYPE NUMBER
Yes Dock appointment type: 1 Inound, 2 Outbound, 3 Other
DOCK_ID NUMBER

Dock identifier, locator ID
ORGANIZATION_ID NUMBER

Organization ID
START_TIME DATE

Start time of the appointment
END_TIME DATE

End time of the appointment
CARRIER NUMBER

Obsolete
SOURCE_TYPE NUMBER

For future use
SOURCE_HEADER_ID NUMBER

For future use
SOURCE_LINE_ID NUMBER

For future use
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
STAGING_LANE_ID NUMBER

Staging lane identifier, locator ID
TRIP_STOP NUMBER

Trip stop ID
REP_START_DATE DATE

Repeating appointment starting date
REP_END_DATE DATE

Repeating appointment end date
REP_ORIGIN NUMBER

ID of original appointment for repeating appointments
REP_FREQUENCY NUMBER

Repeating frequency: 1 Don't repeat, 2 Everyday, 3 Every weekday, 4 Every week, 5 Every month same date, 6 Every month same day
APPOINTMENT_STATUS NUMBER

Dock appointment status: 1 Reserved, 2 Occupied
CARRIER_CODE VARCHAR2 (25)
Freight Carrier Code
Query Text

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


SELECT DOCK_APPOINTMENT_ID
,      APPOINTMENT_TYPE
,      DOCK_ID
,      ORGANIZATION_ID
,      START_TIME
,      END_TIME
,      CARRIER
,      SOURCE_TYPE
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STAGING_LANE_ID
,      TRIP_STOP
,      REP_START_DATE
,      REP_END_DATE
,      REP_ORIGIN
,      REP_FREQUENCY
,      APPOINTMENT_STATUS
,      CARRIER_CODE
FROM WMS.WMS_DOCK_APPOINTMENTS_B;

Dependencies

[top of page]

WMS.WMS_DOCK_APPOINTMENTS_B does not reference any database object

WMS.WMS_DOCK_APPOINTMENTS_B is referenced by following:

SchemaWMS
ViewWMS_DOCK_APPOINTMENTS_B#