FND Design Data [Home] [Help]

View: CST_XLA_WIP_ORG_PARAMS_REF_V

Product: BOM - Bills of Material
Description:
Implementation/DBA Data: ViewAPPS.CST_XLA_WIP_ORG_PARAMS_REF_V
View Text

SELECT WIP.ORGANIZATION_ID WIP_ORGANIZATION_ID
, WIP.REPETITIVE_VARIANCE_TYPE
, DECODE(WSP.ESTIMATED_SCRAP_ACCOUNTING
, 1
, 'Y'
, 'N' ) ESTIMATED_SCRAP_ACCOUNTING
, WIP.ATTRIBUTE_CATEGORY ORG_WIP_ATTRIBUTE_CATEGORY
, WIP.ATTRIBUTE1 ORG_WIP_ATTRIBUTE1
, WIP.ATTRIBUTE2 ORG_WIP_ATTRIBUTE2
, WIP.ATTRIBUTE3 ORG_WIP_ATTRIBUTE3
, WIP.ATTRIBUTE4 ORG_WIP_ATTRIBUTE4
, WIP.ATTRIBUTE5 ORG_WIP_ATTRIBUTE5
, WIP.ATTRIBUTE6 ORG_WIP_ATTRIBUTE6
, WIP.ATTRIBUTE7 ORG_WIP_ATTRIBUTE7
, WIP.ATTRIBUTE8 ORG_WIP_ATTRIBUTE8
, WIP.ATTRIBUTE9 ORG_WIP_ATTRIBUTE9
, WIP.ATTRIBUTE10 ORG_WIP_ATTRIBUTE10
, WIP.ATTRIBUTE11 ORG_WIP_ATTRIBUTE11
, WIP.ATTRIBUTE12 ORG_WIP_ATTRIBUTE12
, WIP.ATTRIBUTE13 ORG_WIP_ATTRIBUTE13
, WIP.ATTRIBUTE14 ORG_WIP_ATTRIBUTE14
, WIP.ATTRIBUTE15 ORG_WIP_ATTRIBUTE15
FROM WIP_PARAMETERS WIP
, WSM_PARAMETERS WSP
WHERE WIP.ORGANIZATION_ID = WSP.ORGANIZATION_ID (+)

Columns

Name
WIP_ORGANIZATION_ID
REPETITIVE_VARIANCE_TYPE
ESTIMATED_SCRAP_ACCOUNTING
ORG_WIP_ATTRIBUTE_CATEGORY
ORG_WIP_ATTRIBUTE1
ORG_WIP_ATTRIBUTE2
ORG_WIP_ATTRIBUTE3
ORG_WIP_ATTRIBUTE4
ORG_WIP_ATTRIBUTE5
ORG_WIP_ATTRIBUTE6
ORG_WIP_ATTRIBUTE7
ORG_WIP_ATTRIBUTE8
ORG_WIP_ATTRIBUTE9
ORG_WIP_ATTRIBUTE10
ORG_WIP_ATTRIBUTE11
ORG_WIP_ATTRIBUTE12
ORG_WIP_ATTRIBUTE13
ORG_WIP_ATTRIBUTE14
ORG_WIP_ATTRIBUTE15