Product: | BOM - Bills of Material |
---|---|
Description: | Autoselection ranges |
Implementation/DBA Data: | Not implemented in this database |
SELECT AR.ROWID
, AR.RANGE_ID
, AR.LAST_UPDATE_DATE
, AR.LAST_UPDATED_BY
, AR.CREATION_DATE
, AR.CREATED_BY
, AR.LAST_UPDATE_LOGIN
, AR.ASSIGNMENT_ID
, AR.LOW_RANGE
, AR.HIGH_RANGE
, AR.FROM_RANGE
, AR.TO_RANGE
, AR.EFFECTIVITY_DATE
, AR.DISABLE_DATE
, AR.OPTIMIZE_ATTRIBUTE_CODE
, AK.NAME
, AR.COMPONENT_CODE
, AR.PRICE_FLAG
, AR.OPT_ATTRIBUTE_CODE
, AR.AUTOSELECT_ON_BOOK
, AR.ATTRIBUTE_CATEGORY
, AR.ATTRIBUTE1
, AR.ATTRIBUTE2
, AR.ATTRIBUTE3
, AR.ATTRIBUTE4
, AR.ATTRIBUTE5
, AR.ATTRIBUTE6
, AR.ATTRIBUTE7
, AR.ATTRIBUTE8
, AR.ATTRIBUTE9
, AR.ATTRIBUTE10
, AR.ATTRIBUTE11
, AR.ATTRIBUTE12
, AR.ATTRIBUTE13
, AR.ATTRIBUTE14
, AR.ATTRIBUTE15
FROM CZ_AUTOSELECTION_RANGES AR
, AK_ATTRIBUTES_VL AK
WHERE AK.ATTRIBUTE_CODE(+) = AR.OPT_ATTRIBUTE_CODE
AND AK.ATTRIBUTE_APPLICATION_ID (+) = 702