APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1102: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;

1098: --------------------------------------------------------------------------
1099: l_event_return_status VARCHAR2(1) ;
1100: l_msg_data VARCHAR2(2000);
1101: l_org_code_rec c_get_org_code%ROWTYPE;
1102: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
1103: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
1104: ----------------------------------------------------------------
1105: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1106: l_cat_tab_index NUMBER := G_MISS_NUM ;

Line 1103: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;

1099: l_event_return_status VARCHAR2(1) ;
1100: l_msg_data VARCHAR2(2000);
1101: l_org_code_rec c_get_org_code%ROWTYPE;
1102: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
1103: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
1104: ----------------------------------------------------------------
1105: l_revision_id_out MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1106: l_cat_tab_index NUMBER := G_MISS_NUM ;
1107: l_cat_match VARCHAR2(1) DEFAULT FND_API.G_FALSE ;

Line 1839: FROM MTL_SYSTEM_ITEMS_KFV

1835: OR l_item_rec_in.DESCRIPTION = G_MISS_CHAR
1836: OR trim(l_Item_rec_in.ITEM_NUMBER) IS NULL) THEN
1837: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
1838: INTO l_item_number, l_item_desc
1839: FROM MTL_SYSTEM_ITEMS_KFV
1840: WHERE inventory_item_id = l_Item_rec_out.INVENTORY_ITEM_ID
1841: AND organization_id = l_Item_rec_out.ORGANIZATION_ID;
1842: ELSE
1843: l_item_desc := l_item_rec_in.DESCRIPTION;

Line 2662: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

2658: DECLARE
2659:
2660: l_error_message_name VARCHAR2(30);
2661: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
2662: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2663:
2664: BEGIN
2665:
2666: IF (l_return_status = 'F') THEN

Line 2674: FROM MTL_SYSTEM_ITEMS_KFV

2670: END IF;
2671:
2672: SELECT CONCATENATED_SEGMENTS
2673: INTO l_item_number
2674: FROM MTL_SYSTEM_ITEMS_KFV
2675: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
2676: AND ORGANIZATION_ID = p_organization_id;
2677:
2678: SELECT ORGANIZATION_CODE