Following query gives Operating Unit Information and corresponding Inventory Orgs related information as well.
Following query gives Operating Unit Information and corresponding Inventory Orgs related information as well.
SELECT hou.NAME operating_unit_name,
hou.short_code,
hou.organization_id operating_unit_id,
hou.set_of_books_id,
hou.business_group_id,
ood.organization_name inventory_organization_name,
ood.organization_code Inv_organization_code,
ood.organization_id Inv_organization_id,
ood.chart_of_accounts_id
FROM hr_operating_units hou,
org_organization_definitions ood
WHERE 1 = 1
AND hou.organization_id = ood.operating_unit
ORDER BY hou.organization_id ASC;
/
Following SQL query can be used to find out the exact version of the oracle applications you are currently working on.
Following SQL query can be used to find out the exact version of the oracle applications you are currently working on.
SELECT substr(a.application_short_name, 1, 5) code,
substr(t.application_name, 1, 50) application_name,
p.product_version version
FROM fnd_application a,
fnd_application_tl t,
fnd_product_installations p
WHERE a.application_id = p.application_id
AND a.application_id = t.application_id
AND t.language = USERENV('LANG');
/
No comments:
Post a Comment