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_INQUIRY_TYPES

Object Details

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

CST_INQUIRY_TYPES stores item cost inquiry option information. This
information is used by the View Item Costs Summary window.
.
The INQUIRY_NAME column stores the option name. The UNIQUE_ID column
stores the unique identifier for INQUIRY_NAME. For example,
UNIQUE_ID '13' corresponds to the inquiry 'Element by level.' You can
create user-defined inquiries by entering 1 in the USER_DEFINED
column. The UNIQUE_ID for user-defined inquiries is determined by
the sequence CST_INQUIRY_TYPES_S.
.
Each inquiry is associated with a template type
(GUI_TEMPLATE_TYPE). The template type determines which columns are
displayed in the View Item Costs Summary window. For example, when
an inquiry that is associated with the template type 'Single entity
cost summary' is selected, two columns are displayed. However, when
an inquiry that is associated with the template type 'Two entity cost
summary' is selected, three columns are displayed.
.
The actual column headings displayed in the View Item Costs Summary
window are determined by the exact inquiry selected. For example,
although both the 'Activity Summary' and 'Element Summary' inquiries
are associated with the two column 'Single entity cost summary'
template type, the column headings Activity and Description
(corresponding to GUI_COL2_PROMPT_BOTTOM and GUI_DESC_PROMPT) are
displayed when the former is chosen, while the column headings Cost,
Element, and Description (corresponding to GUI_COL2_PROMPT_TOP,
GUI_COL2_PROMPT_BOTTOM and GUI_DESC_PROMPT)
are displayed when the latter is chosen.
.
The VIEW_NAME column stores the view name that is used when the View
Item Cost Summary window copies queried cost information to the
CST_INQUIRY_TEMP table. Different views are used for different
inquiries. For example, if you choose 'Activity summary,' the
VIEW_NAME is 'CST_ELEMENT_COST_VIEW.'
.
FLEXFIELD_APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME store the
application identifier and descriptive flexfield name for those
inquiry options that display costs by flexfield segment value and
require the user to choose a flexfield segment. They are used to
retrieve segments for the flexfield.
.
INVENTORY_FLAG specifies whether this option is available in a
standalone inventory installation. Some of the detail options are not
needed 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_INQUIRY_TYPES_U1	NORMAL	UNIQUE	APPS_TS_SEED	UNIQUE_ID
CST_INQUIRY_TYPES_U2	NORMAL	UNIQUE	APPS_TS_SEED	INQUIRY_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
UNIQUE_ID	NUMBER		Yes	Unique identifier for the inquiry 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
INQUIRY_NAME	VARCHAR2	(50)	Yes	Cost type detail option
DESCRIPTION	VARCHAR2	(240)		Inquiry option description
USER_DEFINED	NUMBER		Yes	User defined option
TEMPLATE_TYPE	NUMBER		Yes	No longer used
GUI_TEMPLATE_TYPE	NUMBER			Template type
VIEW_NAME	VARCHAR2	(30)	Yes	Name of view to be copied into CST_INQUIRY_TEMP
COLUMN1_HEADING	VARCHAR2	(50)		No longer used
COLUMN2_HEADING	VARCHAR2	(50)		No longer used
DESCRIPTION_COLUMN_HEADING	VARCHAR2	(50)		No longer used
GUI_COL1_PROMPT_TOP	VARCHAR2	(50)		First line of column heading for GUI_COL1
GUI_COL1_PROMPT_BOTTOM	VARCHAR2	(50)		Second line of column heading for GUI_COL1
GUI_COL2_PROMPT_TOP	VARCHAR2	(50)		First line of column heading for GUI_COL2
GUI_COL2_PROMPT_BOTTOM	VARCHAR2	(50)		Second line of column heading for GUI_COL2
GUI_DESC_PROMPT	VARCHAR2	(50)		Column heading for description column
INVENTORY_FLAG	NUMBER			Stand-alone 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
CHAR_GUI_AVAILABLE	NUMBER		Yes	Flag to determine which version of the application the view could appear in

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
,      INQUIRY_NAME
,      DESCRIPTION
,      USER_DEFINED
,      TEMPLATE_TYPE
,      GUI_TEMPLATE_TYPE
,      VIEW_NAME
,      COLUMN1_HEADING
,      COLUMN2_HEADING
,      DESCRIPTION_COLUMN_HEADING
,      GUI_COL1_PROMPT_TOP
,      GUI_COL1_PROMPT_BOTTOM
,      GUI_COL2_PROMPT_TOP
,      GUI_COL2_PROMPT_BOTTOM
,      GUI_DESC_PROMPT
,      INVENTORY_FLAG
,      DISABLE_DATE
,      FLEXFIELD_APPLICATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CHAR_GUI_AVAILABLE
FROM BOM.CST_INQUIRY_TYPES;

Dependencies

[top of page]

BOM.CST_INQUIRY_TYPES does not reference any database object

BOM.CST_INQUIRY_TYPES is referenced by following:

APPS: CST_INQUIRY_TYPES