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.OKX_CUST_PROD_STATUSES_V

Object Details

Object Name:	OKX_CUST_PROD_STATUSES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_CUST_PROD_STATUSES_V
Subobject Name:
Status:	VALID

View Type

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

Displays all possible statuses that can be assigned to products in the installed base.
Pre-defined statuses have SEEDED_FLAG set to Y.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTOMER_PRODUCT_STATUS_ID	NUMBER		Yes	Status identifier
NAME	VARCHAR2	(50)	Yes	Status name
CANCELLED_FLAG	VARCHAR2	(0)		Products having this status are deemed cancelled if this flag is set
TERMINATED_FLAG	VARCHAR2	(1)		Products having this status are deemed terminated if this flag is set
STATUS_CHANGE_ALLOWED_FLAG	VARCHAR2	(1)		The status of products having this status cannot be changed if this flag is set
INCIDENT_ALLOWED_FLAG	VARCHAR2	(1)		Indicates whether service requests can be logged for products having this status
SERVICE_ORDER_ALLOWED_FLAG	VARCHAR2	(1)		Indicates whether products having this status can have new service ordered or recorded against them
SEEDED_FLAG	VARCHAR2	(1)		Flag indicating pre-defined status
SEEDED_STATUS_UPDATEABLE_FLAG	VARCHAR2	(1)		Not currently used
UPDATEABLE_FLAG	VARCHAR2	(1)		Flag indicating whether status is updatable
DESCRIPTION	VARCHAR2	(240)		Status description
START_DATE_ACTIVE	DATE			Effectivity start date
END_DATE_ACTIVE	DATE			Effectivity end date
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column

Query Text

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


SELECT CUSTOMER_PRODUCT_STATUS_ID
,      NAME
,      CANCELLED_FLAG
,      TERMINATED_FLAG
,      STATUS_CHANGE_ALLOWED_FLAG
,      INCIDENT_ALLOWED_FLAG
,      SERVICE_ORDER_ALLOWED_FLAG
,      SEEDED_FLAG
,      SEEDED_STATUS_UPDATEABLE_FLAG
,      UPDATEABLE_FLAG
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OBJECT_VERSION_NUMBER
,      CONTEXT
FROM APPS.OKX_CUST_PROD_STATUSES_V;

Dependencies

[top of page]

APPS.OKX_CUST_PROD_STATUSES_V references the following:

APPS: CS_CUSTOMER_PRODUCT_STATUSES

APPS.OKX_CUST_PROD_STATUSES_V is not referenced by any database object