[Home] [Help] [Dependency Information]

TABLE: INV.INV_ITEM_TEMP

Object Details

Object Name:	INV_ITEM_TEMP
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.INV_ITEM_TEMP
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

INV.INV_ITEM_TEMP does not reference any database object

INV.INV_ITEM_TEMP is referenced by following:

APPS

INV_ITEM_TEMP