DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on MTL_SYSTEM_ITEMS_KFV

Line 599: FROM mtl_system_items_kfv msi,

595:
596: if (l_item_id is null) and (l_item is not null) then
597: SELECT min(msi.inventory_item_id)
598: INTO l_item_id
599: FROM mtl_system_items_kfv msi,
600: mtl_item_categories mic
601: WHERE msi.CONCATENATED_SEGMENTS = l_item
602: AND msi.organization_id = x_organization_id
603: AND msi.inventory_item_id = mic.inventory_item_id

Line 1422: mtl_system_items_kfv item,

1418: FROM poa_cm_evaluation pce,
1419: hr_operating_units hr,
1420: fnd_user fu,
1421: mtl_categories_kfv cat,
1422: mtl_system_items_kfv item,
1423: po_vendor_sites pvs
1424: WHERE pce.supplier_id = l_supplier_id
1425: AND pce.period_type = l_period_type
1426: AND pce.period_name = l_period_name

Line 1450: mtl_system_items_kfv item,

1446: FROM poa_cm_evaluation pce,
1447: hr_operating_units hr,
1448: fnd_user fu,
1449: mtl_categories_kfv cat,
1450: mtl_system_items_kfv item,
1451: po_vendor_sites pvs
1452: WHERE pce.supplier_id = l_supplier_id
1453: AND pce.period_type = l_period_type
1454: AND pce.period_name = l_period_name

Line 1478: mtl_system_items_kfv item,

1474: FROM poa_cm_evaluation pce,
1475: hr_operating_units hr,
1476: fnd_user fu,
1477: mtl_categories_kfv cat,
1478: mtl_system_items_kfv item,
1479: po_vendor_sites pvs
1480: WHERE pce.supplier_id = l_supplier_id
1481: AND pce.period_type = l_period_type
1482: AND pce.period_name = l_period_name

Line 1507: mtl_system_items_kfv item,

1503: FROM poa_cm_evaluation pce,
1504: hr_operating_units hr,
1505: fnd_user fu,
1506: mtl_categories_kfv cat,
1507: mtl_system_items_kfv item,
1508: po_vendor_sites pvs
1509: WHERE pce.supplier_id = l_supplier_id
1510: AND pce.period_type = l_period_type
1511: AND pce.period_name = l_period_name