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

ACS3 Data Model
Description Columns Query Constraints Triggers

IM_PARTNER_STATUS

Columns

NameTypeNullableInsertableUpdatableDeletableComment
PARTNER_STATUS_IDNUMBER(38)NYESYESYES 
PARTNER_STATUSVARCHAR2(50.0)NYESYESYES 

Query:

select category_id as partner_status_id, category as partner_status
from categories
where category_type = 'Intranet Partner Status'

Generated by OraSchemaDoc, (c) Aram Kananov, 2002