[Home] [Help]
View: CZBV_CONFIG_AUTOSELECT_ITEMS
| Product: | BOM - Bills of Material |
|---|
| Description: | - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AU.AUTOSELECTION_ID
, AU.QUANTITY
, AU.EFFECTIVITY_DATE
, AU.DISABLE_DATE
, '_LA:AU.AUTOSELECT_ON_BOOK:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:AU.PRICE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, AU.RANGE_ID
, AU.ASSIGNMENT_ID
, AU.INVENTORY_ITEM_ID
, AU.ORGANIZATION_ID
, AU.CREATION_DATE
, AU.CREATED_BY
, AU.LAST_UPDATE_DATE
, AU.LAST_UPDATED_BY
FROM CZ_AUTOSELECTION_ITEMS AU
WHERE '_SEC:AU.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| CONFIGURATION_AUTOSELECTION_ID |
| QUANTITY |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| "_LA:AT_BOOKING_FLAG" |
| "_LA:INCLUDE_PRICE_FLAG" |
| RANGE_ID |
| ASSIGNMENT_ID |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| CREATED_DATE |
| CREATED_BY |
| LAST_UPDATED_DATE |
| LAST_UPDATED_BY |