[Home] [Help]
View: PQH_WORKSHEET_ORGANIZATIONS_V
View Text
SELECT ORGANIZATION_ID_CHILD
, ORGANIZATION_ID_PARENT
, ORG_STRUCTURE_VERSION_ID
FROM PER_ORG_STRUCTURE_ELEMENTS
WHERE PQH_BUDGET.ALREADY_DELEGATED_ORG(ORGANIZATION_ID_CHILD) = 'FALSE'
AND PQH_BUDGET.ALREADY_DELEGATED_ORG(ORGANIZATION_ID_PARENT) = 'FALSE'
Columns
Name |
ORGANIZATION_ID_CHILD |
ORGANIZATION_ID_PARENT |
ORG_STRUCTURE_VERSION_ID |