[Home] [Help] [Dependency Information]

VIEW: APPS.INVBV_ORGANIZATION_ITEMS

Object Details

Object Name:	INVBV_ORGANIZATION_ITEMS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVBV_ORGANIZATION_ITEMS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows definitions for inventory items, engineering items, and purchasing items in the master organization.

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      _KF:ITEM_NAME
,      DESCRIPTION
,      MARKET_PRICE
,      OVERRECEIPT_TOLERANCE_PERCENT
,      LIST_PRICE
,      PRICE_TOLERANCE_PERCENT
,      ROUNDING_FACTOR
,      UNIT_OF_ISSUE
,      ALLOWED_EARLY_RECEIPT_DAYS
,      ALLOWED_LATE_RECEIPT_DAYS
,      INVOICE_CLOSE_TOLERANCE_PRCNT
,      RECEIPT_CLOSE_TOLERANCE_PRCNT
,      LOT_STARTING_PREFIX
,      LOT_STARTING_NUMBER
,      SHELF_LIFE_DAYS
,      SERIAL_STARTING_NUMBER
,      SERIAL_STARTING_PREFIX
,      SOURCE_SUBINVENTORY
,      UNIT_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      UNIT_VOLUME
,      SHRINKAGE_RATE
,      ACCEPTABLE_EARLY_DAYS
,      LEAD_TIME_LOT_SIZE
,      STANDARD_LOT_SIZE
,      CUMULATIVE_MFG_LEAD_TIME
,      OVERRUN_PERCENT
,      ACCEPTABLE_RATE_INCREASE
,      ACCEPTABLE_RATE_DECREASE
,      CUMULATIVE_TOTAL_LEAD_TIME
,      PLANNING_TIME_FENCE_DAYS
,      DEMAND_TIME_FENCE_DAYS
,      PLANNING_EXCEPTION_SET
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      WIP_SUPPLY_SUBINVENTORY
,      PRIMARY_UOM_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      INVENTORY_ITEM_STATUS_CODE
,      PLANNER_CODE
,      FIXED_LOT_MULTIPLIER
,      CARRYING_COST_PERCENT
,      POSTPROCESSING_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      PROCESSING_LEAD_TIME
,      ORDER_COST
,      SAFETY_STOCK_PERCENT
,      MINIMUM_MIN_MAX_QUANTITY
,      MAXIMUM_MIN_MAX_QUANTITY
,      MINIMUM_ORDER_QUANTITY
,      FIXED_ORDER_QUANTITY
,      FIXED_SUPPLY_DAYS
,      MAXIMUM_ORDER_QUANTITY
,      POSITIVE_MEASUREMENT_ERROR
,      NEGATIVE_MEASUREMENT_ERROR
,      ENGINEERING_CHANGE_ORDER
,      ENGINEERING_DATE
,      SERVICE_STARTING_DELAY_DAYS
,      SERVICE_DURATION_VALUE
,      TAX_CODE
,      SAFETY_STOCK_BUCKET_DAYS
,      RELEASE_TIME_FENCE_DAYS
,      MAXIMUM_LOAD_WEIGHT
,      MINIMUM_FILL_PERCENT
,      INTERNAL_VOLUME
,      _LA:PURCHASED_FLAG
,      _LA:SHIPPABLE_FLAG
,      _LA:CUSTOMER_ORDERED_FLAG
,      _LA:INTERNAL_ORDERED_FLAG
,      _LA:SUPPORT_SERVICE_FLAG
,      _LA:INVENTORY_ITEM_FLAG
,      _LA:ENGINEERING_ITEM_FLAG
,      _LA:INV_ASSET_VALUE_FLAG
,      _LA:PURCHASABLE_FLAG
,      _LA:CUST_ORDERS_ENABLED_FLAG
,      _LA:INT_ORDERS_ENABLED_FLAG
,      _LA:OE_TRANSACTABLE_FLAG
,      _LA:TRANSACTABLE_FLAG
,      _LA:STOCKABLE_FLAG
,      _LA:BOM_ALLOWED_FLAG
,      _LA:BUILD_IN_WIP_FLAG
,      _LA:REVISION_CONTROL_TYPE
,      _LA:CATALOG_COMPLETE_FLAG
,      _LA:RETURNABLE_FLAG
,      _LA:COLLATERAL_ITEM_FLAG
,      _LA:TAXABLE_FLAG
,      _LA:OVERRECEIPT_QTY_ACTION
,      _LA:ALLOW_DESC_UPDATE_FLAG
,      _LA:INSPECTION_REQUIRED_FLAG
,      _LA:RECEIPT_REQUIRED_FLAG
,      _LA:RFQ_REQUIRED_FLAG
,      _LA:ENFORCE_SHIP_TO_LOCATION
,      _LA:SUBSTITUTE_RECEIPTS_FLAG
,      _LA:UNORDERED_RECEIPTS_FLAG
,      _LA:EXPRESS_TRANSACTION_FLAG
,      _LA:RECEIPT_DATE_ACTION
,      _LA:LOT_CONTROL
,      _LA:SHELF_LIFE_CONTROL
,      _LA:SERIAL_GENERATION_TYPE
,      _LA:SOURCE_TYPE
,      _LA:RESTRICT_SUBINV_FLAG
,      _LA:RESTRICT_LOCATORS_FLAG
,      _LA:LOCATOR_CONTROL
,      _LA:PLANNING_TIME_FENCE_TYPE
,      _LA:DEMAND_TIME_FENCE_TYPE
,      _LA:CALCULATE_ATP_FLAG
,      _LA:PEGGING_FLAG
,      _LA:REPETITIVE_PLANNING_FLAG
,      _LA:BOM_ITEM_TYPE
,      _LA:PICK_COMPONENTS_FLAG
,      _LA:ASSEMBLE_TO_ORDER_FLAG
,      _LA:ATP_COMPONENTS_FLAG
,      _LA:CHECK_ATP_FLAG
,      _LA:SUPPLY_TYPE
,      _LA:UOM_CONVERSION_OPTION
,      _LA:INCLUDE_IN_ROLLUP_FLAG
,      _LA:INV_PLANNING_METHOD
,      _LA:MAKE_OR_BUY_FLAG
,      _LA:ROUND_ORDER_QTY_FLAG
,      _LA:SAFETY_STOCK_METHOD
,      _LA:RESERVABLE_FLAG
,      _LA:SERVICE_WARRANTY_FLAG
,      _LA:SERVICEABLE_PRODUCT_FLAG
,      _LA:BILLING_TYPE
,      _LA:INVOICEABLE_ITEM_FLAG
,      _LA:INVOICE_ENABLED_FLAG
,      _LA:APPROVED_SUPPLIER_FLAG
,      _LA:OUTSIDE_PROCESSING_FLAG
,      _LA:OUTSIDE_PROCESSING_UNIT
,      _LA:REDUCE_MPS_EVENT
,      _LA:COSTING_ENABLED_FLAG
,      _LA:CYCLE_COUNT_ENABLED_FLAG
,      _LA:SHIP_MODEL_COMPLETE_FLAG
,      _LA:PLANNING_METHOD
,      _LA:RMA_INSPECTION_REQD_FLAG
,      _LA:FORECAST_CONTROL_TYPE
,      _LA:RELEASE_TIME_FENCE_TYPE
,      _LA:CONTAINER_FLAG
,      _LA:VEHICLE_FLAG
,      CONTAINER_TYPE_CODE
,      ITEM_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      BUYER_ID
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      ITEM_CATALOG_GROUP_ID
,      DEFAULT_SHIPPING_ORG
,      HAZARD_CLASS_ID
,      UN_NUMBER_ID
,      ASSET_CATEGORY_ID
,      RECEIVING_ROUTING_ID
,      SOURCE_ORGANIZATION_ID
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      BASE_ITEM_ID
,      WIP_SUPPLY_LOCATOR_ID
,      COST_OF_SALES_ACCOUNT
,      SALES_ACCOUNT
,      ATP_RULE_ID
,      PICKING_RULE_ID
,      ENGINEERING_ITEM_ID
,      PAYMENT_TERMS_ID
,      COVERAGE_SCHEDULE_ID
,      PRODUCT_FAMILY_ITEM_ID
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CREATED_DATE
,      CREATED_BY
FROM APPS.INVBV_ORGANIZATION_ITEMS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS

MTL_PARAMETERS

MTL_SYSTEM_ITEMS

APPS.INVBV_ORGANIZATION_ITEMS is not referenced by any database object