APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 193: FROM mtl_system_items_kfv

189: -- get item name
190: --
191: SELECT concatenated_segments
192: INTO l_item_number
193: FROM mtl_system_items_kfv
194: WHERE inventory_item_id = p_inventory_item_id
195: AND organization_id = l_organization_id;
196: --
197: -- get organiation name

Line 448: FROM MTL_SYSTEM_ITEMS_KFV MSI,

444: SELECT MSI.organization_id,
445: MSI.description,
446: MSI.concatenated_segments,
447: MP.ORGANIZATION_CODE
448: FROM MTL_SYSTEM_ITEMS_KFV MSI,
449: MTL_PARAMETERS MP
450: WHERE
451: MSI.INVENTORY_ITEM_ID = p_inventory_item_id
452: AND MSI.ORGANIZATION_ID = p_organization_id

Line 1069: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1065: l_lifecycle_id_itm mtl_pending_item_status.lifecycle_id%TYPE;
1066: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1067: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1068: l_pending_rec_count NUMBER;
1069: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1070: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;
1071: l_dummy_char VARCHAR2(32767);
1072: l_approval_status mtl_system_items_b.approval_status%TYPE;
1073: l_priv_name_to_check VARCHAR2(100);

Line 1194: FROM MTL_SYSTEM_ITEMS_KFV

1190: IF NVL(l_approval_status,'A') <> 'A' THEN
1191: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_READY_FOR_CHANGE');
1192: SELECT CONCATENATED_SEGMENTS
1193: INTO l_dummy_char
1194: FROM MTL_SYSTEM_ITEMS_KFV
1195: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1196: AND ORGANIZATION_ID = p_organization_id;
1197: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);
1198: SELECT name