SELECT PAAF.SUPERVISOR_ID MGR_ID,
PJ.JOB_ID ,
PAPF.FULL_NAME,
PJ.NAME,
PAPF.PERSON_ID PER_ID
FROM PER_PEOPLE_X PAPF,
PER_ASSIGNMENTS_X PAAF,
PER_JOBS PJ
WHERE PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAAF.JOB_ID = PJ.JOB_ID
START WITH PAPF.PERSON_ID = 57--Smith,Jonathan(MFG)
CONNECT BY PRIOR PAAF.SUPERVISOR_ID = PAPF.PERSON_ID;
--Get user's employee id(person_id)
SELECT employee_id FROM fnd_user WHERE user_name = 'MFG';
--Get PERSON_ID base on full name
SELECT * FROM per_people_x WHERE full_name LIKE '%Smith%Jonathan%'
分享到:
相关推荐
藏经阁-Embracing a hierarchy of types.pdf
This is a book about computer organization and architecture. It focuses on the function and design of the various components necessary to process information digitally. We present computing systems as...
藏经阁-Embracing a hierarchy of Types to Simplify Machine Learning.pdf
Hierarchy PRO Presets And Selections 一键操作 清晰明了的 解决你的Hierarchy 面板
Hierarchy PRO Presets And Selections v20.6层级编辑器强化工具最新版,对层级编辑器进行最大化的强化,很多功能,帮助编辑游戏对象,很多提示信息,可以选择要显示的内容,对开发帮助很大。
解决这个启动 View Hierarchy时的这个bug: hierarchy viewer unable to debug device
效果及使用方法:https://blog.csdn.net/qq_26318597/article/details/131373576 1.导入插件包 2.选中Hierarchy中的物体 3.右键选择“复制Hierarchy路径” 4.Ctrl + V 粘贴
Hierarchy PRO 2021 v2021.1u9
per we study the effect of a hierarchy of recurrent neural networks on processing time series. Here, each layer is a recurrent network which receives the hidden state of the previous layer as input. ...
to allow computers to learn from experience and understand the world in terms of a hierarchy of concepts, with each concept defined in terms of its relation to simpler concepts. By gathering knowledge...
超级高效的开发工具,比QHierarchy功能更强大,具体请参见AssetStore,商用请支持正版。
GPUmemory简介,FFT算法原理与实现
VS2010 MFC Hierarchy Chart VS2010 MFC Hierarchy Chart
IRQ hierarchy的初始化及构建过程详解
Enhanced_Hierarchy_2.0_v2.4.5.unitypackage 最新版本哦 正版
Other features include the ability to print a hard copy of file and folder comparisons, and to customize the behaviour and appearance of the application, including fonts, colours, whether the display ...
Other features include the ability to print a hard copy of file and folder comparisons, and to customize the behaviour and appearance of the application, including fonts, colours, whether the display ...
This document outlines the set of requirements and guidelines for file and directory placement under the Linux operating system according to those of the FSSTND v2.3 final (January 29, 2004) and also ...
Hierarchy viewer的运行原 的介绍