Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

IM_CUSTOMER_STATUS

Columns

NameTypeNullableInsertableUpdatableDeletableComment
CUSTOMER_STATUS_IDNUMBER(38)NYESYESYES 
CUSTOMER_STATUSVARCHAR2(50.0)NYESYESYES 

Query:

select category_id as customer_status_id, category as customer_status
from categories
where category_type = 'Intranet Customer Status'


Generated by OraSchemaDoc, (c) Aram Kananov, 2002