DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 4629: FROM MTL_SYSTEM_ITEMS_B_KFV

4625: BEGIN
4626: IF p_inventory_item_id IS NULL THEN
4627: IF p_item_number IS NOT NULL THEN
4628: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4629: FROM MTL_SYSTEM_ITEMS_B_KFV
4630: WHERE ORGANIZATION_ID = l_organization_id
4631: AND CONCATENATED_SEGMENTS = p_item_number;
4632: ELSE
4633: RAISE INVALID_ITEM;

Line 4637: FROM MTL_SYSTEM_ITEMS_B_KFV

4633: RAISE INVALID_ITEM;
4634: END IF;
4635: ELSE
4636: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4637: FROM MTL_SYSTEM_ITEMS_B_KFV
4638: WHERE ORGANIZATION_ID = l_organization_id
4639: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4640: END IF;
4641: