[Home] [Help] [Dependency Information]
Object Name: | WSH_UPGRADE_PLD_TMP# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKING_LINE_DETAIL_ID | NUMBER | Yes | ||
HEADER_ID | NUMBER | Yes | ||
LINE_ID | NUMBER | Yes | ||
LINE_DETAIL_ID | NUMBER | Yes | ||
PICKING_LINE_ID | NUMBER | Yes | ||
ORDER_NUMBER | NUMBER | Yes | ||
ORDER_TYPE_ID | NUMBER | Yes | ||
NAME | VARCHAR2 | (30) | Yes | |
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | ||
CUSTOMER_ID | NUMBER | |||
ORDERED_BY_CONTACT_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
SHIP_SET_NUMBER | NUMBER | |||
PARENT_LINE_ID | NUMBER | |||
ATO_LINE_ID | NUMBER | |||
SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | ||
WAREHOUSE_ID | NUMBER | |||
SHIP_TO_SITE_USE_ID | NUMBER | |||
SHIP_TO_CONTACT_ID | NUMBER | |||
INTERMEDIATE_SHIP_TO_ID | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
UNIT_CODE | VARCHAR2 | (3) | ||
SUBINVENTORY | VARCHAR2 | (10) | ||
REVISION | VARCHAR2 | (3) | ||
LOT_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_REQUESTED_LOT_FLAG | VARCHAR2 | (1) | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
INVENTORY_LOCATION_ID | NUMBER | |||
DATE_REQUESTED_CURRENT | DATE | |||
SCHEDULE_DATE | DATE | |||
MASTER_CONTAINER_ITEM_ID | NUMBER | |||
DETAIL_CONTAINER_ITEM_ID | NUMBER | |||
LOAD_SEQ_NUMBER | NUMBER | |||
SHIP_METHOD_CODE | VARCHAR2 | (30) | ||
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | ||
FOB_CODE | VARCHAR2 | (30) | ||
CUSTOMER_ITEM_ID | NUMBER | |||
DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | ||
PLANNING_PROD_SEQ_NUMBER | VARCHAR2 | (50) | ||
CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | ||
MVT_STAT_STATUS | VARCHAR2 | (30) | ||
DELIVERY | NUMBER | |||
CONTEXT | 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) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
DELIVERY_ID | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
LIST_PRICE | NUMBER | |||
ORG_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PICKING_LINE_DETAIL_ID
, HEADER_ID
, LINE_ID
, LINE_DETAIL_ID
, PICKING_LINE_ID
, ORDER_NUMBER
, ORDER_TYPE_ID
, NAME
, PURCHASE_ORDER_NUM
, CUSTOMER_ID
, ORDERED_BY_CONTACT_ID
, INVENTORY_ITEM_ID
, SHIP_SET_NUMBER
, PARENT_LINE_ID
, ATO_LINE_ID
, SHIP_MODEL_COMPLETE_FLAG
, WAREHOUSE_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, INTERMEDIATE_SHIP_TO_ID
, SHIPPED_QUANTITY
, UNIT_CODE
, SUBINVENTORY
, REVISION
, LOT_NUMBER
, CUSTOMER_REQUESTED_LOT_FLAG
, SERIAL_NUMBER
, INVENTORY_LOCATION_ID
, DATE_REQUESTED_CURRENT
, SCHEDULE_DATE
, MASTER_CONTAINER_ITEM_ID
, DETAIL_CONTAINER_ITEM_ID
, LOAD_SEQ_NUMBER
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, SHIPMENT_PRIORITY_CODE
, FOB_CODE
, CUSTOMER_ITEM_ID
, DEP_PLAN_REQUIRED_FLAG
, PLANNING_PROD_SEQ_NUMBER
, CUSTOMER_DOCK_CODE
, MVT_STAT_STATUS
, DELIVERY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DELIVERY_ID
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CURRENCY_CODE
, LIST_PRICE
, ORG_ID
, PROJECT_ID
, TASK_ID
FROM WSH.WSH_UPGRADE_PLD_TMP#;
|
|
|