Product: | BOM - Bills of Material |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CST_XLA_WIP_ORG_PARAMS_REF_V |
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 (+)