Skip to content
[Home] [Help]
View: CZBV_CONFIG_CONSTRAINT_ASSIGNS
| Product: | BOM - Bills of Material |
|---|
| Description: | - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CO.ASSIGNMENT_ID
, CO.SEQUENCE_NUMBER
, CO.OPTIMIZE_EXPRESSION
, CO.EFFECTIVITY_DATE
, CO.DISABLE_DATE
, CO.ECN_CODE
, '_LA:CO.OPTIMIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CO.EVALUATE_ON_TRUE:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CO.REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CO.AUTOSELECT_ON_BOOK:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CO.PRICE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, CO.CONSTRAINT_ID
, CO.INVENTORY_ITEM_ID
, CO.ORGANIZATION_ID
, CO.SYSTEM_TYPE_CODE
, CO.CONSTRAINT_GROUP
, CO.AUTOSELECTION_TYPE
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM CZ_CONSTRAINT_ASSIGNMENTS CO WITH READ ONLY
Columns
| Name |
| CONFIG_CONSTRAINT_ASSIGN_ID |
| SEQUENCE_NUMBER |
| OPTIMIZATION_EXPRESSION |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| ECO_NAME |
| "_LA:USER_FUNCTION_FLAG" |
| "_LA:EVALUATE_IF_TRUE_FLAG" |
| "_LA:REVENUE_FLAG" |
| "_LA:AT_BOOKING_FLAG" |
| "_LA:INCLUDE_PRICE_FLAG" |
| CONSTRAINT_ID |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| SYSTEM_TYPE_CODE |
| CONSTRAINT_GROUP |
| AUTOSELECTION_TYPE |
| CREATED_DATE |
| CREATED_BY |
| LAST_UPDATED_DATE |
| LAST_UPDATED_BY |