VIEW: APPS.CSI_CUSTOMER_PRODUCT_STATUS_V

Source

View Text - Preformatted

SELECT CIS.INSTANCE_STATUS_ID , CIS.LAST_UPDATE_DATE , CIS.LAST_UPDATED_BY , CIS.CREATION_DATE , CIS.CREATED_BY , CIS.LAST_UPDATE_LOGIN , CIS.NAME , NULL CANCELLED_FLAG , CIS.TERMINATED_FLAG , CIS.STATUS_CHANGE_ALLOWED_FLAG , CIS.INCIDENT_ALLOWED_FLAG , CIS.SERVICE_ORDER_ALLOWED_FLAG , CIS.SEEDED_FLAG , CIS.SEED_STATUS_UPDATEABLE_FLAG , CIS.DESCRIPTION , CIS.START_DATE_ACTIVE , CIS.END_DATE_ACTIVE , CIS.ATTRIBUTE1 , CIS.ATTRIBUTE2 , CIS.ATTRIBUTE3 , CIS.ATTRIBUTE4 , CIS.ATTRIBUTE5 , CIS.ATTRIBUTE6 , CIS.ATTRIBUTE7 , CIS.ATTRIBUTE8 , CIS.ATTRIBUTE9 , CIS.ATTRIBUTE10 , CIS.ATTRIBUTE11 , CIS.ATTRIBUTE12 , CIS.ATTRIBUTE13 , CIS.ATTRIBUTE14 , CIS.ATTRIBUTE15 , CIS.CONTEXT , CIS.UPDATEABLE_FLAG , CIS.OBJECT_VERSION_NUMBER FROM CSI_INSTANCE_STATUSES CIS

View Text - HTML Formatted

SELECT CIS.INSTANCE_STATUS_ID
, CIS.LAST_UPDATE_DATE
, CIS.LAST_UPDATED_BY
, CIS.CREATION_DATE
, CIS.CREATED_BY
, CIS.LAST_UPDATE_LOGIN
, CIS.NAME
, NULL CANCELLED_FLAG
, CIS.TERMINATED_FLAG
, CIS.STATUS_CHANGE_ALLOWED_FLAG
, CIS.INCIDENT_ALLOWED_FLAG
, CIS.SERVICE_ORDER_ALLOWED_FLAG
, CIS.SEEDED_FLAG
, CIS.SEED_STATUS_UPDATEABLE_FLAG
, CIS.DESCRIPTION
, CIS.START_DATE_ACTIVE
, CIS.END_DATE_ACTIVE
, CIS.ATTRIBUTE1
, CIS.ATTRIBUTE2
, CIS.ATTRIBUTE3
, CIS.ATTRIBUTE4
, CIS.ATTRIBUTE5
, CIS.ATTRIBUTE6
, CIS.ATTRIBUTE7
, CIS.ATTRIBUTE8
, CIS.ATTRIBUTE9
, CIS.ATTRIBUTE10
, CIS.ATTRIBUTE11
, CIS.ATTRIBUTE12
, CIS.ATTRIBUTE13
, CIS.ATTRIBUTE14
, CIS.ATTRIBUTE15
, CIS.CONTEXT
, CIS.UPDATEABLE_FLAG
, CIS.OBJECT_VERSION_NUMBER
FROM CSI_INSTANCE_STATUSES CIS