APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 54: FROM mtl_system_items_kfv

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

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

337: inventory_item_status_code,
338: item_catalog_group_id,
339: description,
340: concatenated_segments
341: FROM mtl_system_items_kfv item -- changed for Business Event Enh.
342: WHERE inventory_item_id = cp_item_id
343: AND EXISTS
344: (SELECT P2.ORGANIZATION_ID
345: FROM MTL_PARAMETERS P1,

Line 711: FROM mtl_system_items_kfv

707: current_phase_id,
708: inventory_item_status_code,
709: concatenated_segments, --added for business events.
710: description
711: FROM mtl_system_items_kfv
712: WHERE inventory_item_id = cp_item_id;
713:
714: CURSOR c_get_revisions(cp_org_id NUMBER,
715: cp_item_id NUMBER) IS

Line 759: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;

755: --Start 4105841
756: l_msg_data VARCHAR2(4000);
757: l_event_ret_status VARCHAR2(1);
758: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
759: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
760: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
761: -- End 4105841
762: -- start bug 13473691
763: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;

Line 760: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;

756: l_msg_data VARCHAR2(4000);
757: l_event_ret_status VARCHAR2(1);
758: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
759: l_item_number mtl_system_items_kfv.CONCATENATED_SEGMENTS%TYPE;
760: l_item_desc mtl_system_items_kfv.DESCRIPTION%TYPE;
761: -- End 4105841
762: -- start bug 13473691
763: l_user_id CONSTANT NUMBER := FND_GLOBAL.User_Id;
764: l_login_id CONSTANT NUMBER := FND_GLOBAL.Login_Id;

Line 934: FROM mtl_system_items_kfv

930: WHERE ORGANIZATION_ID = p_organization_id;
931: --Added for Bug 4586769
932: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
933: INTO l_item_number, l_item_desc
934: FROM mtl_system_items_kfv
935: WHERE inventory_item_id = p_inventory_item_id
936: AND organization_id = p_organization_id;
937:
938: EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(