DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4381: FROM MTL_SYSTEM_ITEMS_B_KFV

4377: BEGIN
4378: IF p_inventory_item_id IS NULL THEN
4379: IF p_item_number IS NOT NULL THEN
4380: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4381: FROM MTL_SYSTEM_ITEMS_B_KFV
4382: WHERE ORGANIZATION_ID = l_organization_id
4383: AND CONCATENATED_SEGMENTS = p_item_number;
4384: ELSE
4385: RAISE INVALID_ITEM;

Line 4389: FROM MTL_SYSTEM_ITEMS_B_KFV

4385: RAISE INVALID_ITEM;
4386: END IF;
4387: ELSE
4388: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4389: FROM MTL_SYSTEM_ITEMS_B_KFV
4390: WHERE ORGANIZATION_ID = l_organization_id
4391: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4392: END IF;
4393: