DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.INVBV_ORGANIZATION_ITEMS

Object Details
Object Name: INVBV_ORGANIZATION_ITEMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.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
Name Datatype Length Mandatory Comments
ORGANIZATION_CODE VARCHAR2 (3)

ORGANIZATION_NAME VARCHAR2 (240) Yes
_KF:ITEM_NAME CHAR (15)
DESCRIPTION VARCHAR2 (240)

MARKET_PRICE NUMBER


OVERRECEIPT_TOLERANCE_PERCENT NUMBER


LIST_PRICE NUMBER


PRICE_TOLERANCE_PERCENT NUMBER


ROUNDING_FACTOR NUMBER


UNIT_OF_ISSUE VARCHAR2 (25)

ALLOWED_EARLY_RECEIPT_DAYS NUMBER


ALLOWED_LATE_RECEIPT_DAYS NUMBER


INVOICE_CLOSE_TOLERANCE_PRCNT NUMBER


RECEIPT_CLOSE_TOLERANCE_PRCNT NUMBER


LOT_STARTING_PREFIX VARCHAR2 (30)

LOT_STARTING_NUMBER VARCHAR2 (30)

SHELF_LIFE_DAYS NUMBER


SERIAL_STARTING_NUMBER VARCHAR2 (30)

SERIAL_STARTING_PREFIX VARCHAR2 (30)

SOURCE_SUBINVENTORY VARCHAR2 (10)

UNIT_WEIGHT NUMBER


WEIGHT_UOM_CODE VARCHAR2 (3)

VOLUME_UOM_CODE VARCHAR2 (3)

UNIT_VOLUME NUMBER


SHRINKAGE_RATE NUMBER


ACCEPTABLE_EARLY_DAYS NUMBER


LEAD_TIME_LOT_SIZE NUMBER


STANDARD_LOT_SIZE NUMBER


CUMULATIVE_MFG_LEAD_TIME NUMBER


OVERRUN_PERCENT NUMBER


ACCEPTABLE_RATE_INCREASE NUMBER


ACCEPTABLE_RATE_DECREASE NUMBER


CUMULATIVE_TOTAL_LEAD_TIME NUMBER


PLANNING_TIME_FENCE_DAYS NUMBER


DEMAND_TIME_FENCE_DAYS NUMBER


PLANNING_EXCEPTION_SET VARCHAR2 (10)

FIXED_LEAD_TIME NUMBER


VARIABLE_LEAD_TIME NUMBER


WIP_SUPPLY_SUBINVENTORY VARCHAR2 (10)

PRIMARY_UOM_CODE VARCHAR2 (3)

PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)

INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes
PLANNER_CODE VARCHAR2 (10)

FIXED_LOT_MULTIPLIER NUMBER


CARRYING_COST_PERCENT NUMBER


POSTPROCESSING_LEAD_TIME NUMBER


PREPROCESSING_LEAD_TIME NUMBER


PROCESSING_LEAD_TIME NUMBER


ORDER_COST NUMBER


SAFETY_STOCK_PERCENT NUMBER


MINIMUM_MIN_MAX_QUANTITY NUMBER


MAXIMUM_MIN_MAX_QUANTITY NUMBER


MINIMUM_ORDER_QUANTITY NUMBER


FIXED_ORDER_QUANTITY NUMBER


FIXED_SUPPLY_DAYS NUMBER


MAXIMUM_ORDER_QUANTITY NUMBER


POSITIVE_MEASUREMENT_ERROR NUMBER


NEGATIVE_MEASUREMENT_ERROR NUMBER


ENGINEERING_CHANGE_ORDER VARCHAR2 (50)

ENGINEERING_DATE DATE


SERVICE_STARTING_DELAY_DAYS NUMBER


SERVICE_DURATION_VALUE NUMBER


TAX_CODE VARCHAR2 (50)

SAFETY_STOCK_BUCKET_DAYS NUMBER


RELEASE_TIME_FENCE_DAYS NUMBER


MAXIMUM_LOAD_WEIGHT NUMBER


MINIMUM_FILL_PERCENT NUMBER


INTERNAL_VOLUME NUMBER


_LA:PURCHASED_FLAG CHAR (54)

_LA:SHIPPABLE_FLAG CHAR (53)

_LA:CUSTOMER_ORDERED_FLAG CHAR (53)

_LA:INTERNAL_ORDERED_FLAG CHAR (53)

_LA:SUPPORT_SERVICE_FLAG CHAR (51)

_LA:INVENTORY_ITEM_FLAG CHAR (53)

_LA:ENGINEERING_ITEM_FLAG CHAR (47)

_LA:INV_ASSET_VALUE_FLAG CHAR (54)

_LA:PURCHASABLE_FLAG CHAR (57)

_LA:CUST_ORDERS_ENABLED_FLAG CHAR (61)

_LA:INT_ORDERS_ENABLED_FLAG CHAR (61)

_LA:OE_TRANSACTABLE_FLAG CHAR (54)

_LA:TRANSACTABLE_FLAG CHAR (63)

_LA:STOCKABLE_FLAG CHAR (52)

_LA:BOM_ALLOWED_FLAG CHAR (50)

_LA:BUILD_IN_WIP_FLAG CHAR (51)

_LA:REVISION_CONTROL_TYPE CHAR (69)

_LA:CATALOG_COMPLETE_FLAG CHAR (53)

