[Home] [Help]
View: 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 |