DBA Data[Home] [Help]

APPS.JMF_GTA_ARTRX_PROC dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4344: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

4340: --===========================================================================
4341: PROCEDURE Get_Inventory_Item_Number(p_inventory_item_id IN NUMBER,
4342: p_item_master_org_id IN NUMBER,--yao zhang changed fix bug 7829039
4343: x_inventory_item_code OUT NOCOPY VARCHAR2) IS
4344: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
4345: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4346: BEGIN
4347:
4348: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4367: FROM MTL_SYSTEM_ITEMS_B_KFV msv

4363: x_inventory_item_code := NULL;
4364: ELSE
4365: SELECT msv.concatenated_segments
4366: INTO l_inventory_item_code
4367: FROM MTL_SYSTEM_ITEMS_B_KFV msv
4368: WHERE msv.inventory_item_id = p_inventory_item_id--yao zhang changed fix bug 7829039
4369: AND msv.organization_id = p_item_master_org_id;
4370:
4371: -- begin log