Product: | OKX - Contracts Integration |
---|---|
Description: | Statuses that can be assigned to products in the installed base |
Implementation/DBA Data: | APPS.OKX_CUST_PROD_STATUSES_V |
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