[Home] [Help] [Dependency Information]
Object Name: | CSP_MOVEORDERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSP.CSP_MOVEORDERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The view gives the status of a moveorder.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Move order header identifier | ||
REQUEST_NUMBER | VARCHAR2 | (30) | Move order request number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name | |
DATE_REQUIRED | DATE | Date required | ||
LINE_ID | NUMBER | Move order line identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | Name of source subinventory | |
FROM_LOCATOR_ID | NUMBER | Source locator identifier | ||
TO_SUBINVENTORY_CODE | VARCHAR2 | (10) | Name of destination subinventory | |
TO_LOCATOR_ID | NUMBER | Destination locator identifier | ||
REVISION | VARCHAR2 | (3) | Item revision | |
QUANTITY | NUMBER | Quantity ordered | ||
LINE_STATUS_ID | VARCHAR2 | (40) | Line status identifier | |
LINE_STATUS | VARCHAR2 | (80) | Line status | |
STATUS_DATE | DATE | Line status date | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item number | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
DATE_ORDERED | DATE | Date ordered | ||
INCIDENT_ID | NUMBER | Service request identifier | ||
TASK_ID | NUMBER | Task identifier | ||
WAYBILL | VARCHAR2 | (60) | Waybill number | |
CARRIER | VARCHAR2 | (60) | Name of carrier | |
SHIPMENT_METHOD | VARCHAR2 | (60) | Shipment method | |
PICKLIST_HEADER_ID | NUMBER | Picklist header identifier | ||
PICKLIST_NUMBER | VARCHAR2 | (30) | Picklist number | |
DATE_PICKED | DATE | Date picked | ||
QUANTITY_PICKED | NUMBER | Quantity picked | ||
PACKLIST_HEADER_ID | NUMBER | Packlist header identifier | ||
PACKLIST_NUMBER | VARCHAR2 | (10) | Packlist number | |
DATE_PACKED | DATE | Date packed | ||
DATE_SHIPPED | DATE | Date shipped | ||
DATE_RECEIVED | DATE | Date received | ||
QUANTITY_PACKED | NUMBER | Quantity packed | ||
QUANTITY_SHIPPED | NUMBER | Quantity shipped | ||
QUANTITY_RECEIVED | NUMBER | Quantity received |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, REQUEST_NUMBER
, ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, DATE_REQUIRED
, LINE_ID
, INVENTORY_ITEM_ID
, FROM_SUBINVENTORY_CODE
, FROM_LOCATOR_ID
, TO_SUBINVENTORY_CODE
, TO_LOCATOR_ID
, REVISION
, QUANTITY
, LINE_STATUS_ID
, LINE_STATUS
, STATUS_DATE
, CONCATENATED_SEGMENTS
, DESCRIPTION
, DATE_ORDERED
, INCIDENT_ID
, TASK_ID
, WAYBILL
, CARRIER
, SHIPMENT_METHOD
, PICKLIST_HEADER_ID
, PICKLIST_NUMBER
, DATE_PICKED
, QUANTITY_PICKED
, PACKLIST_HEADER_ID
, PACKLIST_NUMBER
, DATE_PACKED
, DATE_SHIPPED
, DATE_RECEIVED
, QUANTITY_PACKED
, QUANTITY_SHIPPED
, QUANTITY_RECEIVED
FROM APPS.CSP_MOVEORDERS_V;
APPS.CSP_MOVEORDERS_V is not referenced by any database object
|
|
|