eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSP_MOVEORDERS_V

Object Details

Object Name:	CSP_MOVEORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.CSP_MOVEORDERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The view gives the status of a moveorder.

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.CSP_MOVEORDERS_V references the following:

APPS: CSP_MOVEORDER_HEADERS; CSP_MOVEORDER_LINES; CSP_PACKLIST_HEADERS; CSP_PACKLIST_LINES; CSP_PICKLIST_HEADERS; CSP_PICKLIST_LINES; CSP_SEC_INVENTORIES; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MFG_LOOKUPS; MTL_MATERIAL_TRANSACTIONS_TEMP; MTL_SYSTEM_ITEMS_B_KFV; MTL_SYSTEM_ITEMS_VL; MTL_TXN_REQUEST_HEADERS; MTL_TXN_REQUEST_LINES; ORG_ORGANIZATION_DEFINITIONS

APPS.CSP_MOVEORDERS_V is not referenced by any database object