eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: INV.INV_ITEM_TEMP#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID, SYNCIND SYNCIND, DELETE_GROUP_NAME DELETE_GROUP_NAME, DG_DESCRIPTION DG_DESCRIPTION, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_CODE ORGANIZATION_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NUMBER ITEM_NUMBER, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, DESCRIPTION DESCRIPTION, LONG_DESCRIPTION LONG_DESCRIPTION, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, ITEM_TYPE ITEM_TYPE, INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, CATALOG_STATUS_FLAG CATALOG_STATUS_FLAG, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, STOCK_ENABLED_FLAG STOCK_ENABLED_FLAG, MTL_TRANSACTIONS_ENABLED_FLAG MTL_TRANSACTIONS_ENABLED_FLAG, CHECK_SHORTAGES_FLAG CHECK_SHORTAGES_FLAG, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE, RESERVABLE_TYPE RESERVABLE_TYPE, SHELF_LIFE_CODE SHELF_LIFE_CODE, SHELF_LIFE_DAYS SHELF_LIFE_DAYS, CYCLE_COUNT_ENABLED_FLAG CYCLE_COUNT_ENABLED_FLAG, NEGATIVE_MEASUREMENT_ERROR NEGATIVE_MEASUREMENT_ERROR, POSITIVE_MEASUREMENT_ERROR POSITIVE_MEASUREMENT_ERROR, LOT_CONTROL_CODE LOT_CONTROL_CODE, AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX, START_AUTO_LOT_NUMBER START_AUTO_LOT_NUMBER, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX, START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE, RESTRICT_SUBINVENTORIES_CODE RESTRICT_SUBINVENTORIES_CODE, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE, BOM_ENABLED_FLAG BOM_ENABLED_FLAG, BOM_ITEM_TYPE BOM_ITEM_TYPE, BASE_ITEM_ID BASE_ITEM_ID, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL, ENG_ITEM_FLAG ENG_ITEM_FLAG, ENGINEERING_ECN_CODE ENGINEERING_ECN_CODE, ENGINEERING_ITEM_ID ENGINEERING_ITEM_ID, ENGINEERING_DATE ENGINEERING_DATE, PRODUCT_FAMILY_ITEM_ID PRODUCT_FAMILY_ITEM_ID, AUTO_CREATED_CONFIG_FLAG AUTO_CREATED_CONFIG_FLAG, MODEL_CONFIG_CLAUSE_NAME MODEL_CONFIG_CLAUSE_NAME, COSTING_ENABLED_FLAG COSTING_ENABLED_FLAG, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG, DEFAULT_INCLUDE_IN_ROLLUP_FLAG DEFAULT_INCLUDE_IN_ROLLUP_FLAG, COST_OF_SALES_ACCOUNT COST_OF_SALES_ACCOUNT, STD_LOT_SIZE STD_LOT_SIZE, PURCHASING_ITEM_FLAG PURCHASING_ITEM_FLAG, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, MUST_USE_APPROVED_VENDOR_FLAG MUST_USE_APPROVED_VENDOR_FLAG, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG, OUTSIDE_OPERATION_UOM_TYPE OUTSIDE_OPERATION_UOM_TYPE, TAXABLE_FLAG TAXABLE_FLAG, PURCHASING_TAX_CODE PURCHASING_TAX_CODE, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, BUYER_ID BUYER_ID, UNIT_OF_ISSUE UNIT_OF_ISSUE, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE, UN_NUMBER_ID UN_NUMBER_ID, HAZARD_CLASS_ID HAZARD_CLASS_ID, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT, MARKET_PRICE MARKET_PRICE, PRICE_TOLERANCE_PERCENT PRICE_TOLERANCE_PERCENT, ROUNDING_FACTOR ROUNDING_FACTOR, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT, EXPENSE_ACCOUNT EXPENSE_ACCOUNT, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG, ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG, ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_EXPRESS_DELIVERY_FLAG, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, UNIT_WEIGHT UNIT_WEIGHT, VOLUME_UOM_CODE VOLUME_UOM_CODE, UNIT_VOLUME UNIT_VOLUME, CONTAINER_ITEM_FLAG CONTAINER_ITEM_FLAG, VEHICLE_ITEM_FLAG VEHICLE_ITEM_FLAG, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, INTERNAL_VOLUME INTERNAL_VOLUME, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE, PLANNER_CODE PLANNER_CODE, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY, ORDER_COST ORDER_COST, CARRYING_COST CARRYING_COST, SOURCE_TYPE SOURCE_TYPE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_CODE, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS, MRP_SAFETY_STOCK_PERCENT MRP_SAFETY_STOCK_PERCENT, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, MRP_PLANNING_CODE MRP_PLANNING_CODE, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG, SHRINKAGE_RATE SHRINKAGE_RATE, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE, ACCEPTABLE_EARLY_DAYS ACCEPTABLE_EARLY_DAYS, REPETITIVE_PLANNING_FLAG REPETITIVE_PLANNING_FLAG, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE, MRP_CALCULATE_ATP_FLAG MRP_CALCULATE_ATP_FLAG, AUTO_REDUCE_MPS AUTO_REDUCE_MPS, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS, DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_CODE, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME, FULL_LEAD_TIME FULL_LEAD_TIME, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME, FIXED_LEAD_TIME FIXED_LEAD_TIME, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME, LEAD_TIME_LOT_SIZE LEAD_TIME_LOT_SIZE, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, WIP_SUPPLY_SUBINVENTORY WIP_SUPPLY_SUBINVENTORY, WIP_SUPPLY_LOCATOR_ID WIP_SUPPLY_LOCATOR_ID, OVERCOMPLETION_TOLERANCE_TYPE OVERCOMPLETION_TOLERANCE_TYPE, OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE_VALUE, CUSTOMER_ORDER_FLAG CUSTOMER_ORDER_FLAG, CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG, SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG, INTERNAL_ORDER_FLAG INTERNAL_ORDER_FLAG, INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG, SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG, ATP_FLAG ATP_FLAG, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG, ATP_RULE_ID ATP_RULE_ID, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, PICKING_RULE_ID PICKING_RULE_ID, COLLATERAL_FLAG COLLATERAL_FLAG, DEFAULT_SHIPPING_ORG DEFAULT_SHIPPING_ORG, RETURNABLE_FLAG RETURNABLE_FLAG, RETURN_INSPECTION_REQUIREMENT RETURN_INSPECTION_REQUIREMENT, OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE, OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE, UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE, INVOICEABLE_ITEM_FLAG INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG INVOICE_ENABLED_FLAG, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, TAX_CODE TAX_CODE, SALES_ACCOUNT SALES_ACCOUNT, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG, VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG, COVERAGE_SCHEDULE_ID COVERAGE_SCHEDULE_ID, SERVICE_DURATION SERVICE_DURATION, SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION_PERIOD_CODE, SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG, SERVICE_STARTING_DELAY SERVICE_STARTING_DELAY, MATERIAL_BILLABLE_FLAG MATERIAL_BILLABLE_FLAG, SERVICEABLE_COMPONENT_FLAG SERVICEABLE_COMPONENT_FLAG, PREVENTIVE_MAINTENANCE_FLAG PREVENTIVE_MAINTENANCE_FLAG, PRORATE_SERVICE_FLAG PRORATE_SERVICE_FLAG, WH_UPDATE_DATE WH_UPDATE_DATE, EQUIPMENT_TYPE EQUIPMENT_TYPE, RECOVERED_PART_DISP_CODE RECOVERED_PART_DISP_CODE, DEFECT_TRACKING_ON_FLAG DEFECT_TRACKING_ON_FLAG, USAGE_ITEM_FLAG USAGE_ITEM_FLAG, EVENT_FLAG EVENT_FLAG, ELECTRONIC_FLAG ELECTRONIC_FLAG, DOWNLOADABLE_FLAG DOWNLOADABLE_FLAG, VOL_DISCOUNT_EXEMPT_FLAG VOL_DISCOUNT_EXEMPT_FLAG, COUPON_EXEMPT_FLAG COUPON_EXEMPT_FLAG, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG, ASSET_CREATION_CODE ASSET_CREATION_CODE, COMMS_ACTIVATION_REQD_FLAG COMMS_ACTIVATION_REQD_FLAG, ORDERABLE_ON_WEB_FLAG ORDERABLE_ON_WEB_FLAG, BACK_ORDERABLE_FLAG BACK_ORDERABLE_FLAG, WEB_STATUS WEB_STATUS, INDIVISIBLE_FLAG INDIVISIBLE_FLAG, DIMENSION_UOM_CODE DIMENSION_UOM_CODE, UNIT_LENGTH UNIT_LENGTH, UNIT_WIDTH UNIT_WIDTH, UNIT_HEIGHT UNIT_HEIGHT, BULK_PICKED_FLAG BULK_PICKED_FLAG, LOT_STATUS_ENABLED LOT_STATUS_ENABLED, DEFAULT_LOT_STATUS_ID DEFAULT_LOT_STATUS_ID, SERIAL_STATUS_ENABLED SERIAL_STATUS_ENABLED, DEFAULT_SERIAL_STATUS_ID DEFAULT_SERIAL_STATUS_ID, LOT_SPLIT_ENABLED LOT_SPLIT_ENABLED, LOT_MERGE_ENABLED LOT_MERGE_ENABLED, INVENTORY_CARRY_PENALTY INVENTORY_CARRY_PENALTY, OPERATION_SLACK_PENALTY OPERATION_SLACK_PENALTY, FINANCING_ALLOWED_FLAG FINANCING_ALLOWED_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "INV"."INV_ITEM_TEMP"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_GROUP_ID TRANSACTION_GROUP_ID
, SYNCIND SYNCIND
, DELETE_GROUP_NAME DELETE_GROUP_NAME
, DG_DESCRIPTION DG_DESCRIPTION
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, DESCRIPTION DESCRIPTION
, LONG_DESCRIPTION LONG_DESCRIPTION
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, ITEM_TYPE ITEM_TYPE
, INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE
, ALLOWED_UNITS_LOOKUP_CODE ALLOWED_UNITS_LOOKUP_CODE
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, CATALOG_STATUS_FLAG CATALOG_STATUS_FLAG
, INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, STOCK_ENABLED_FLAG STOCK_ENABLED_FLAG
, MTL_TRANSACTIONS_ENABLED_FLAG MTL_TRANSACTIONS_ENABLED_FLAG
, CHECK_SHORTAGES_FLAG CHECK_SHORTAGES_FLAG
, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, RESERVABLE_TYPE RESERVABLE_TYPE
, SHELF_LIFE_CODE SHELF_LIFE_CODE
, SHELF_LIFE_DAYS SHELF_LIFE_DAYS
, CYCLE_COUNT_ENABLED_FLAG CYCLE_COUNT_ENABLED_FLAG
, NEGATIVE_MEASUREMENT_ERROR NEGATIVE_MEASUREMENT_ERROR
, POSITIVE_MEASUREMENT_ERROR POSITIVE_MEASUREMENT_ERROR
, LOT_CONTROL_CODE LOT_CONTROL_CODE
, AUTO_LOT_ALPHA_PREFIX AUTO_LOT_ALPHA_PREFIX
, START_AUTO_LOT_NUMBER START_AUTO_LOT_NUMBER
, SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, AUTO_SERIAL_ALPHA_PREFIX AUTO_SERIAL_ALPHA_PREFIX
, START_AUTO_SERIAL_NUMBER START_AUTO_SERIAL_NUMBER
, LOCATION_CONTROL_CODE LOCATION_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE RESTRICT_SUBINVENTORIES_CODE
, RESTRICT_LOCATORS_CODE RESTRICT_LOCATORS_CODE
, BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, BASE_ITEM_ID BASE_ITEM_ID
, EFFECTIVITY_CONTROL EFFECTIVITY_CONTROL
, ENG_ITEM_FLAG ENG_ITEM_FLAG
, ENGINEERING_ECN_CODE ENGINEERING_ECN_CODE
, ENGINEERING_ITEM_ID ENGINEERING_ITEM_ID
, ENGINEERING_DATE ENGINEERING_DATE
, PRODUCT_FAMILY_ITEM_ID PRODUCT_FAMILY_ITEM_ID
, AUTO_CREATED_CONFIG_FLAG AUTO_CREATED_CONFIG_FLAG
, MODEL_CONFIG_CLAUSE_NAME MODEL_CONFIG_CLAUSE_NAME
, COSTING_ENABLED_FLAG COSTING_ENABLED_FLAG
, INVENTORY_ASSET_FLAG INVENTORY_ASSET_FLAG
, DEFAULT_INCLUDE_IN_ROLLUP_FLAG DEFAULT_INCLUDE_IN_ROLLUP_FLAG
, COST_OF_SALES_ACCOUNT COST_OF_SALES_ACCOUNT
, STD_LOT_SIZE STD_LOT_SIZE
, PURCHASING_ITEM_FLAG PURCHASING_ITEM_FLAG
, PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, MUST_USE_APPROVED_VENDOR_FLAG MUST_USE_APPROVED_VENDOR_FLAG
, ALLOW_ITEM_DESC_UPDATE_FLAG ALLOW_ITEM_DESC_UPDATE_FLAG
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_FLAG
, OUTSIDE_OPERATION_UOM_TYPE OUTSIDE_OPERATION_UOM_TYPE
, TAXABLE_FLAG TAXABLE_FLAG
, PURCHASING_TAX_CODE PURCHASING_TAX_CODE
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, BUYER_ID BUYER_ID
, UNIT_OF_ISSUE UNIT_OF_ISSUE
, RECEIVE_CLOSE_TOLERANCE RECEIVE_CLOSE_TOLERANCE
, INVOICE_CLOSE_TOLERANCE INVOICE_CLOSE_TOLERANCE
, UN_NUMBER_ID UN_NUMBER_ID
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, MARKET_PRICE MARKET_PRICE
, PRICE_TOLERANCE_PERCENT PRICE_TOLERANCE_PERCENT
, ROUNDING_FACTOR ROUNDING_FACTOR
, ENCUMBRANCE_ACCOUNT ENCUMBRANCE_ACCOUNT
, EXPENSE_ACCOUNT EXPENSE_ACCOUNT
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, RECEIPT_DAYS_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE
, DAYS_EARLY_RECEIPT_ALLOWED DAYS_EARLY_RECEIPT_ALLOWED
, DAYS_LATE_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED
, ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, ALLOW_UNORDERED_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG
, ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_EXPRESS_DELIVERY_FLAG
, QTY_RCV_EXCEPTION_CODE QTY_RCV_EXCEPTION_CODE
, QTY_RCV_TOLERANCE QTY_RCV_TOLERANCE
, RECEIVING_ROUTING_ID RECEIVING_ROUTING_ID
, ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, UNIT_WEIGHT UNIT_WEIGHT
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, UNIT_VOLUME UNIT_VOLUME
, CONTAINER_ITEM_FLAG CONTAINER_ITEM_FLAG
, VEHICLE_ITEM_FLAG VEHICLE_ITEM_FLAG
, CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, INTERNAL_VOLUME INTERNAL_VOLUME
, MAXIMUM_LOAD_WEIGHT MAXIMUM_LOAD_WEIGHT
, MINIMUM_FILL_PERCENT MINIMUM_FILL_PERCENT
, INVENTORY_PLANNING_CODE INVENTORY_PLANNING_CODE
, PLANNER_CODE PLANNER_CODE
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, MIN_MINMAX_QUANTITY MIN_MINMAX_QUANTITY
, MAX_MINMAX_QUANTITY MAX_MINMAX_QUANTITY
, MINIMUM_ORDER_QUANTITY MINIMUM_ORDER_QUANTITY
, MAXIMUM_ORDER_QUANTITY MAXIMUM_ORDER_QUANTITY
, ORDER_COST ORDER_COST
, CARRYING_COST CARRYING_COST
, SOURCE_TYPE SOURCE_TYPE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, MRP_SAFETY_STOCK_CODE MRP_SAFETY_STOCK_CODE
, SAFETY_STOCK_BUCKET_DAYS SAFETY_STOCK_BUCKET_DAYS
, MRP_SAFETY_STOCK_PERCENT MRP_SAFETY_STOCK_PERCENT
, FIXED_ORDER_QUANTITY FIXED_ORDER_QUANTITY
, FIXED_DAYS_SUPPLY FIXED_DAYS_SUPPLY
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, MRP_PLANNING_CODE MRP_PLANNING_CODE
, ATO_FORECAST_CONTROL ATO_FORECAST_CONTROL
, PLANNING_EXCEPTION_SET PLANNING_EXCEPTION_SET
, END_ASSEMBLY_PEGGING_FLAG END_ASSEMBLY_PEGGING_FLAG
, SHRINKAGE_RATE SHRINKAGE_RATE
, ROUNDING_CONTROL_TYPE ROUNDING_CONTROL_TYPE
, ACCEPTABLE_EARLY_DAYS ACCEPTABLE_EARLY_DAYS
, REPETITIVE_PLANNING_FLAG REPETITIVE_PLANNING_FLAG
, OVERRUN_PERCENTAGE OVERRUN_PERCENTAGE
, ACCEPTABLE_RATE_INCREASE ACCEPTABLE_RATE_INCREASE
, ACCEPTABLE_RATE_DECREASE ACCEPTABLE_RATE_DECREASE
, MRP_CALCULATE_ATP_FLAG MRP_CALCULATE_ATP_FLAG
, AUTO_REDUCE_MPS AUTO_REDUCE_MPS
, PLANNING_TIME_FENCE_CODE PLANNING_TIME_FENCE_CODE
, PLANNING_TIME_FENCE_DAYS PLANNING_TIME_FENCE_DAYS
, DEMAND_TIME_FENCE_CODE DEMAND_TIME_FENCE_CODE
, DEMAND_TIME_FENCE_DAYS DEMAND_TIME_FENCE_DAYS
, RELEASE_TIME_FENCE_CODE RELEASE_TIME_FENCE_CODE
, RELEASE_TIME_FENCE_DAYS RELEASE_TIME_FENCE_DAYS
, PREPROCESSING_LEAD_TIME PREPROCESSING_LEAD_TIME
, FULL_LEAD_TIME FULL_LEAD_TIME
, POSTPROCESSING_LEAD_TIME POSTPROCESSING_LEAD_TIME
, FIXED_LEAD_TIME FIXED_LEAD_TIME
, VARIABLE_LEAD_TIME VARIABLE_LEAD_TIME
, CUM_MANUFACTURING_LEAD_TIME CUM_MANUFACTURING_LEAD_TIME
, CUMULATIVE_TOTAL_LEAD_TIME CUMULATIVE_TOTAL_LEAD_TIME
, LEAD_TIME_LOT_SIZE LEAD_TIME_LOT_SIZE
, BUILD_IN_WIP_FLAG BUILD_IN_WIP_FLAG
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, WIP_SUPPLY_SUBINVENTORY WIP_SUPPLY_SUBINVENTORY
, WIP_SUPPLY_LOCATOR_ID WIP_SUPPLY_LOCATOR_ID
, OVERCOMPLETION_TOLERANCE_TYPE OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE_VALUE
, CUSTOMER_ORDER_FLAG CUSTOMER_ORDER_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG
, SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, INTERNAL_ORDER_FLAG INTERNAL_ORDER_FLAG
, INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG
, SO_TRANSACTIONS_FLAG SO_TRANSACTIONS_FLAG
, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, ATP_FLAG ATP_FLAG
, REPLENISH_TO_ORDER_FLAG REPLENISH_TO_ORDER_FLAG
, ATP_RULE_ID ATP_RULE_ID
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, PICKING_RULE_ID PICKING_RULE_ID
, COLLATERAL_FLAG COLLATERAL_FLAG
, DEFAULT_SHIPPING_ORG DEFAULT_SHIPPING_ORG
, RETURNABLE_FLAG RETURNABLE_FLAG
, RETURN_INSPECTION_REQUIREMENT RETURN_INSPECTION_REQUIREMENT
, OVER_SHIPMENT_TOLERANCE OVER_SHIPMENT_TOLERANCE
, UNDER_SHIPMENT_TOLERANCE UNDER_SHIPMENT_TOLERANCE
, OVER_RETURN_TOLERANCE OVER_RETURN_TOLERANCE
, UNDER_RETURN_TOLERANCE UNDER_RETURN_TOLERANCE
, INVOICEABLE_ITEM_FLAG INVOICEABLE_ITEM_FLAG
, INVOICE_ENABLED_FLAG INVOICE_ENABLED_FLAG
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, TAX_CODE TAX_CODE
, SALES_ACCOUNT SALES_ACCOUNT
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG
, COVERAGE_SCHEDULE_ID COVERAGE_SCHEDULE_ID
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_DURATION_PERIOD_CODE SERVICE_DURATION_PERIOD_CODE
, SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG
, SERVICE_STARTING_DELAY SERVICE_STARTING_DELAY
, MATERIAL_BILLABLE_FLAG MATERIAL_BILLABLE_FLAG
, SERVICEABLE_COMPONENT_FLAG SERVICEABLE_COMPONENT_FLAG
, PREVENTIVE_MAINTENANCE_FLAG PREVENTIVE_MAINTENANCE_FLAG
, PRORATE_SERVICE_FLAG PRORATE_SERVICE_FLAG
, WH_UPDATE_DATE WH_UPDATE_DATE
, EQUIPMENT_TYPE EQUIPMENT_TYPE
, RECOVERED_PART_DISP_CODE RECOVERED_PART_DISP_CODE
, DEFECT_TRACKING_ON_FLAG DEFECT_TRACKING_ON_FLAG
, USAGE_ITEM_FLAG USAGE_ITEM_FLAG
, EVENT_FLAG EVENT_FLAG
, ELECTRONIC_FLAG ELECTRONIC_FLAG
, DOWNLOADABLE_FLAG DOWNLOADABLE_FLAG
, VOL_DISCOUNT_EXEMPT_FLAG VOL_DISCOUNT_EXEMPT_FLAG
, COUPON_EXEMPT_FLAG COUPON_EXEMPT_FLAG
, COMMS_NL_TRACKABLE_FLAG COMMS_NL_TRACKABLE_FLAG
, ASSET_CREATION_CODE ASSET_CREATION_CODE
, COMMS_ACTIVATION_REQD_FLAG COMMS_ACTIVATION_REQD_FLAG
, ORDERABLE_ON_WEB_FLAG ORDERABLE_ON_WEB_FLAG
, BACK_ORDERABLE_FLAG BACK_ORDERABLE_FLAG
, WEB_STATUS WEB_STATUS
, INDIVISIBLE_FLAG INDIVISIBLE_FLAG
, DIMENSION_UOM_CODE DIMENSION_UOM_CODE
, UNIT_LENGTH UNIT_LENGTH
, UNIT_WIDTH UNIT_WIDTH
, UNIT_HEIGHT UNIT_HEIGHT
, BULK_PICKED_FLAG BULK_PICKED_FLAG
, LOT_STATUS_ENABLED LOT_STATUS_ENABLED
, DEFAULT_LOT_STATUS_ID DEFAULT_LOT_STATUS_ID
, SERIAL_STATUS_ENABLED SERIAL_STATUS_ENABLED
, DEFAULT_SERIAL_STATUS_ID DEFAULT_SERIAL_STATUS_ID
, LOT_SPLIT_ENABLED LOT_SPLIT_ENABLED
, LOT_MERGE_ENABLED LOT_MERGE_ENABLED
, INVENTORY_CARRY_PENALTY INVENTORY_CARRY_PENALTY
, OPERATION_SLACK_PENALTY OPERATION_SLACK_PENALTY
, FINANCING_ALLOWED_FLAG FINANCING_ALLOWED_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "INV"."INV_ITEM_TEMP"