SELECT template_name,
(SELECT name
FROM apps.hr_organization_units ood
WHERE ood.organization_id = pnta.org_id) OU_NAME,
currency_code,
unit_of_measure_code
FROM apps.por_noncat_templates_all_vl pnta
WHERE template_name <> 'New'
(SELECT name
FROM apps.hr_organization_units ood
WHERE ood.organization_id = pnta.org_id) OU_NAME,
currency_code,
unit_of_measure_code
FROM apps.por_noncat_templates_all_vl pnta
WHERE template_name <> 'New'
Comments
Post a Comment