APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 906: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;

902: --------------------------------------------------------------------------
903: l_event_return_status VARCHAR2(1) ;
904: l_msg_data VARCHAR2(2000);
905: l_org_code_rec c_get_org_code%ROWTYPE;
906: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
907: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
908: ----------------------------------------------------------------
909: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
910: l_cat_tab_index NUMBER := G_MISS_NUM ;

Line 907: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;

903: l_event_return_status VARCHAR2(1) ;
904: l_msg_data VARCHAR2(2000);
905: l_org_code_rec c_get_org_code%ROWTYPE;
906: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
907: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
908: ----------------------------------------------------------------
909: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
910: l_cat_tab_index NUMBER := G_MISS_NUM ;
911: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;

Line 1613: FROM MTL_SYSTEM_ITEMS_KFV

1609: OR l_item_rec_in.DESCRIPTION = G_MISS_CHAR
1610: OR trim(l_Item_rec_in.ITEM_NUMBER) IS NULL) THEN
1611: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
1612: INTO l_item_number, l_item_desc
1613: FROM MTL_SYSTEM_ITEMS_KFV
1614: WHERE inventory_item_id = l_Item_rec_in.INVENTORY_ITEM_ID
1615: AND organization_id = l_Item_rec_in.ORGANIZATION_ID;
1616: ELSE
1617: l_item_desc := l_item_rec_in.DESCRIPTION;

Line 2436: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

2432: DECLARE
2433:
2434: l_error_message_name VARCHAR2(30);
2435: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
2436: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2437:
2438: BEGIN
2439:
2440: IF (l_return_status = 'F') THEN

Line 2448: FROM MTL_SYSTEM_ITEMS_KFV

2444: END IF;
2445:
2446: SELECT CONCATENATED_SEGMENTS
2447: INTO l_item_number
2448: FROM MTL_SYSTEM_ITEMS_KFV
2449: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2450: AND ORGANIZATION_ID = p_organization_id;
2451:
2452: SELECT ORGANIZATION_CODE