APPS.POA_CM_EVAL_SCORES_ICX dependencies on PO_VENDOR_SITES

Line 517: FROM PO_VENDOR_SITES

513: if (l_supplier_site_id is null) AND (l_site_name is not null) then
514:
515: SELECT min(vendor_site_id)
516: INTO l_supplier_site_id
517: FROM PO_VENDOR_SITES
518: WHERE VENDOR_SITE_CODE = l_site_name
519: AND VENDOR_ID = nvl(l_supplier_id,-1);
520:
521: if l_supplier_site_id is null then

Line 543: SELECT '1' FROM PO_VENDOR_SITES_ALL WHERE

539: SELECT min(organization_id)
540: INTO l_oper_unit_id
541: FROM HR_OPERATING_UNITS
542: WHERE name = l_operating_unit AND EXISTS (
543: SELECT '1' FROM PO_VENDOR_SITES_ALL WHERE
544: vendor_site_id = nvl(l_supplier_site_id, vendor_site_id));
545:
546: if l_oper_unit_id is null then
547: reload_header(l_header, 'Invalid Operating Unit');

Line 1423: po_vendor_sites pvs

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
1427: AND hr.organization_id (+)= pce.oper_unit_id

Line 1451: po_vendor_sites pvs

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
1455: AND hr.organization_id (+)= pce.oper_unit_id

Line 1479: po_vendor_sites pvs

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
1483: AND hr.organization_id (+)= pce.oper_unit_id

Line 1508: po_vendor_sites pvs

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
1512: AND hr.organization_id (+)= pce.oper_unit_id