[Home] [Help] [Dependency Information]
Object Name: | WSH_PICKING_UPGRADE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_PICKING_UPGRADE_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKING_LINE_ID | NUMBER | Yes | ||
PICKING_HEADER_ID | NUMBER | Yes | ||
ORDER_LINE_ID | NUMBER | Yes | ||
LINE_DETAIL_ID | NUMBER | Yes | ||
SCHEDULE_DATE | DATE | |||
REQUESTED_QUANTITY | NUMBER | |||
INVOICED_QUANTITY | NUMBER | |||
WAREHOUSE_ID | NUMBER | Yes | ||
CUSTOMER_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
COMPONENT_SEQUENCE_ID | NUMBER | |||
COMPONENT_CODE | VARCHAR2 | (1000) | Yes | |
SHIP_METHOD_CODE | VARCHAR2 | (30) | ||
LATEST_ACCEPTABLE_DATE | DATE | |||
DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | ||
SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | ||
CONFIGURATION_ITEM_FLAG | VARCHAR2 | (1) | ||
INCLUDED_ITEM_FLAG | VARCHAR2 | (1) | ||
SHIPPED_QUANTITY | NUMBER | |||
ACTUAL_DEPARTURE_DATE | DATE | |||
DELIVERY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PICKING_LINE_ID
, PICKING_HEADER_ID
, ORDER_LINE_ID
, LINE_DETAIL_ID
, SCHEDULE_DATE
, REQUESTED_QUANTITY
, INVOICED_QUANTITY
, WAREHOUSE_ID
, CUSTOMER_ITEM_ID
, INVENTORY_ITEM_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, SHIP_METHOD_CODE
, LATEST_ACCEPTABLE_DATE
, DEP_PLAN_REQUIRED_FLAG
, SCHEDULE_STATUS_CODE
, CONFIGURATION_ITEM_FLAG
, INCLUDED_ITEM_FLAG
, SHIPPED_QUANTITY
, ACTUAL_DEPARTURE_DATE
, DELIVERY
FROM APPS.WSH_PICKING_UPGRADE_V;
APPS.WSH_PICKING_UPGRADE_V is not referenced by any database object
|
|
|