DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on MTL_CATEGORIES_KFV

Line 569: FROM mtl_categories_kfv

565: if (l_category_id is null) and (l_commodity is not null) then
566:
567: SELECT min(category_id)
568: INTO l_category_id
569: FROM mtl_categories_kfv
570: WHERE CONCATENATED_SEGMENTS = l_commodity
571: AND STRUCTURE_ID = x_structure_id;
572:
573: if l_category_id is null then

Line 1421: mtl_categories_kfv cat,

1417: pce.last_update_date
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

Line 1449: mtl_categories_kfv cat,

1445: pce.last_update_date
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

Line 1477: mtl_categories_kfv cat,

1473: pce.last_update_date
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

Line 1506: mtl_categories_kfv cat,

1502: pce.last_update_date
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