APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on MTL_SYSTEM_ITEMS

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(+)

Line 1724: mtl_system_items_vl mtl

1720: schm.requested_date,
1721: schm.requested_quantity,
1722: mtl.concatenated_segments
1723: FROM ahl_schedule_materials schm,
1724: mtl_system_items_vl mtl
1725: WHERE schm.inventory_item_id = mtl.inventory_item_id
1726: AND schm.organization_id = mtl.organization_id
1727: --SKPATHAK :: Bug 8429732 :: 17-APR-2009
1728: --Commented out the condition (requested_quantity <> 0)

Line 1944: SELECT NVL(ATP_FLAG, 'N') from mtl_system_items

1940: FROM MRP_AP_APPS_INSTANCES;
1941:
1942: -- Cursor added by surrkuma on 14-JUL-2010 for the bug 9901811
1943: CURSOR Get_Item_ATP_Flag(c_item_id IN NUMBER, c_org_id IN NUMBER) IS
1944: SELECT NVL(ATP_FLAG, 'N') from mtl_system_items
1945: WHERE INVENTORY_ITEM_ID = c_item_id
1946: AND ORGANIZATION_ID = c_org_id;
1947:
1948: --Standard local variables