VIEW: APPS.CST_XLA_WIP_ORG_PARAMS_REF_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)