View: MTL_ITEM_ATTR_FIELDS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_ATTR_FIELDS_V

View Text

SELECT USER_ATTRIBUTE_NAME_GUI
, ATTRIBUTE_NAME
, DECODE(ATTRIBUTE_NAME
, 'MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE'
, 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE'
, 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE'
, 'MTL_SYSTEM_ITEMS.SECONDARY_UOM'
, 'MTL_SYSTEM_ITEMS.WEIGHT_UOM_CODE'
, 'MTL_SYSTEM_ITEMS.WEIGHT_UOM'
, 'MTL_SYSTEM_ITEMS.VOLUME_UOM_CODE'
, 'MTL_SYSTEM_ITEMS.VOLUME_UOM'
, 'MTL_SYSTEM_ITEMS.DIMENSION_UOM_CODE'
, 'MTL_SYSTEM_ITEMS.DIMENSION_UOM'
, 'MTL_SYSTEM_ITEMS.DESC_FLEX'
, 'MTL_SYSTEM_ITEMS.DF'
, 'MTL_SYSTEM_ITEMS.BUYER_ID'
, 'MTL_SYSTEM_ITEMS.BUYER'
, 'MTL_SYSTEM_ITEMS.HAZARD_CLASS_ID'
, 'MTL_SYSTEM_ITEMS.HAZARD_CLASS'
, 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID'
, 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY'
, 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT'
, 'MTL_SYSTEM_ITEMS.EXPENSE_ACCOUNT_DSP'
, 'MTL_SYSTEM_ITEMS.UN_NUMBER_ID'
, 'MTL_SYSTEM_ITEMS.UN_NUMBER'
, 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT'
, 'MTL_SYSTEM_ITEMS.ENCUMBRANCE_ACCOUNT_DSP'
, 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY_ID'
, 'MTL_SYSTEM_ITEMS.ASSET_CATEGORY'
, 'MTL_SYSTEM_ITEMS.ITEM_TYPE'
, 'MTL_SYSTEM_ITEMS.ITEM_TYPE_DSP'
, 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE'
, 'MTL_SYSTEM_ITEMS.CONTAINER_TYPE_CODE_DSP'
, 'MTL_SYSTEM_ITEMS.SOURCE_ORGANIZATION_ID'
, 'MTL_SYSTEM_ITEMS.SOURCE_ORG_CODE'
, 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT'
, 'MTL_SYSTEM_ITEMS.COST_OF_SALES_ACCOUNT_DSP'
, 'MTL_SYSTEM_ITEMS.PICKING_RULE_ID'
, 'MTL_SYSTEM_ITEMS.PICKING_RULE'
, 'MTL_SYSTEM_ITEMS.ATP_RULE_ID'
, 'MTL_SYSTEM_ITEMS.ATP_RULE'
, 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG'
, 'MTL_SYSTEM_ITEMS.DEFAULT_SHIPPING_ORG_DSP'
, 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR_ID'
, 'MTL_SYSTEM_ITEMS.WIP_SUPPLY_LOCATOR'
, 'MTL_SYSTEM_ITEMS.BASE_ITEM_ID'
, 'MTL_SYSTEM_ITEMS.BASE_ITEM'
, 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP_FLAG'
, 'MTL_SYSTEM_ITEMS.DEFAULT_INCLUDE_IN_ROLLUP'
, 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLAG'
, 'MTL_SYSTEM_ITEMS.ALLOW_ITEM_DESC_UPDATE_FLA'
, 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_FLAG'
, 'MTL_SYSTEM_ITEMS.MUST_USE_APPROVED_VENDOR_F'
, 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLAG'
, 'MTL_SYSTEM_ITEMS.ALLOW_EXPRESS_DELIVERY_FLA'
, 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG'
, 'MTL_SYSTEM_ITEMS.ALLOW_SUBSTITUTE_RECEIPTS'
, 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_FLAG'
, 'MTL_SYSTEM_ITEMS.ALLOW_UNORDERED_RECEIPTS_F'
, 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_CODE'
, 'MTL_SYSTEM_ITEMS.ENFORCE_SHIP_TO_LOCATION_C'
, 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_CODE'
, 'MTL_SYSTEM_ITEMS.RECEIPT_DAYS_EXCEPTION_COD'
, 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_F'
, 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CODE'
, 'MTL_SYSTEM_ITEMS.RESTRICT_SUBINVENTORIES_CO'
, 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIME'
, 'MTL_SYSTEM_ITEMS.CUM_MANUFACTURING_LEAD_TIM'
, 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLA'
, 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLA'
, 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREMENT'
, 'MTL_SYSTEM_ITEMS.RETURN_INSPECTION_REQUIREM'
, 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE_ID'
, 'MTL_SYSTEM_ITEMS.ACCOUNTING_RULE'
, 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT'
, 'MTL_SYSTEM_ITEMS.SALES_ACCOUNT_DSP'
, 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS_ID'
, 'MTL_SYSTEM_ITEMS.PAYMENT_TERMS'
, 'MTL_SYSTEM_ITEMS.INVOICING_RULE_ID'
, 'MTL_SYSTEM_ITEMS.INVOICING_RULE'
, 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD_CODE'
, 'MTL_SYSTEM_ITEMS.SERVICE_DURATION_PERIOD'
, 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE_ID'
, 'MTL_SYSTEM_ITEMS.COVERAGE_SCHEDULE'
, 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_TYPE'
, 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_T'
, 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_VALUE'
, 'MTL_SYSTEM_ITEMS.OVERCOMPLETION_TOLERANCE_V'
, 'MTL_SYSTEM_ITEMS.WEB_STATUS'
, 'MTL_SYSTEM_ITEMS.WEB_STATUS_DSP'
, 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS_ID'
, 'MTL_SYSTEM_ITEMS.DEFAULT_LOT_STATUS'
, 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS_ID'
, 'MTL_SYSTEM_ITEMS.DEFAULT_SERIAL_STATUS'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE_CODE'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_TYPE'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE_CODE'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_CAUSE'
, 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS'
, 'MTL_SYSTEM_ITEMS.EAM_ACT_SHUTDOWN_STATUS_D'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE_CODE'
, 'MTL_SYSTEM_ITEMS.EAM_ACTIVITY_SOURCE'
, 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.PROCESS_COSTING_ENABLED_FL'
, 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG'
, 'MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FL'
, 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.PROCESS_QUALITY_ENABLED_FL'
, 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG'
, 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED'
, 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTORY'
, 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_SUBINVENTOR'
, 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR_ID'
, 'MTL_SYSTEM_ITEMS.PROCESS_SUPPLY_LOCATOR'
, 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR_ID'
, 'MTL_SYSTEM_ITEMS.PROCESS_YIELD_LOCATOR'
, ATTRIBUTE_NAME) || '_MIR'
, ATTRIBUTE_GROUP_ID_GUI
, CONTROL_LEVEL
FROM MTL_ITEM_ATTRIBUTES
WHERE CONTROL_LEVEL IN (1
, 2)
AND ATTRIBUTE_GROUP_ID_GUI IN (20
, 25
, 30
, 31
, 35
, 40
, 41
, 51
, 60
, 62
, 65
, 70
, 80
, 90
, 100
, 120
, 130)
AND USER_ATTRIBUTE_NAME_GUI IS NOT NULL

Columns