[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 |