_LA:RETURNABLE_FLAG CHAR (49)

_LA:COLLATERAL_ITEM_FLAG CHAR (49)

_LA:TAXABLE_FLAG CHAR (47)

_LA:OVERRECEIPT_QTY_ACTION CHAR (81)

_LA:ALLOW_DESC_UPDATE_FLAG CHAR (62)

_LA:INSPECTION_REQUIRED_FLAG CHAR (58)

_LA:RECEIPT_REQUIRED_FLAG CHAR (55)

_LA:RFQ_REQUIRED_FLAG CHAR (51)

_LA:ENFORCE_SHIP_TO_LOCATION CHAR (88)

_LA:SUBSTITUTE_RECEIPTS_FLAG CHAR (64)

_LA:UNORDERED_RECEIPTS_FLAG CHAR (63)

_LA:EXPRESS_TRANSACTION_FLAG CHAR (61)

_LA:RECEIPT_DATE_ACTION CHAR (86)

_LA:LOT_CONTROL CHAR (60)

_LA:SHELF_LIFE_CONTROL CHAR (57)

_LA:SERIAL_GENERATION_TYPE CHAR (71)

_LA:SOURCE_TYPE CHAR (55)

_LA:RESTRICT_SUBINV_FLAG CHAR (85)

_LA:RESTRICT_LOCATORS_FLAG CHAR (74)

_LA:LOCATOR_CONTROL CHAR (69)

_LA:PLANNING_TIME_FENCE_TYPE CHAR (66)

_LA:DEMAND_TIME_FENCE_TYPE CHAR (65)

_LA:CALCULATE_ATP_FLAG CHAR (56)

_LA:PEGGING_FLAG CHAR (59)

_LA:REPETITIVE_PLANNING_FLAG CHAR (58)

_LA:BOM_ITEM_TYPE CHAR (54)

_LA:PICK_COMPONENTS_FLAG CHAR (54)

_LA:ASSEMBLE_TO_ORDER_FLAG CHAR (57)

_LA:ATP_COMPONENTS_FLAG CHAR (53)

_LA:CHECK_ATP_FLAG CHAR (42)

_LA:SUPPLY_TYPE CHAR (53)

_LA:UOM_CONVERSION_OPTION CHAR (72)

_LA:INCLUDE_IN_ROLLUP_FLAG CHAR (64)

_LA:INV_PLANNING_METHOD CHAR (72)

_LA:MAKE_OR_BUY_FLAG CHAR (71)

_LA:ROUND_ORDER_QTY_FLAG CHAR (61)

_LA:SAFETY_STOCK_METHOD CHAR (70)

_LA:RESERVABLE_FLAG CHAR (66)

_LA:SERVICE_WARRANTY_FLAG CHAR (54)

_LA:SERVICEABLE_PRODUCT_FLAG CHAR (58)

_LA:BILLING_TYPE CHAR (74)

_LA:INVOICEABLE_ITEM_FLAG CHAR (55)

_LA:INVOICE_ENABLED_FLAG CHAR (54)

_LA:APPROVED_SUPPLIER_FLAG CHAR (63)

_LA:OUTSIDE_PROCESSING_FLAG CHAR (56)

_LA:OUTSIDE_PROCESSING_UNIT CHAR (88)

_LA:REDUCE_MPS_EVENT CHAR (62)

_LA:COSTING_ENABLED_FLAG CHAR (54)

_LA:CYCLE_COUNT_ENABLED_FLAG CHAR (58)

_LA:SHIP_MODEL_COMPLETE_FLAG CHAR (58)

_LA:PLANNING_METHOD CHAR (62)

_LA:RMA_INSPECTION_REQD_FLAG CHAR (78)

_LA:FORECAST_CONTROL_TYPE CHAR (72)

_LA:RELEASE_TIME_FENCE_TYPE CHAR (73)

_LA:CONTAINER_FLAG CHAR (53)

_LA:VEHICLE_FLAG CHAR (51)

CONTAINER_TYPE_CODE VARCHAR2 (30)

ITEM_TYPE VARCHAR2 (30)

INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
BUYER_ID NUMBER (9)

ACCOUNTING_RULE_ID NUMBER


INVOICING_RULE_ID NUMBER


ITEM_CATALOG_GROUP_ID NUMBER


DEFAULT_SHIPPING_ORG NUMBER


HAZARD_CLASS_ID NUMBER


UN_NUMBER_ID NUMBER


ASSET_CATEGORY_ID NUMBER


RECEIVING_ROUTING_ID NUMBER


SOURCE_ORGANIZATION_ID NUMBER


EXPENSE_ACCOUNT NUMBER


ENCUMBRANCE_ACCOUNT NUMBER


BASE_ITEM_ID NUMBER


WIP_SUPPLY_LOCATOR_ID NUMBER


COST_OF_SALES_ACCOUNT NUMBER


SALES_ACCOUNT NUMBER


ATP_RULE_ID NUMBER


PICKING_RULE_ID NUMBER


ENGINEERING_ITEM_ID NUMBER


PAYMENT_TERMS_ID NUMBER


COVERAGE_SCHEDULE_ID NUMBER


PRODUCT_FAMILY_ITEM_ID NUMBER


LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATED_DATE DATE
Yes
CREATED_BY NUMBER
Yes
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.INVBV_ORGANIZATION_ITEMS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS

APPS.INVBV_ORGANIZATION_ITEMS is not referenced by any database object