FND Design Data [Home] [Help]

View: OKX_CUST_PROD_STATUSES_V

Product: OKX - Contracts Integration
Description: Statuses that can be assigned to products in the installed base
Implementation/DBA Data: ViewAPPS.OKX_CUST_PROD_STATUSES_V
View Text

SELECT CPS.CUSTOMER_PRODUCT_STATUS_ID CUSTOMER_PRODUCT_STATUS_ID
, CPS.NAME NAME
, CPS.CANCELLED_FLAG CANCELLED_FLAG
, CPS.TERMINATED_FLAG TERMINATED_FLAG
, CPS.STATUS_CHANGE_ALLOWED_FLAG STATUS_CHANGE_ALLOWED_FLAG
, CPS.INCIDENT_ALLOWED_FLAG INCIDENT_ALLOWED_FLAG
, CPS.SERVICE_ORDER_ALLOWED_FLAG SERVICE_ORDER_ALLOWED_FLAG
, CPS.SEEDED_FLAG SEEDED_FLAG
, CPS.SEEDED_STATUS_UPDATEABLE_FLAG SEEDED_STATUS_UPDATEABLE_FLAG
, CPS.UPDATEABLE_FLAG UPDATEABLE_FLAG
, CPS.DESCRIPTION DESCRIPTION
, CPS.START_DATE_ACTIVE START_DATE_ACTIVE
, CPS.END_DATE_ACTIVE END_DATE_ACTIVE
, CPS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CPS.CONTEXT CONTEXT
FROM CS_CUSTOMER_PRODUCT_STATUSES CPS

Columns

Name
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