[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | INVFV_ORGANIZATION_ITEMS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.INVFV_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 code | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization name |
| _KF:ITEM:INVENTORY:_CO | CHAR | (15) | Organization item name | |
| DESCRIPTION | VARCHAR2 | (240) | Item description | |
| MARKET_PRICE | NUMBER | Market value for the item | ||
| OVERRECEIPT_TOLERANCE_PERCENT | NUMBER | Maximum acceptable over-receipt percentage | ||
| LIST_PRICE | NUMBER | Unit list price for purchasing | ||
| PRICE_TOLERANCE_PERCENT | NUMBER | Maximum price percentage over the normal price range for the item | ||
| ROUNDING_FACTOR | NUMBER | Rounding factor used to determine order quantity | ||
| UNIT_OF_ISSUE | VARCHAR2 | (25) | Unit of measure used to typically issue the item from inventory | |
| ALLOWED_EARLY_RECEIPT_DAYS | NUMBER | Number of days before promise date you can receive an item without warning | ||
| ALLOWED_LATE_RECEIPT_DAYS | NUMBER | Number of days after the promise date you can receive an item without warning | ||
| INVOICE_CLOSE_TOLERANCE_PRCNT | NUMBER | Percentage tolerance used to automatically close purchase order shipments for invoicing | ||
| RECEIPT_CLOSE_TOLERANCE_PRCNT | NUMBER | Percentage tolerance used to automatically close purchase order shipments for receiving | ||
| LOT_STARTING_PREFIX | VARCHAR2 | (30) | Item level prefix for lot numbers | |
| LOT_STARTING_NUMBER | VARCHAR2 | (30) | Next auto assigned lot number | |
| SHELF_LIFE_DAYS | NUMBER | Length of shelf life days | ||
| SERIAL_STARTING_NUMBER | VARCHAR2 | (30) | Next auto assigned serial number | |
| SERIAL_STARTING_PREFIX | VARCHAR2 | (30) | Item level alpha prefix for serial numbers | |
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to source items from | |
| UNIT_WEIGHT | NUMBER | Conversion between weight unit of measure and base unit of measure | ||
| WEIGHT_UOM_CODE | VARCHAR2 | (3) | Weight unit of measure code | |
| VOLUME_UOM_CODE | VARCHAR2 | (3) | Volume unit of measure code | |
| UNIT_VOLUME | NUMBER | Conversion between volume unit of measure and base unit of measure | ||
| SHRINKAGE_RATE | NUMBER | Planned shrinkage rate | ||
| ACCEPTABLE_EARLY_DAYS | NUMBER | Number of days before which the planning process will not reschedule orders | ||
| LEAD_TIME_LOT_SIZE | NUMBER | Quantity used to compute processing, fixed and variable lead times | ||
| STANDARD_LOT_SIZE | NUMBER | Standard lot size | ||
| CUMULATIVE_MFG_LEAD_TIME | NUMBER | Cumulative manufacturing lead time | ||
| OVERRUN_PERCENT | NUMBER | MRP repetitive acceptable overrun rate | ||
| ACCEPTABLE_RATE_INCREASE | NUMBER | MRP repetitive acceptable rate increase | ||
| ACCEPTABLE_RATE_DECREASE | NUMBER | MRP repetitive acceptable rate decrease | ||
| CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | Cumulative total lead time | ||
| PLANNING_TIME_FENCE_DAYS | NUMBER | Used to calculate planning time fence | ||
| DEMAND_TIME_FENCE_DAYS | NUMBER | Used to calculate demand time fence | ||
| PLANNING_EXCEPTION_SET | VARCHAR2 | (10) | Exception control set | |
| FIXED_LEAD_TIME | NUMBER | Fixed portion of assembly's lead time | ||
| VARIABLE_LEAD_TIME | NUMBER | Variable portion of assembly's lead time | ||
| WIP_SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Source of WIP material supply | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Stocking and selling unit of measure code | |
| PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Stocking and selling unit of measure name | |
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | Material status code |
| PLANNER_CODE | VARCHAR2 | (10) | Material planner assigned to plan this item | |
| FIXED_LOT_MULTIPLIER | NUMBER | Fixed lot size multiplier | ||
| CARRYING_COST_PERCENT | NUMBER | Annual carrying cost | ||
| POSTPROCESSING_LEAD_TIME | NUMBER | Days required to receive a purchased item into inventory from the initial supplier receipt | ||
| PREPROCESSING_LEAD_TIME | NUMBER | Days you must add to purchasing or manufacturing lead time to place an order | ||
| PROCESSING_LEAD_TIME | NUMBER | Days required to procure or manufacture an item | ||
| ORDER_COST | NUMBER | Fixed cost associated with placing an order of any quantity | ||
| SAFETY_STOCK_PERCENT | NUMBER | Percent to dynamically calculate safety stock quantities for the item | ||
| MINIMUM_MIN_MAX_QUANTITY | NUMBER | Minimum minmax order quantity | ||
| MAXIMUM_MIN_MAX_QUANTITY | NUMBER | Maximum minmax order quantity | ||
| MINIMUM_ORDER_QUANTITY | NUMBER | Minimum order quantity | ||
| FIXED_ORDER_QUANTITY | NUMBER | Quantity used to modify the size of planned order quantities or repetitive daily rates | ||
| FIXED_SUPPLY_DAYS | NUMBER | Number of days used to modify the size and timing of planned order | ||
| MAXIMUM_ORDER_QUANTITY | NUMBER | Maximum order quantity | ||
| POSITIVE_MEASUREMENT_ERROR | NUMBER | Percentage error above measured quantity | ||
| NEGATIVE_MEASUREMENT_ERROR | NUMBER | Percentage error below measured quantity | ||
| ENGINEERING_CHANGE_ORDER | VARCHAR2 | (50) | Name of engineering change order | |
| ENGINEERING_DATE | DATE | Engineering implementation date | ||
| SERVICE_STARTING_DELAY_DAYS | NUMBER | Number of days after shipment of the current item service should start | ||
| SERVICE_DURATION_VALUE | NUMBER | Number to indicate how long the current service lasts | ||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | (10) | Period code for default service duration | |
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| SAFETY_STOCK_BUCKET_DAYS | NUMBER | Number of days to dynamically calculate safety stock quantities | ||
| RELEASE_TIME_FENCE_DAYS | NUMBER | Number of days within which this item should be auto released | ||
| MAXIMUM_LOAD_WEIGHT | NUMBER | Maximum load weight of a container or a vehicle that can be used for shipping sales orders | ||
| MINIMUM_FILL_PERCENT | NUMBER | Minimum fill condition under which the container or vehicle should be used | ||
| INTERNAL_VOLUME | NUMBER | Internal volume for container items used by shipping to calculate container capacity restrictions | ||
| PURCHASING_TAX_CODE | VARCHAR2 | (50) | Purchasing tax code | |
| _KF:ACCOUNT:EXPENSE:_CO | CHAR | (17) | Expense account name | |
| _KF:ACCOUNT:ENCUMBRANCE:_CO | CHAR | (17) | Encumbrance account name | |
| _KF:ITEM:BASE_MODEL:_CO | CHAR | (16) | Base model item name | |
| _KF:SUPPLY_LOCATOR_NAME:_CO | CHAR | (15) | Supply locator name | |
| _KF:ACCOUNT:COST_OF_SALE:_CO | CHAR | (17) | Cost of sales account name | |
| _KF:ACCOUNT:SALES:_CO | CHAR | (17) | Sales account name | |
| _KF:ITEM:ENGINEERING:_CO | CHAR | (16) | Engineering item name | |
| _KF:ITEM:PRODUCT_FAMILY:_CO | CHAR | (16) | Product family item name | |
| _KF:ASSET_CATEGORY:_CO | CHAR | (15) | Asset category name | |
| BUYER | VARCHAR2 | (240) | Buyer name | |
| ACCOUNTING_RULE | VARCHAR2 | (30) | Identifies special revenue recognition rules for an item | |
| INVOICING_RULE | VARCHAR2 | (30) | Determines the period in which you send an invoice when you recognize revenue over time | |
| DEFAULT_SHIPPING_ORG_CODE | VARCHAR2 | (3) | Default shipping organization code | |
| DEFAULT_SHIPPING_ORG_NAME | VARCHAR2 | (240) | Default shipping organization name | |
| HAZARD_CLASS | VARCHAR2 | (40) | Purchasing hazard class name | |
| UNITED_NATIONS_HAZARD_NUMBER | VARCHAR2 | (25) | United Nations identification number | |
| RECEIVING_ROUTING | VARCHAR2 | (80) | Default receipt routing | |
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code to source items from | |
| SOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | Name of organization to source items from | |
| ATP_RULE | VARCHAR2 | (80) | Available to promise rule to be used for this item | |
| PICKING_RULE | VARCHAR2 | (30) | Defines the order in which subinventories, locators, lots, and revisions are picked | |
| PAYMENT_TERMS | VARCHAR2 | (15) | Payment terms code | |
| SERVICE_COVERAGE | VARCHAR2 | (30) | Coverage schedule you want to associate with the current support service | |
| ITEM_TYPE_NAME | VARCHAR2 | (80) | User defined item type | |
| CONTAINER_ITEM_TYPE_NAME | VARCHAR2 | (80) | Container type for container items | |
| _LA:PURCHASED_FLAG | CHAR | (54) | Flag indicating purchasing item | |
| _LA:SHIPPABLE_FLAG | CHAR | (53) | Flag indicating shippable item | |
| _LA:CUSTOMER_ORDERED_FLAG | CHAR | (53) | Flag indicating customer orderable item | |
| _LA:INTERNAL_ORDERED_FLAG | CHAR | (53) | Flag indicating internally orderable item | |
| _LA:SUPPORT_SERVICE_FLAG | CHAR | (51) | Flag indicating service item | |
| _LA:INVENTORY_ITEM_FLAG | CHAR | (53) | Flag indicating inventory item | |
| _LA:ENGINEERING_ITEM_FLAG | CHAR | (47) | Flag indicating engineering item | |
| _LA:INV_ASSET_VALUE_FLAG | CHAR | (54) | Flag indicating if item is an inventory asset | |
| _LA:PURCHASABLE_FLAG | CHAR | (57) | Flag indicating if item is purchasable | |
| _LA:CUST_ORDERS_ENABLED_FLAG | CHAR | (61) | Flag indicating if item is customer orderable | |
| _LA:INT_ORDERS_ENABLED_FLAG | CHAR | (61) | Flag indicating if item is internally orderable | |
| _LA:OE_TRANSACTABLE_FLAG | CHAR | (54) | Sales order transactions flag | |
| _LA:TRANSACTABLE_FLAG | CHAR | (63) | Flag indicating if item is transactable | |
| _LA:STOCKABLE_FLAG | CHAR | (52) | Flag indicating if item is stockable | |
| _LA:BOM_ALLOWED_FLAG | CHAR | (50) | Can define a bill of material for the item, or assign the item as a | |
| _LA:BUILD_IN_WIP_FLAG | CHAR | (51) | Flag indicating if item can be built in WIP | |
| _LA:REVISION_CONTROL_TYPE | CHAR | (69) | Indicate whether to track inventory balances by revision | |
| _LA:CATALOG_COMPLETE_FLAG | CHAR | (53) | Indicates if all required descriptive element values have been defined | |
| _LA:RETURNABLE_FLAG | CHAR | (49) | Flag indicating if item is returnable | |
| _LA:COLLATERAL_ITEM_FLAG | CHAR | (49) | Flag indicating if item is a collateral item | |
| _LA:TAXABLE_FLAG | CHAR | (47) | Flag indicating if item is taxable | |
| _LA:OVERRECEIPT_QTY_ACTION | CHAR | (81) | Action to take if receipts exceed tolerance quantity | |
| _LA:ALLOW_DESC_UPDATE_FLAG | CHAR | (62) | Allow updates to the item description on a purchasing document line for an item | |
| _LA:INSPECTION_REQUIRED_FLAG | CHAR | (58) | Flag indicating whether inspection is required upon receipt | |
| _LA:RECEIPT_REQUIRED_FLAG | CHAR | (55) | Flag indicating if vendor receipt is required | |
| _LA:RFQ_REQUIRED_FLAG | CHAR | (51) | Flag indicating if a request for quotations is required | |
| _LA:ENFORCE_SHIP_TO_LOCATION | CHAR | (88) | Action to take if location differs from ship-to location on the purchase order | |
| _LA:SUBSTITUTE_RECEIPTS_FLAG | CHAR | (64) | Flag indicating if substitute receipts are allowed | |
| _LA:UNORDERED_RECEIPTS_FLAG | CHAR | (63) | Flag indicating if unordered receipts are allowed | |
| _LA:EXPRESS_TRANSACTION_FLAG | CHAR | (61) | Flag indicating if express delivery is allowed | |
| _LA:RECEIPT_DATE_ACTION | CHAR | (86) | Action to take if you attempt to receive an item outside the user defined range | |
| _LA:LOT_CONTROL | CHAR | (60) | Lot control code | |
| _LA:SHELF_LIFE_CONTROL | CHAR | (57) | Shelf life code | |
| _LA:SERIAL_GENERATION_TYPE | CHAR | (71) | Determines how to generate serial numbers and when to assign them to items | |
| _LA:SOURCE_TYPE | CHAR | (55) | Determines if item is replenished from inventory or a supplier | |
| _LA:RESTRICT_SUBINV_FLAG | CHAR | (85) | Flag indicating if subinventory is restricted | |
| _LA:RESTRICT_LOCATORS_FLAG | CHAR | (74) | Flag indicating if locator is restricted | |
| _LA:LOCATION_CONTROL | CHAR | (69) | Stock locator control code | |
| _LA:PLANNING_ITEM_FENCE_TYPE | CHAR | (66) | Determines when certain restrictions on planning recommendations apply | |
| _LA:DEMAND_TIME_FENCE_TYPE | CHAR | (65) | When planning ignores forecast demand and considers only sales order demand | |
| _LA:CALCULATE_ATP_FLAG | CHAR | (56) | Flag indicating if ATP must be checked when item is ordered | |
| _LA:PEGGING_TYPE | CHAR | (74) | Pegging type | |
| _LA:REPETITIVE_PLANNING_FLAG | CHAR | (58) | Flag indicating if item is to be planned as repetitive schedule | |
| _LA:BOM_ITEM_TYPE | CHAR | (54) | Determines the type of bill to create | |
| _LA:PICK_COMPONENTS_FLAG | CHAR | (54) | Flag indicating whether all shippable components should be picked or not | |
| _LA:ASSEMBLE_TO_ORDER_FLAG | CHAR | (57) | Flag indicates if item is an ATO item | |
| _LA:ATP_COMPONENTS_FLAG | CHAR | (53) | Flag indicating whether item may have components requiring ATP check | |
| _LA:CHECK_ATP_FLAG | CHAR | (42) | Flag indicating ATP must be checked when item is ordered | |
| _LA:SUPPLY_TYPE | CHAR | (53) | Determines how material is supplied, planned and costed | |
| _LA:UOM_CONVERSION_OPTION | CHAR | (72) | Determines which unit of measure conversions to use for this item | |
| _LA:INCLUDE_IN_ROLLUP_FLAG | CHAR | (64) | Flag indicating if item should be included in cost rollup | |
| _LA:INV_PLANNING_METHOD | CHAR | (72) | Method determines when item is planned | |
| _LA:MAKE_OR_BUY_FLAG | CHAR | (71) | Flag indicates whether item is planned as manufactured or purchased | |
| _LA:ROUND_ORDER_QTY_FLAG | CHAR | (61) | Indicate whether the planning process uses decimal or whole number values when calculating planned order quantities or repetitive rates | |
| _LA:SAFETY_STOCK_METHOD | CHAR | (70) | Determines how to plan use of fixed or dynamically calculated safety stock quantities | |
| _LA:RESERVABLE_FLAG | CHAR | (66) | Indicates whether you can create material reservations | |
| _LA:SERVICE_WARRANTY_FLAG | CHAR | (54) | Indicates whether service is automatically included with the current item when it is ordered | |
| _LA:SERVICEABLE_PRODUCT_FLAG | CHAR | (58) | Indicates whether the item is serviceable by other service-type items and can have service requests reported against it | |
| _LA:BILLING_TYPE | CHAR | (74) | Indicates if customer is charged for material, labor, or expense | |
| _LA:INVOICEABLE_ITEM_FLAG | CHAR | (55) | Flag indicates whether item appears on invoices | |
| _LA:INVOICE_ENABLED_FLAG | CHAR | (54) | Flag indicates whether item can be invoiced | |
| _LA:APPROVED_SUPPLIER_FLAG | CHAR | (63) | Flag indicating purchases restricted to approved supplier | |
| _LA:OUTSIDE_PROCESSING_FLAG | CHAR | (56) | Flag indicating item may appear on outside operation purchase order | |
| _LA:OUTSIDE_PROCESSING_UNIT | CHAR | (88) | Outside operation unit of measure | |
| _LA:REDUCE_MPS_EVENT | CHAR | (62) | Determines when to reduce master production schedule (MPS) quantitiesto zero | |
| _LA:COSTING_ENABLED_FLAG | CHAR | (54) | Flag indicating if cost information is maintained | |
| _LA:CYCLE_COUNT_ENABLED_FLAG | CHAR | (58) | Flag indicating if item may be cycle counted | |
| _LA:SHIP_MODEL_COMPLETE_FLAG | CHAR | (58) | Flag indicating model must be complete to ship | |
| _LA:PLANNING_METHOD | CHAR | (62) | MRP planning option | |
| _LA:RMA_INSPECTION_REQD_FLAG | CHAR | (78) | Flag indicating if RMA inspection is required | |
| _LA:FORECAST_CONTROL_TYPE | CHAR | (72) | Determines if demand is forecasted, forecasted and exploded, or notforecasted | |
| _LA:RELEASE_TIME_FENCE_TYPE | CHAR | (73) | When planned orders are released as WIP jobs or purchase requisitions | |
| _LA:CONTAINER_FLAG | CHAR | (53) | Indicates if item is a container or not | |
| _LA:VEHICLE_FLAG | CHAR | (51) | Indicates if item is a vehicle or not | |
| _DF | CHAR | (27) | Descriptive flexfield | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Item identifier | |
| INVENTORY_ITEM_SEGMENT1 | VARCHAR2 | (40) | ||
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| BUYER_ID | NUMBER | (9) | Buyer identifier | |
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule identifier | ||
| INVOICING_RULE_ID | NUMBER | Invoicing rule identifier | ||
| ITEM_CATALOG_GROUP_ID | NUMBER | Item catalog group identifier | ||
| DEFAULT_SHIPPING_ORG | NUMBER | Default shipping organization code | ||
| HAZARD_CLASS_ID | NUMBER | Hazard class identifier | ||
| UN_NUMBER_ID | NUMBER | United Nations number identifier | ||
| ASSET_CATEGORY_ID | NUMBER | Asset category identifier | ||
| RECEIVING_ROUTING_ID | NUMBER | Receiving routing identifier | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
| EXPENSE_ACCOUNT_ID | NUMBER | Expense account identifier | ||
| ENCUMBRANCE_ACCOUNT_ID | NUMBER | Encumbrance account identifier | ||
| BASE_ITEM_ID | NUMBER | Base model item identifier | ||
| WIP_SUPPLY_LOCATOR_ID | NUMBER | Supply locator identifier | ||
| COST_OF_SALES_ACCOUNT_ID | NUMBER | Cost of sales account identifier | ||
| SALES_ACCOUNT_ID | NUMBER | Sales account identifier | ||
| ATP_RULE_ID | NUMBER | ATP rule identifier | ||
| PICKING_RULE_ID | NUMBER | Picking rule identifier | ||
| ENGINEERING_ITEM_ID | NUMBER | Engineering item identifier | ||
| PAYMENT_TERMS_ID | NUMBER | Payment terms identifier | ||
| COVERAGE_SCHEDULE_ID | NUMBER | Coverage schedule identifier | ||
| PRODUCT_FAMILY_ITEM_ID | NUMBER | Product family item identifier | ||
| ITEM_TYPE | VARCHAR2 | (30) | User defined item type code | |
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | Container type code | |
| LAST_UPDATED_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATED_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_CODE
, ORGANIZATION_NAME
, _KF:ITEM:INVENTORY:_CO
, 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
, SERVICE_DURATION_PERIOD_CODE
, TAX_CODE
, SAFETY_STOCK_BUCKET_DAYS
, RELEASE_TIME_FENCE_DAYS
, MAXIMUM_LOAD_WEIGHT
, MINIMUM_FILL_PERCENT
, INTERNAL_VOLUME
, PURCHASING_TAX_CODE
, _KF:ACCOUNT:EXPENSE:_CO
, _KF:ACCOUNT:ENCUMBRANCE:_CO
, _KF:ITEM:BASE_MODEL:_CO
, _KF:SUPPLY_LOCATOR_NAME:_CO
, _KF:ACCOUNT:COST_OF_SALE:_CO
, _KF:ACCOUNT:SALES:_CO
, _KF:ITEM:ENGINEERING:_CO
, _KF:ITEM:PRODUCT_FAMILY:_CO
, _KF:ASSET_CATEGORY:_CO
, BUYER
, ACCOUNTING_RULE
, INVOICING_RULE
, DEFAULT_SHIPPING_ORG_CODE
, DEFAULT_SHIPPING_ORG_NAME
, HAZARD_CLASS
, UNITED_NATIONS_HAZARD_NUMBER
, RECEIVING_ROUTING
, SOURCE_ORGANIZATION_CODE
, SOURCE_ORGANIZATION_NAME
, ATP_RULE
, PICKING_RULE
, PAYMENT_TERMS
, SERVICE_COVERAGE
, ITEM_TYPE_NAME
, CONTAINER_ITEM_TYPE_NAME
, _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:LOCATION_CONTROL
, _LA:PLANNING_ITEM_FENCE_TYPE
, _LA:DEMAND_TIME_FENCE_TYPE
, _LA:CALCULATE_ATP_FLAG
, _LA:PEGGING_TYPE
, _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
, _DF
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_SEGMENT1
, 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_ID
, ENCUMBRANCE_ACCOUNT_ID
, BASE_ITEM_ID
, WIP_SUPPLY_LOCATOR_ID
, COST_OF_SALES_ACCOUNT_ID
, SALES_ACCOUNT_ID
, ATP_RULE_ID
, PICKING_RULE_ID
, ENGINEERING_ITEM_ID
, PAYMENT_TERMS_ID
, COVERAGE_SCHEDULE_ID
, PRODUCT_FAMILY_ITEM_ID
, ITEM_TYPE
, CONTAINER_TYPE_CODE
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
, CREATED_DATE
, CREATED_BY
FROM APPS.INVFV_ORGANIZATION_ITEMS;
APPS
CS_COVERAGES_ACTIVE_V
FA_CATEGORIES
FND_COMMON_LOOKUPS
FND_GLOBAL
- show dependent code
GL_CODE_COMBINATIONS
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
MTL_ATP_RULES
MTL_ITEM_LOCATIONS
MTL_PARAMETERS
MTL_PICKING_RULES
MTL_SYSTEM_ITEMS
PER_PEOPLE_X
PO_HAZARD_CLASSES
PO_UN_NUMBERS
RA_RULES
RA_TERMS
RCV_ROUTING_HEADERS
APPS.INVFV_ORGANIZATION_ITEMS is not referenced by any database object
|
|
|
|