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: BOM.CST_REPORT_TYPES

Object Details

Object Name:	CST_REPORT_TYPES
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_REPORT_TYPES
Subobject Name:
Status:	VALID

CST_REPORT_TYPES stores detail options and all relevant Item Cost
Reports information by cost type. A detail option
specifies how to summarize item costs and which template
to use to display the item costs.
.
REPORT_NAME stores the report name option, for example, 'Element by
Level.' UNIQUE_ID is the unique identifier for REPORT_NAME and is
obtained from sequence CST_REPORT_TYPES_S. USER_DEFINED indicates
whether this is a user-defined option or predefined option. For
customized options, enter 1 for the USER_DEFINED field.
.
There are two different report layouts. COLUMN1_HEADING and
COLUMN2_HEADING stores the first and second column headings for both
layouts.
.
COLUMN1_HEADING and COLUMN2_HEADING hold the source of the cost
information for the report option. For example, for the Element by
Sub-Element report COLUMN1_HEADING uses COST_ELEMENT and
COLUMN2_HEADING uses RESOURCE.
.
FLEXFIELD_APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME store the
application identifier and descriptive flexfield name for reports that
require flexfield segment values and are used to retrieve segments
for the flexfield.
.
INVENTORY_FLAG specifies whether this report is available for a
standalone inventory installation. Some of the detail options are not
available for standalone inventory installations, such as Element by
operation.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_REPORT_TYPES_U1	NORMAL	UNIQUE	APPS_TS_SEED	UNIQUE_ID ZD_EDITION_NAME
CST_REPORT_TYPES_U2	NORMAL	UNIQUE	APPS_TS_SEED	REPORT_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
UNIQUE_ID	NUMBER		Yes	Unique identifier for report name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REPORT_NAME	VARCHAR2	(50)	Yes	Report option name
REPORT_TITLE	VARCHAR2	(50)	Yes	Report option title
DESCRIPTION	VARCHAR2	(240)		Description
USER_DEFINED	NUMBER		Yes	Flag to indicate if this is a user-defined or seeded option
COLUMN1_HEADING	VARCHAR2	(50)		The displayed column heading for the first column
COLUMN2_HEADING	VARCHAR2	(50)		The displayed column heading for the second column
COLUMN3_HEADING	VARCHAR2	(50)		Not currently used
COLUMN4_HEADING	VARCHAR2	(50)		Not currently used
COLUMN1	VARCHAR2	(240)		Source of the information for column 1
COLUMN2	VARCHAR2	(240)		Source of the information for column 2
COLUMN3	VARCHAR2	(240)		Not currently used
COLUMN4	VARCHAR2	(240)		Not currently used
INVENTORY_FLAG	NUMBER			Flag to indicate if available in standalone inventory installation
DISABLE_DATE	DATE			Inactive On/After
FLEXFIELD_APPLICATION_ID	NUMBER			Application identifier
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(150)		Descriptive Flexfield name
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
REQUEST_ID	NUMBER			Concurrent Who column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT UNIQUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REPORT_NAME
,      REPORT_TITLE
,      DESCRIPTION
,      USER_DEFINED
,      COLUMN1_HEADING
,      COLUMN2_HEADING
,      COLUMN3_HEADING
,      COLUMN4_HEADING
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      INVENTORY_FLAG
,      DISABLE_DATE
,      FLEXFIELD_APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ZD_EDITION_NAME
FROM BOM.CST_REPORT_TYPES;

Dependencies

[top of page]

BOM.CST_REPORT_TYPES does not reference any database object

BOM.CST_REPORT_TYPES is referenced by following:

BOM: CST_REPORT_TYPES#