DBA Data[Home] [Help]

APPS.INV_ITEM_API dependencies on MTL_SYSTEM_ITEMS_B

Line 430: MTL_SYSTEM_ITEMS_B MSI

426: ,MSI.DEFAULT_MATERIAL_STATUS_ID
427: -- Serial_Tagging Enh -- bug 9913552
428: ,MSI.SERIAL_TAGGING_FLAG
429: FROM
430: MTL_SYSTEM_ITEMS_B MSI
431: , MTL_PARAMETERS MP1
432: WHERE
433: INVENTORY_ITEM_ID = p_Item_ID
434: AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 585: UPDATE MTL_SYSTEM_ITEMS_B

581: INTO l_Primary_Unit_of_Measure
582: FROM mtl_units_of_measure_vl
583: WHERE uom_code = P_Item_Rec.PRIMARY_UOM_CODE;
584:
585: UPDATE MTL_SYSTEM_ITEMS_B
586: SET
587: -- Update DESCRIPTION in the base table (MSI_B) only
588: -- if current language is the base language.
589: --