[Home] [Help] [Dependency Information]
Object Name: | CSD_CP_REFERENCE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSD.CSD_CP_REFERENCE_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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 |
---|---|---|---|---|
REFERENCE_NUMBER | VARCHAR2 | (30) | Yes | Customer product reference number |
CUSTOMER_PRODUCT_ID | NUMBER | Yes | Customer product identifier | |
CUSTOMER_ID | NUMBER | Customer identifier | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ITEM | VARCHAR2 | (40) | Inventory item name | |
ITEM_DESC | VARCHAR2 | (240) | Inventory item description | |
CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Customer product serial number | |
UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Yes | Unit of Measure for the quantity field |
UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | Yes | Unit of Measure translation |
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
REVISION | VARCHAR2 | (3) | Revision | |
QUANTITY | NUMBER | Yes | Quantity | |
ORG_ID | NUMBER | Organization identifier | ||
INCIDENT_ALLOWED_FLAG | VARCHAR2 | (1) | Indicates whether service requests can be logged for the product | |
STATUS | VARCHAR2 | (50) | Customer product status |
Cut, paste (and edit) the following text to query this object:
SELECT REFERENCE_NUMBER
, CUSTOMER_PRODUCT_ID
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, ITEM
, ITEM_DESC
, CURRENT_SERIAL_NUMBER
, UNIT_OF_MEASURE_CODE
, UNIT_OF_MEASURE_TL
, LOT_NUMBER
, REVISION
, QUANTITY
, ORG_ID
, INCIDENT_ALLOWED_FLAG
, STATUS
FROM APPS.CSD_CP_REFERENCE_V;
APPS.CSD_CP_REFERENCE_V is not referenced by any database object
|
|
|