How many types of Inventory Controls:

Four Types of controls are there.

Serial Control.

Lot Control.

Stock Locators

Revision Control.

Consigned Inventory (CI):

Consigned Inventory is used to manage at the third party location, supplier places inventory in customer’ stores or warehouse and allows them to sell or consume it. Customer purchases the stock only after he sells the stock or consumes it.

Vendor Managed Inventory (VMI)

Vendor is responsible for maintain the stock levels.

What are Restrict Sub inventories and Restrict Locators?

Restrict Sub inventories: By using this can restrict item’s to specific sub inventory.

Restrict Locators: By using this can restrict item’s to specific sub inventory under specific locator.

What is the difference between Expense Item and Asset Item?

Expense Item	Asset Item
Costing flag is not enabled	Costing flag should be enabled
Inventory Item flag not enabled	Inventory item flag should be enabled

query to find the price list name for item

select qph.name
, msi.segment1
,qpl.operand
,qpl.product_precedence
from qp_list_headers qph,
apps.qp_list_lines_v qpl,
inv.mtl_system_items_b msi
 where qph.list_header_id = qpl.list_header_id
and qpl.product_attr_value = to_char(msi.inventory_item_id)
and msi.ORGANIZATION_ID =104
and msi.segment1 ='GT2/001244F';

Item Container Relationship Query

SELECT      ood.organization_code,
            msi.segment1,
            flv.MEANING WEIGHT_UOM_CODE,
            msi.UNIT_WEIGHT,
            msi.VOLUME_UOM_CODE,
            msi.UNIT_VOLUME,
            msi.DIMENSION_UOM_CODE,
            msi.UNIT_LENGTH,
            msi.UNIT_WIDTH,
            msi.UNIT_HEIGHT,
            msi.CONTAINER_ITEM_FLAG,
            msi.CONTAINER_TYPE_CODE,
            msic.segment1 CONTAINER_ITEM,
            msic.CONTAINER_TYPE_CODE CONTAINER_ITEM_TYPE,
            msi.segment1 LOAD_ITEM,
            msi.description LOAD_ITEM_DESCERIPTION,
            msi.primary_uom_code LOAD_ITEM_UOM,
            wc.MAX_LOAD_QUANTITY,
            wc.PREFERRED_FLAG
 FROM    mtl_system_items_vl msi,
         fnd_lookup_values flv,
         org_organization_definitions ood,
         mtl_system_items_vl msic,
         WSH_CONTAINER_ITEMS wc
 WHERE   msi.organization_id = ood.organization_id
         and msi.WEIGHT_UOM_CODE = flv.LOOKUP_CODE(+)
         and flv.lookup_type = 'UNIT'
         and flv.language=USERENV('LANG') 
         and msi.inventory_item_id = wc.LOAD_ITEM_ID
         and msi.organization_id = wc.MASTER_ORGANIZATION_ID
         and msic.inventory_item_id = wc.CONTAINER_ITEM_ID
         and msic.organization_id = wc.MASTER_ORGANIZATION_ID
         and msi.segment1 ='08260054'
         --and msic.segment1 ='01001698'
         and ood.organization_code = 'E01'