[Home] [Help] [Dependency Information]
Object Name: | CSP_PARTS_REQUIREMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_REQUEST | VARCHAR2 | (80) | Service request number | |
TASK | VARCHAR2 | (30) | Task number | |
TASK_TYPE | VARCHAR2 | (30) | Task type | |
TASK_STATUS | VARCHAR2 | (30) | Task status | |
TASK_OWNER | VARCHAR2 | (4000) | Task owner | |
RESOURCE_NAME | VARCHAR2 | (4000) | Resource name | |
ORDER_NUMBER | VARCHAR2 | (40) | Order number | |
ORDER_STATUS | VARCHAR2 | (4000) | Order status | |
SOURCE_ORGANIZATION | NUMBER | Source organization identifier | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source subinventory name | |
PART_REQUIREMENT_NUMBER | NUMBER | (35) | Part requirement number | |
DESTINATION_ORGANIZATION | NUMBER | Destination organization identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (30) | Destination subinventory name | |
NEED_BY_DATE | DATE | Need by date | ||
ITEM | VARCHAR2 | (40) | Item number | |
ITEM_ID | NUMBER | Inventory item identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
ARRIVAL_DATE_TIME | DATE | Expected arrival date and time | ||
WAYBILL | VARCHAR2 | (0) | Waybill number | |
SHIPMENT_NUMBER | VARCHAR2 | (0) | Shipment number |
Cut, paste (and edit) the following text to query this object:
SELECT SERVICE_REQUEST
, TASK
, TASK_TYPE
, TASK_STATUS
, TASK_OWNER
, RESOURCE_NAME
, ORDER_NUMBER
, ORDER_STATUS
, SOURCE_ORGANIZATION
, SOURCE_SUBINVENTORY
, PART_REQUIREMENT_NUMBER
, DESTINATION_ORGANIZATION
, DESTINATION_SUBINVENTORY
, NEED_BY_DATE
, ITEM
, ITEM_ID
, ITEM_DESCRIPTION
, ARRIVAL_DATE_TIME
, WAYBILL
, SHIPMENT_NUMBER
FROM APPS.CSP_PARTS_REQUIREMENTS_V;
APPS.CSP_PARTS_REQUIREMENTS_V is not referenced by any database object
|
|
|