VIEW: APPS.MTL_ITEM_ATTR_FIELDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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