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.

[Home] [Help]

View: CST_XLA_REP_ITEM_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_REP_ITEM_REF_V

View Text

SELECT WRI.WIP_ENTITY_ID
, WRI.LINE_ID
, WRI.WIP_SUPPLY_TYPE
, WRI.ATTRIBUTE_CATEGORY
, WRI.ATTRIBUTE1
, WRI.ATTRIBUTE2
, WRI.ATTRIBUTE3
, WRI.ATTRIBUTE4
, WRI.ATTRIBUTE5
, WRI.ATTRIBUTE6
, WRI.ATTRIBUTE7
, WRI.ATTRIBUTE8
, WRI.ATTRIBUTE9
, WRI.ATTRIBUTE10
, WRI.ATTRIBUTE11
, WRI.ATTRIBUTE12
, WRI.ATTRIBUTE13
, WRI.ATTRIBUTE14
, WRI.ATTRIBUTE15
, WRI.CLASS_CODE
, WAC.CLASS_TYPE
, WAC.DESCRIPTION
, WAC.COMPLETION_COST_SOURCE
, WAC.COST_TYPE_ID
, CCT.COST_TYPE
, WAC.SYSTEM_OPTION_ID
, WAC.ATTRIBUTE_CATEGORY
, WAC.ATTRIBUTE1
, WAC.ATTRIBUTE2
, WAC.ATTRIBUTE3
, WAC.ATTRIBUTE4
, WAC.ATTRIBUTE5
, WAC.ATTRIBUTE6
, WAC.ATTRIBUTE7
, WAC.ATTRIBUTE8
, WAC.ATTRIBUTE9
, WAC.ATTRIBUTE10
, WAC.ATTRIBUTE11
, WAC.ATTRIBUTE12
, WAC.ATTRIBUTE13
, WAC.ATTRIBUTE14
, WAC.ATTRIBUTE15
, WAC.BRIDGING_ACCOUNT
FROM WIP_REPETITIVE_ITEMS WRI
, WIP_ACCOUNTING_CLASSES WAC
, CST_COST_TYPES CCT
WHERE WRI.CLASS_CODE = WAC.CLASS_CODE
AND WRI.ORGANIZATION_ID = WAC.ORGANIZATION_ID
AND WAC.COST_TYPE_ID = CCT.COST_TYPE_ID (+)

Columns

Name
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