DBA Data[Home] [Help]

APPS.INV_ITEM_API dependencies on MTL_SYSTEM_ITEMS_B

Line 428: MTL_SYSTEM_ITEMS_B MSI

424: , MSI.OUTSOURCED_ASSEMBLY
425: -- Fix for Bug#6644711
426: ,MSI.DEFAULT_MATERIAL_STATUS_ID
427: FROM
428: MTL_SYSTEM_ITEMS_B MSI
429: , MTL_PARAMETERS MP1
430: WHERE
431: INVENTORY_ITEM_ID = p_Item_ID
432: AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 583: UPDATE MTL_SYSTEM_ITEMS_B

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