DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4913: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;

4909: --===========================================================================
4910: PROCEDURE Get_Inventory_Item_Number(p_inventory_item_id IN NUMBER,
4911: p_item_master_org_id IN NUMBER, --yao zhang changed fix bug 7829039
4912: x_inventory_item_code OUT NOCOPY VARCHAR2) IS
4913: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
4914: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4915: BEGIN
4916:
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4936: FROM MTL_SYSTEM_ITEMS_B_KFV msv

4932: x_inventory_item_code := NULL;
4933: ELSE
4934: SELECT msv.concatenated_segments
4935: INTO l_inventory_item_code
4936: FROM MTL_SYSTEM_ITEMS_B_KFV msv
4937: WHERE msv.inventory_item_id = p_inventory_item_id --yao zhang changed fix bug 7829039
4938: AND msv.organization_id = p_item_master_org_id;
4939:
4940: -- begin log