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_XLA_REP_ITEM_REF_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REP_ITM_WIP_ENTITY_ID	NUMBER		Yes	WIP repetitive assembly Identifier
REP_ITM_LINE_ID	NUMBER		Yes	WIP line Identifier
REP_ITM_SUPPLY_TYPE	NUMBER		Yes	Method of material consumption within WIP
REP_ITM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
REP_ITM_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS	VARCHAR2	(10)	Yes	Accounting class associated with the repetitive item
REP_ITM_ACCT_CLASS_TYPE	NUMBER		Yes	Accounting class type code
REP_ITM_ACCT_CLASS_DESCRIPTION	VARCHAR2	(240)		Description of the Account
REP_ITM_COMPLETION_COST_SOURCE	NUMBER			Completion cost source of the accounting class for average costing
REP_ITM_COMP_COST_TYPE_ID	NUMBER			Cost type Identifier for average costing
REP_ITM_COMPLETION_COST_TYPE	VARCHAR2	(10)		Cost type name
REP_ITM_SYSTEM_OPTION_ID	NUMBER			System option Identifier
REP_ITM_ACCT_CLASS_ATTR_CAT	VARCHAR2	(30)		Descriptive Flexfield structure defining column
REP_ITM_ACCT_CLASS_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_ACCT_CLASS_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
REP_ITM_BRIDGING_ACCT	NUMBER			Bridging account

Query Text

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


SELECT REP_ITM_WIP_ENTITY_ID
,      REP_ITM_LINE_ID
,      REP_ITM_SUPPLY_TYPE
,      REP_ITM_ATTRIBUTE_CATEGORY
,      REP_ITM_ATTRIBUTE1
,      REP_ITM_ATTRIBUTE2
,      REP_ITM_ATTRIBUTE3
,      REP_ITM_ATTRIBUTE4
,      REP_ITM_ATTRIBUTE5
,      REP_ITM_ATTRIBUTE6
,      REP_ITM_ATTRIBUTE7
,      REP_ITM_ATTRIBUTE8
,      REP_ITM_ATTRIBUTE9
,      REP_ITM_ATTRIBUTE10
,      REP_ITM_ATTRIBUTE11
,      REP_ITM_ATTRIBUTE12
,      REP_ITM_ATTRIBUTE13
,      REP_ITM_ATTRIBUTE14
,      REP_ITM_ATTRIBUTE15
,      REP_ITM_ACCT_CLASS
,      REP_ITM_ACCT_CLASS_TYPE
,      REP_ITM_ACCT_CLASS_DESCRIPTION
,      REP_ITM_COMPLETION_COST_SOURCE
,      REP_ITM_COMP_COST_TYPE_ID
,      REP_ITM_COMPLETION_COST_TYPE
,      REP_ITM_SYSTEM_OPTION_ID
,      REP_ITM_ACCT_CLASS_ATTR_CAT
,      REP_ITM_ACCT_CLASS_ATTRIBUTE1
,      REP_ITM_ACCT_CLASS_ATTRIBUTE2
,      REP_ITM_ACCT_CLASS_ATTRIBUTE3
,      REP_ITM_ACCT_CLASS_ATTRIBUTE4
,      REP_ITM_ACCT_CLASS_ATTRIBUTE5
,      REP_ITM_ACCT_CLASS_ATTRIBUTE6
,      REP_ITM_ACCT_CLASS_ATTRIBUTE7
,      REP_ITM_ACCT_CLASS_ATTRIBUTE8
,      REP_ITM_ACCT_CLASS_ATTRIBUTE9
,      REP_ITM_ACCT_CLASS_ATTRIBUTE10
,      REP_ITM_ACCT_CLASS_ATTRIBUTE11
,      REP_ITM_ACCT_CLASS_ATTRIBUTE12
,      REP_ITM_ACCT_CLASS_ATTRIBUTE13
,      REP_ITM_ACCT_CLASS_ATTRIBUTE14
,      REP_ITM_ACCT_CLASS_ATTRIBUTE15
,      REP_ITM_BRIDGING_ACCT
FROM APPS.CST_XLA_REP_ITEM_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_REP_ITEM_REF_V references the following:

APPS: CST_COST_TYPES; WIP_ACCOUNTING_CLASSES; WIP_REPETITIVE_ITEMS

APPS.CST_XLA_REP_ITEM_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code