APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 460: FROM mtl_system_items_kfv

456: WHERE scheduled_material_id = C_SCH_MAT_ID;
457:
458: CURSOR Item_Des_cur(c_item_id IN NUMBER, c_org_id IN NUMBER) IS
459: SELECT CONCATENATED_SEGMENTS
460: FROM mtl_system_items_kfv
461: WHERE inventory_item_id = c_item_id
462: AND organization_id = c_org_id;
463:
464: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_MATERIAL_AVAL';

Line 1413: mtl_system_items_kfv avtm

1409: schm.requested_date,
1410: schm.status mat_status,
1411: avtm.CONCATENATED_SEGMENTS
1412: FROM ahl_schedule_materials schm,
1413: mtl_system_items_kfv avtm
1414: WHERE SCHM.INVENTORY_ITEM_ID = AVTM.INVENTORY_ITEM_ID
1415: AND AVTM.ORGANIZATION_ID = SCHM.ORGANIZATION_ID
1416: AND SCHM.SCHEDULED_MATERIAL_ID = c_sch_mat_id;
1417:

Line 1460: MTL_SYSTEM_ITEMS_KFV KFV,

1456: AVTL.STATUS_CODE TASK_STATUS_CODE,
1457: FLV.MEANING
1458: FROM AHL_SCHEDULE_MATERIALS ASMT,
1459: AHL_VISIT_TASKS_VL AVTL,
1460: MTL_SYSTEM_ITEMS_KFV KFV,
1461: FND_LOOKUP_VALUES_VL FLV
1462: WHERE SCHEDULED_MATERIAL_ID = c_sch_mat_id
1463: AND AVTL.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
1464: AND ASMT.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID(+)