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


VIEW: APPS.CS_CP_REVISIONS_MAINT_V

Object Details
Object Name: CS_CP_REVISIONS_MAINT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_CP_REVISIONS_MAINT_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CP_REVISION_ID NUMBER (15) Yes Revision identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control
CUSTOMER_PRODUCT_ID NUMBER (15) Yes Product identifier
INVENTORY_ITEM_ID NUMBER (15) Yes Inventory item identifier
SERIAL_NUMBER VARCHAR2 (30)
Serial number
REVISION VARCHAR2 (15)
Revision
SHIPPED_FLAG VARCHAR2 (1)
Shipped flag
DELIVERED_FLAG VARCHAR2 (1)
Delivered flag
ORDER_LINE_ID NUMBER (15)
order line identifier
LINE_SERVICE_DETAIL_ID NUMBER (15)
Line service detail identifier
SHIPPED_DATE DATE

Shipped date
LOT_NUMBER VARCHAR2 (30)
Lot number
START_DATE_ACTIVE DATE

Effective from
END_DATE_ACTIVE DATE

Effective to
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
BOM_ITEM_TYPE NUMBER
Yes Bill of material Item type
ORDERED_DATE DATE

Order date
ORDER_NUMBER NUMBER

Order number
LINE_NUMBER NUMBER

Line number
PRODUCT VARCHAR2 (40)
Product name
NET_AMOUNT NUMBER (22)
Amount
CURRENCY_CODE VARCHAR2 (15)
Currency code
REVISION_DESCRIPTION VARCHAR2 (4000)
Description of revision
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CP_REVISION_ID
,      OBJECT_VERSION_NUMBER
,      CUSTOMER_PRODUCT_ID
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      REVISION
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      ORDER_LINE_ID
,      LINE_SERVICE_DETAIL_ID
,      SHIPPED_DATE
,      LOT_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      BOM_ITEM_TYPE
,      ORDERED_DATE
,      ORDER_NUMBER
,      LINE_NUMBER
,      PRODUCT
,      NET_AMOUNT
,      CURRENCY_CODE
,      REVISION_DESCRIPTION
FROM APPS.CS_CP_REVISIONS_MAINT_V;

Dependencies

[top of page]

APPS.CS_CP_REVISIONS_MAINT_V references the following:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CP_REVISIONS
SynonymCS_CUSTOMER_PRODUCTS_ALL
PL/SQL PackageCS_STD - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL

APPS.CS_CP_REVISIONS_MAINT_V is not referenced by any database object