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

TABLE: WSH.WSH_SHIP_CONFIRM_RULES

Object Details
Object Name: WSH_SHIP_CONFIRM_RULES
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_SHIP_CONFIRM_RULES
Subobject Name:
Status: VALID


WSH_SHIP_CONFIRM_RULES has records of ship confirm options for Automated Ship Confirm batches.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_SHIP_CONFIRM_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNAME
Columns
Name Datatype Length Mandatory Comments
SHIP_CONFIRM_RULE_ID NUMBER
Yes Primary Key
EFFECTIVE_START_DATE DATE
Yes Effective start date
NAME VARCHAR2 (30)
Name
EFFECTIVE_END_DATE DATE

Effective end date
ACTION_FLAG VARCHAR2 (1)
Action flag for ship confirm: S, B, A, O, L, C, T
STAGE_DEL_FLAG VARCHAR2 (1)
Create Delivery for staged quantity (Y=Yes,N=No)
SHIP_METHOD_CODE VARCHAR2 (30)
Ship method
AC_ACTUAL_DEP_DATE_DEFAULT VARCHAR2 (30)
Option to default actual departure date
AC_INTRANSIT_FLAG VARCHAR2 (1)
Autocreated Trip option: set delivery in transit
AC_CLOSE_TRIP_FLAG VARCHAR2 (1)
Autocreated Trip option: close trip
AC_BOL_FLAG VARCHAR2 (1)
Autocreated Trip option: generate BOL
AC_DEFER_INTERFACE_FLAG VARCHAR2 (1)
Autocreated Trip option: defer interface
MC_INTRANSIT_FLAG VARCHAR2 (1)
Pre-existing trip option: set delivery in transit
MC_CLOSE_TRIP_FLAG VARCHAR2 (1)
Pre-existing trip option: close trip
MC_DEFER_INTERFACE_FLAG VARCHAR2 (1)
Pre-existing trip option: defer interface
REPORT_SET_ID NUMBER

report set
SEND_945_FLAG VARCHAR2 (1)
send outbound message
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
MC_BOL_FLAG VARCHAR2 (1)
Pre-existing trip option: Generate BOL flag
SHIP_METHOD_DEFAULT_FLAG VARCHAR2 (1)
Default Ship Method from (Valid values null/'R':default from Rule's Ship method, 'D': default from Trip/Delivery)
Query Text

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


SELECT SHIP_CONFIRM_RULE_ID
,      EFFECTIVE_START_DATE
,      NAME
,      EFFECTIVE_END_DATE
,      ACTION_FLAG
,      STAGE_DEL_FLAG
,      SHIP_METHOD_CODE
,      AC_ACTUAL_DEP_DATE_DEFAULT
,      AC_INTRANSIT_FLAG
,      AC_CLOSE_TRIP_FLAG
,      AC_BOL_FLAG
,      AC_DEFER_INTERFACE_FLAG
,      MC_INTRANSIT_FLAG
,      MC_CLOSE_TRIP_FLAG
,      MC_DEFER_INTERFACE_FLAG
,      REPORT_SET_ID
,      SEND_945_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      MC_BOL_FLAG
,      SHIP_METHOD_DEFAULT_FLAG
FROM WSH.WSH_SHIP_CONFIRM_RULES;

Dependencies

[top of page]

WSH.WSH_SHIP_CONFIRM_RULES does not reference any database object

WSH.WSH_SHIP_CONFIRM_RULES is referenced by following:

SchemaWSH
ViewWSH_SHIP_CONFIRM_RULES#