APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 53: FROM mtl_system_items_kfv

49: -- get item name
50: --
51: SELECT concatenated_segments
52: INTO l_item_number
53: FROM mtl_system_items_kfv
54: WHERE inventory_item_id = p_inventory_item_id
55: AND organization_id = p_organization_id;
56: --
57: -- get organiation name

Line 327: FROM mtl_system_items_kfv item -- changed for Business Event Enh.

323: inventory_item_status_code,
324: item_catalog_group_id,
325: description,
326: concatenated_segments
327: FROM mtl_system_items_kfv item -- changed for Business Event Enh.
328: WHERE inventory_item_id = cp_item_id
329: AND EXISTS
330: (SELECT P2.ORGANIZATION_ID
331: FROM MTL_PARAMETERS P1,

Line 685: FROM mtl_system_items_kfv

681: current_phase_id,
682: inventory_item_status_code,
683: concatenated_segments, --added for business events.
684: description
685: FROM mtl_system_items_kfv
686: WHERE inventory_item_id = cp_item_id;
687:
688: CURSOR c_get_revisions(cp_org_id NUMBER,
689: cp_item_id NUMBER) IS

Line 733: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;

729: --Start 4105841
730: l_msg_data VARCHAR2(4000);
731: l_event_ret_status VARCHAR2(1);
732: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
733: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
734: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
735: -- End 4105841
736: BEGIN
737: l_api_name := 'Change_Item_Catalog';

Line 734: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;

730: l_msg_data VARCHAR2(4000);
731: l_event_ret_status VARCHAR2(1);
732: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
733: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
734: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
735: -- End 4105841
736: BEGIN
737: l_api_name := 'Change_Item_Catalog';
738: code_debug(l_api_name||': Started ');

Line 878: FROM mtl_system_items_kfv

874: WHERE ORGANIZATION_ID = p_organization_id;
875: --Added for Bug 4586769
876: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
877: INTO l_item_number, l_item_desc
878: FROM mtl_system_items_kfv
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881:
882: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(