[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | OE |
| FND Design Data: |  OE.WSH_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
WSH_PARAMETERS handles the shipping parameters used in
Oracle Order Entry / Shipping.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| REQUEST_ID | NUMBER | (15) | Standard Who column | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| PLANNING_METHOD_FLAG | VARCHAR2 | (1) | Yes | S=Shippable components input; T=Top configuration item of a BOM |
| WEIGHT_UOM_CLASS | VARCHAR2 | (10) | Yes | UOM class for weight validation |
| VOLUME_UOM_CLASS | VARCHAR2 | (10) | Yes | UOM class used for volume validation |
| INVOICE_DELIVERY_COMPLETE_FLAG | VARCHAR2 | (1) | Yes | For future use |
| WEIGHT_VOLUME_DPW_FLAG | VARCHAR2 | (1) | Yes | When to calculate weight/volume in DPW: M=Manually, A=Automatic |
| WEIGHT_VOLUME_SC_FLAG | VARCHAR2 | (1) | Yes | When to calculate weight/volume in SC: M=Manually, A=Automatic |
| INV_CONTROLS_CONTAINER_FLAG | VARCHAR2 | (1) | Yes | Indicates if containers are under inventory control |
| PERCENT_FILL_BASIS_FLAG | VARCHAR2 | (1) | Yes | Determines how to calculate departure fill: either Q(quantity), V(volume), or W(weight) |
| DEPARTURE_REPORT_SET_ID | NUMBER | Default report set printed when a departure is closed | ||
| DELIVERY_REPORT_SET_ID | NUMBER | Default report set printed when a delivery is closed | ||
| RELEASE_SEQ_RULE_ID | NUMBER | Yes | System-generated ID | |
| PICK_SLIP_RULE_ID | NUMBER | Yes | System-generated ID | |
| PICK_RELEASE_REPORT_SET_ID | NUMBER | Default document set that will be printed when Pick Release completes | ||
| ENFORCE_PACKING_FLAG | VARCHAR2 | (1) | Checks that all lines are packed at ship confirm time | |
| PRINT_PICK_SLIP_MODE | VARCHAR2 | (1) | Yes | Indicates when slips get printed during pick release: I=Immediate, E=End |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| AUTOCREATE_DEL_ORDERS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ORGANIZATION_ID
, PLANNING_METHOD_FLAG
, WEIGHT_UOM_CLASS
, VOLUME_UOM_CLASS
, INVOICE_DELIVERY_COMPLETE_FLAG
, WEIGHT_VOLUME_DPW_FLAG
, WEIGHT_VOLUME_SC_FLAG
, INV_CONTROLS_CONTAINER_FLAG
, PERCENT_FILL_BASIS_FLAG
, DEPARTURE_REPORT_SET_ID
, DELIVERY_REPORT_SET_ID
, RELEASE_SEQ_RULE_ID
, PICK_SLIP_RULE_ID
, PICK_RELEASE_REPORT_SET_ID
, ENFORCE_PACKING_FLAG
, PRINT_PICK_SLIP_MODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, AUTOCREATE_DEL_ORDERS_FLAG
FROM OE.WSH_PARAMETERS;
OE.WSH_PARAMETERS does not reference any database object
OE.WSH_PARAMETERS is referenced by following:
OE
WSH_PARAMETERS#
|
|
|
|