eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CZ.CZ_POPULATORS

Object Details

Object Name:	CZ_POPULATORS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_POPULATORS
Subobject Name:
Status:	VALID

This table is used to define Populators, which are used to create product structure from item-master and property data.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_POPULATORS_PK	NORMAL	UNIQUE	APPS_TS_SEED	POPULATOR_ID ZD_EDITION_NAME
CZ_POPULATORS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FILTER_SET_ID
CZ_POPULATORS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	OWNED_BY_NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
POPULATOR_ID	NUMBER	(9)	Yes	Provides a numeric identity for this populator
OWNED_BY_NODE_ID	NUMBER	(15)		Identifies the PSNODE under which this Populator is attached; all nodes generated by this populator will be children of that psnode
FILTER_SET_ID	NUMBER	(9)		Identifies the Filter Set associated with this record
RESULT_TYPE	NUMBER	(9)	Yes	Indicates what type of psnode is created by this populator:258 - Component; 261 - Feature; 262 - Option
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM	DATE			UNUSED
EFF_TO	DATE			UNUSED
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
SECURITY_MASK	VARCHAR2	(40)		UNUSED
EFF_MASK	VARCHAR2	(40)		UNUSED
CHECKOUT_USER	VARCHAR2	(40)		UNUSED
PERSISTENT_POPULATOR_ID	NUMBER	(9)	Yes	Persistent ID (preserved in copies) of this populator
DESCRIPTION	VARCHAR2	(2000)		Textual description of this Populator
NAME	VARCHAR2	(255)		Name of the Populator
HAS_LEVEL	VARCHAR2	(1)		'1' indicates the populator output view is multi-level. Note that the result type and the top parent node will limit the deepest level that can be populated.
HAS_DESCRIPTION	VARCHAR2	(1)		'B' indicates the populator output view has description strings in base language only; 'M' indicates descriptions in multiple languages
HAS_PROPERTY	VARCHAR2	(1)		'1' indicates the populator output view has PROPERTY_ID/PROPERTY_NAME fields
HAS_ITEM_TYPE	VARCHAR2	(1)		'1' indicates the populator output view has ITEM_TYPE_ID/ITEM_TYPE_NAME fields
HAS_ITEM	VARCHAR2	(1)		'1' indicates the populator output view has ITEM_ID/REF_PART_NBR fields
VIEW_NAME	VARCHAR2	(40)		Records the name of the database view generated to implement the Populator.
FEATURE_TYPE	NUMBER			For populators whose result type is Feature, specifies the exact type of Feature to be created. If null, pass through any FEATURE_TYPE value from the source/filterset view. Default to 0 (option-list Feature)
QUERY_SYNTAX	VARCHAR2	(3000)		Records query syntax generated into this populator
XFR_GROUP	VARCHAR2	(20)		Specifies the Import/Transfer group whose rules are used for executing this populator
SRC_APPLICATION_ID	NUMBER		Yes	PK. Value for existing records will be 708 (CZ).
SEED_DATA_FLAG	VARCHAR2	(1)
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
LAST_GENERATION_DATE	DATE			Date that the populator SQL was last generated.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LAST_UPDATE_LOGIN
,      POPULATOR_ID
,      OWNED_BY_NODE_ID
,      FILTER_SET_ID
,      RESULT_TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      PERSISTENT_POPULATOR_ID
,      DESCRIPTION
,      NAME
,      HAS_LEVEL
,      HAS_DESCRIPTION
,      HAS_PROPERTY
,      HAS_ITEM_TYPE
,      HAS_ITEM
,      VIEW_NAME
,      FEATURE_TYPE
,      QUERY_SYNTAX
,      XFR_GROUP
,      SRC_APPLICATION_ID
,      SEED_DATA_FLAG
,      SEEDED_FLAG
,      LAST_GENERATION_DATE
,      ZD_EDITION_NAME
FROM CZ.CZ_POPULATORS;

Dependencies

[top of page]

CZ.CZ_POPULATORS does not reference any database object

CZ.CZ_POPULATORS is referenced by following:

CZ: CZ_POPULATORS#