[Home] [Help] [Dependency Information]
Object Name: | QA_ERES_WSH_DELIVERABLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_ERES_WSH_DELIVERABLES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERY_ID | NUMBER | delivery ID | ||
DELIVERY_DETAIL_ID | NUMBER | Yes | delivery detail ID | |
DELIVERY_LINE_ID | NUMBER | delivery line ID | ||
DELIVERY_LINE_NAME | VARCHAR2 | (40) | delivery line | |
DELIVERY_LINE_STATUS | VARCHAR2 | (4000) | delivery line status | |
ORGANIZATION_ID | NUMBER | org ID | ||
ITEM_ID | NUMBER | item ID | ||
ITEM | VARCHAR2 | (40) | item | |
ITEM_DESCRIPTION | VARCHAR2 | (250) | item description | |
ITEM_REVISION | VARCHAR2 | (3) | item rev | |
TRACKING_NUMBER | VARCHAR2 | (30) | tracking number | |
REQUESTED_QTY | NUMBER | Yes | requested qty | |
PICKED_QTY | NUMBER | picked qty | ||
SHIPPED_QTY | NUMBER | shipped qty | ||
UOM | VARCHAR2 | (3) | Yes | uom |
SECOND_REQUESTED_QTY | NUMBER | second requested qty | ||
SECOND_SHIPPED_QTY | NUMBER | second shipped qty | ||
SECOND_UOM | VARCHAR2 | (3) | second uom | |
WEIGHT_MAX | NUMBER | max weight | ||
WEIGHT_GROSS | NUMBER | gross weight | ||
WEIGHT_TARE | NUMBER | tare weight | ||
WEIGHT_NET | NUMBER | net weight | ||
WEIGHT_UOM | VARCHAR2 | (3) | weight uom | |
VOLUME_MAX | NUMBER | max volume | ||
VOLUME | NUMBER | volume | ||
VOLUME_UOM | VARCHAR2 | (3) | volume uom | |
PARENT_LPN | VARCHAR2 | (4000) | parent license plate num | |
MASTER_LPN | VARCHAR2 | (4000) | master license plate num | |
MASTER_SERIAL | VARCHAR2 | (30) | master serial num | |
SHIPPING_INST | VARCHAR2 | (2000) | shipping instructions | |
PACKING_INST | VARCHAR2 | (2000) | packing instructions | |
INV_ORG_CODE | VARCHAR2 | (3) | inventory org code | |
ORG_NAME | VARCHAR2 | (240) | org name | |
SUBINVENTORY | VARCHAR2 | (10) | subinventory | |
LOCATOR | VARCHAR2 | (4000) | locator | |
LOT | VARCHAR2 | (80) | lot num | |
CUSTOMER_REQUESTED_LOT_FLAG | VARCHAR2 | (1) | customer requested lot flag | |
SUBLOT | VARCHAR2 | (0) | sublot | |
SERIAL_NUMBER_FROM | VARCHAR2 | (30) | serial num range | |
SERIAL_NUMBER_TO | VARCHAR2 | (30) | serial num range | |
GRADE | VARCHAR2 | (150) | grade | |
INSPECTION_STATUS | VARCHAR2 | (80) | inspection status | |
SEAL_CODE | VARCHAR2 | (30) | seal code | |
SOURCE_SYSTEM | VARCHAR2 | (80) | Yes | source system |
ORDER_NUMBER | VARCHAR2 | (150) | order num | |
ORDER_TYPE | VARCHAR2 | (240) | order type | |
ORDER_LINE | VARCHAR2 | (150) | order line num | |
SOURCE_REQ_QTY | NUMBER | source requested qty | ||
SOURCE_REQ_QTY_UOM | VARCHAR2 | (3) | uom for above | |
SOURCE_SEC_QTY | NUMBER | source requested secondary qty | ||
SOURCE_SEC_QTY_UOM | VARCHAR2 | (3) | uom for above | |
PROJECT_NUMBER | VARCHAR2 | (30) | project | |
TASK_NUMBER | VARCHAR2 | (25) | task | |
UNIT_NUMBER | VARCHAR2 | (30) | unit | |
SOURCE_REQ_DATE | DATE | source requested date | ||
SOURCE_SCHED_DATE | DATE | source scheduled date | ||
CUSTOMER_PART_NUMBER | VARCHAR2 | (50) | customer item num | |
CUSTOMER_PART_DESC | VARCHAR2 | (240) | customer item description | |
CUSTOMER_PROD_SEQ | VARCHAR2 | (50) | customer product seq | |
CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | customer dock code | |
ATTRIBUTE1 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | standard flexfield | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | standard flexfield | |
LAST_UPDATE_DATE | DATE | Yes | standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | standard WHO column | ||
CREATION_DATE | DATE | Yes | standard WHO column | |
CREATED_BY | NUMBER | Yes | standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERY_ID
, DELIVERY_DETAIL_ID
, DELIVERY_LINE_ID
, DELIVERY_LINE_NAME
, DELIVERY_LINE_STATUS
, ORGANIZATION_ID
, ITEM_ID
, ITEM
, ITEM_DESCRIPTION
, ITEM_REVISION
, TRACKING_NUMBER
, REQUESTED_QTY
, PICKED_QTY
, SHIPPED_QTY
, UOM
, SECOND_REQUESTED_QTY
, SECOND_SHIPPED_QTY
, SECOND_UOM
, WEIGHT_MAX
, WEIGHT_GROSS
, WEIGHT_TARE
, WEIGHT_NET
, WEIGHT_UOM
, VOLUME_MAX
, VOLUME
, VOLUME_UOM
, PARENT_LPN
, MASTER_LPN
, MASTER_SERIAL
, SHIPPING_INST
, PACKING_INST
, INV_ORG_CODE
, ORG_NAME
, SUBINVENTORY
, LOCATOR
, LOT
, CUSTOMER_REQUESTED_LOT_FLAG
, SUBLOT
, SERIAL_NUMBER_FROM
, SERIAL_NUMBER_TO
, GRADE
, INSPECTION_STATUS
, SEAL_CODE
, SOURCE_SYSTEM
, ORDER_NUMBER
, ORDER_TYPE
, ORDER_LINE
, SOURCE_REQ_QTY
, SOURCE_REQ_QTY_UOM
, SOURCE_SEC_QTY
, SOURCE_SEC_QTY_UOM
, PROJECT_NUMBER
, TASK_NUMBER
, UNIT_NUMBER
, SOURCE_REQ_DATE
, SOURCE_SCHED_DATE
, CUSTOMER_PART_NUMBER
, CUSTOMER_PART_DESC
, CUSTOMER_PROD_SEQ
, CUSTOMER_DOCK_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM APPS.QA_ERES_WSH_DELIVERABLES_V;
APPS.QA_ERES_WSH_DELIVERABLES_V is not referenced by any database object
|
|
|