[Home] [Help] [Dependency Information]
Object Name: | INVBV_ORGANIZATION_ITEMS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.INVBV_ORGANIZATION_ITEMS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows definitions for inventory items, engineering items, and purchasing items in the master organization.
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 |
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;
APPS.INVBV_ORGANIZATION_ITEMS is not referenced by any database object
|
|
|