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

VIEW: APPS.WSH_PICKING_UPGRADE_V

Object Details
Object Name: WSH_PICKING_UPGRADE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_PICKING_UPGRADE_V
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.WSH_PICKING_UPGRADE_V references the following:

SchemaAPPS
SynonymSO_PICKING_LINES_ALL
SynonymSO_PICKING_LINE_DETAILS
SynonymWSH_DEPARTURES

APPS.WSH_PICKING_UPGRADE_V is not referenced by any database object