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]

VIEW: APPS.CST_COST_UPDATES_V

Object Details

Object Name:	CST_COST_UPDATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_COST_UPDATES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COST_UPDATE_ID	NUMBER		Yes	Cost update session identifier
UPDATE_DATE	DATE			Cost update session start time
STATUS	NUMBER		Yes	The status of the cost update program
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
COST_TYPE	VARCHAR2	(10)	Yes	Cost type name
SNAPSHOT_SAVED_FLAG	NUMBER			Flag indicating whether adjustment details are saved
UPDATE_OPTION_DSP	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(240)	Yes	Description
INV_ADJUSTMENT_ACCOUNT	NUMBER			Code combination identifier for the inventory adjustment account
CODE_COMBINATION_ID	NUMBER	(15)		Key flexfield combination defining column
UPDATE_RESOURCE_OVHD_FLAG	NUMBER		Yes	Flag indicating whether resource and overhead costs should be updated
UPDATE_ACTIVITY_FLAG	NUMBER			Flag indicating whether activity cost should be updated
RANGE_OPTION_DSP	VARCHAR2	(80)
SINGLE_ITEM	NUMBER			Inventory item identifier
INV_ITEM_ID	NUMBER
ITEM_RANGE_LOW	VARCHAR2	(240)		Inventory item range from
ITEM_RANGE_HIGH	VARCHAR2	(240)		Inventory item range to
CATEGORY_ID	NUMBER			Category identifier
CATEGORY_NAME	VARCHAR2	(163)
CATEGORY_SET_ID	NUMBER			Category set identifier
CATEGORY_SET_NAME	VARCHAR2	(30)		Category set name
REQUEST_ID	NUMBER			Concurrent who column
CONC_PHASE_DSP	VARCHAR2	(80)
CONC_STATUS_DSP	VARCHAR2	(80)
CONC_MESSAGE	VARCHAR2	(240)		The text message about how the request completed
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
PROGRAM_APPLICATION_ID	NUMBER			Concurrent who column
PROGRAM_ID	NUMBER			Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
ROW_ID	ROWID	(10)

Query Text

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


SELECT COST_UPDATE_ID
,      UPDATE_DATE
,      STATUS
,      ORGANIZATION_ID
,      COST_TYPE_ID
,      COST_TYPE
,      SNAPSHOT_SAVED_FLAG
,      UPDATE_OPTION_DSP
,      DESCRIPTION
,      INV_ADJUSTMENT_ACCOUNT
,      CODE_COMBINATION_ID
,      UPDATE_RESOURCE_OVHD_FLAG
,      UPDATE_ACTIVITY_FLAG
,      RANGE_OPTION_DSP
,      SINGLE_ITEM
,      INV_ITEM_ID
,      ITEM_RANGE_LOW
,      ITEM_RANGE_HIGH
,      CATEGORY_ID
,      CATEGORY_NAME
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      REQUEST_ID
,      CONC_PHASE_DSP
,      CONC_STATUS_DSP
,      CONC_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ROW_ID
FROM APPS.CST_COST_UPDATES_V;

Dependencies

[top of page]

APPS.CST_COST_UPDATES_V references the following:

APPS: CST_COST_TYPES; CST_COST_UPDATES; FND_CONCURRENT_REQUESTS; FND_DATE - show dependent code; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_TIMEZONES - show dependent code; GL_CODE_COMBINATIONS; MFG_LOOKUPS; MTL_CATEGORIES_KFV; MTL_CATEGORY_SETS_TL; MTL_ITEM_FLEXFIELDS

APPS.CST_COST_UPDATES_V is not referenced by any database object