APPS.INV_ORGHIERARCHY_PVT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 143: FROM per_org_structure_elements arc

139: FROM
140: (
141: (
142: SELECT organization_id_child
143: FROM per_org_structure_elements arc
144: WHERE
145: (
146: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
147: WHERE acc.organization_id = organization_id_child

Line 165: FROM per_org_structure_elements arc

161: INTERSECT
162: (
163: (
164: SELECT organization_id_child
165: FROM per_org_structure_elements arc
166: WHERE
167: (
168: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
169: WHERE acc.organization_id = organization_id_child

Line 220: per_org_structure_elements arc

216: -- full set of organizations from origin, not including origin
217: SELECT
218: organization_id_child
219: FROM
220: per_org_structure_elements arc
221: CONNECT BY
222: arc.organization_id_parent = PRIOR arc.organization_id_child
223: AND arc.org_structure_version_id = PRIOR arc.org_structure_version_id
224: START WITH

Line 280: per_org_structure_elements arc

276: -- full set of organizations from origin, not including origin
277: SELECT
278: organization_id_child
279: FROM
280: per_org_structure_elements arc
281: CONNECT BY
282: arc.organization_id_parent = PRIOR arc.organization_id_child
283: AND arc.org_structure_version_id = PRIOR arc.org_structure_version_id
284: START WITH

Line 296: per_org_structure_elements arc

292: -- security hierarchy check
293: SELECT
294: organization_id_child
295: FROM
296: per_org_structure_elements arc
297: WHERE
298: arc.org_structure_version_id = l_sec_hierarchy_version_id
299: )
300:

Line 520: per_org_structure_elements

516: CURSOR hierarchy_contains_csr IS
517: SELECT
518: organization_id_parent
519: FROM
520: per_org_structure_elements
521: WHERE
522: ( organization_id_parent = p_org_id
523: OR organization_id_child = p_org_id
524: )

Line 1303: FROM PER_ORG_STRUCTURE_ELEMENTS

1299: -- cursor to obtain the parent organization id for the organization structure
1300: -- hierarchy version when p_org_hierarchy_level is null
1301: CURSOR c_parent_organization( c_org_structure_version_id NUMBER ) IS
1302: SELECT organization_id_parent
1303: FROM PER_ORG_STRUCTURE_ELEMENTS
1304: WHERE ORG_STRUCTURE_VERSION_ID = c_org_structure_version_id
1305: AND ORGANIZATION_ID_PARENT NOT IN
1306: (SELECT ORGANIZATION_ID_CHILD
1307: FROM PER_ORG_STRUCTURE_ELEMENTS

Line 1307: FROM PER_ORG_STRUCTURE_ELEMENTS

1303: FROM PER_ORG_STRUCTURE_ELEMENTS
1304: WHERE ORG_STRUCTURE_VERSION_ID = c_org_structure_version_id
1305: AND ORGANIZATION_ID_PARENT NOT IN
1306: (SELECT ORGANIZATION_ID_CHILD
1307: FROM PER_ORG_STRUCTURE_ELEMENTS
1308: WHERE ORG_STRUCTURE_VERSION_ID = c_org_structure_version_id);
1309:
1310: -- cursor to retrieve the inventory organization hierarchy tree for a given
1311: -- structure version id and parent organization id

Line 1324: PER_ORG_STRUCTURE_ELEMENTS POE

1320: SELECT
1321: organization_id_child
1322: , level
1323: FROM
1324: PER_ORG_STRUCTURE_ELEMENTS POE
1325: CONNECT BY
1326: POE.ORGANIZATION_ID_PARENT = PRIOR POE.ORGANIZATION_ID_CHILD
1327: AND POE.ORG_STRUCTURE_VERSION_ID = PRIOR POE.ORG_STRUCTURE_VERSION_ID
1328: START WITH