关于职位层级的查询:
SELECT
PPXA.FULL_NAME "PERSON NAME"
,POSA.NAME "POSITION"
,PCF.CONTROL_FUNCTION_NAME "DOCUMENT TYPE"
,PCGA.CONTROL_GROUP_NAME "APPROVAQL GROUP NAME"
,PCR.OBJECT_CODE "OBJECT TYPE"
,PCR.AMOUNT_LIMIT "APPROVAL LIMIT"
,PPXB.FULL_NAME "SUPERVISOR NAME"
,POSB.NAME "SUPERVISOR POSITION"
,PPS.NAME "HIERRACHY NAME"
FROM
apps.PO_POSITION_CONTROLS_ALL PPCA
,apps.PO_CONTROL_RULES PCR
,apps.PO_CONTROL_GROUPS_ALL PCGA
,apps.PO_CONTROL_FUNCTIONS PCF
,apps.PER_ASSIGNMENTS_X PAXA
,apps.PER_POSITIONS POSA
,apps.PER_PEOPLE_X PPXA
,apps.PER_ASSIGNMENTS_X PAXB
,apps.PER_POSITIONS POSB
,apps.PER_PEOPLE_X PPXB
,apps.PER_POS_STRUCTURE_ELEMENTS PSV
,apps.PER_POSITION_STRUCTURES PPS
WHERE PPXA.PERSON_ID = PAXA.PERSON_ID
AND PAXA.POSITION_ID = POSA.POSITION_ID
AND PPCA.POSITION_ID(+) = POSA.POSITION_ID
AND PPCA.CONTROL_GROUP_ID = PCGA.CONTROL_GROUP_ID(+)
AND PPCA.CONTROL_FUNCTION_ID = PCF.CONTROL_FUNCTION_ID(+)
AND PPCA.CONTROL_GROUP_ID = PCR.CONTROL_GROUP_ID(+)
AND PSV.SUBORDINATE_POSITION_ID =POSA.POSITION_ID
AND PSV.PARENT_POSITION_ID = POSB.POSITION_ID(+)
AND PAXB.POSITION_ID(+) = POSB.POSITION_ID
AND PPXB.PERSON_ID (+) = PAXB.PERSON_ID
AND PPS.POSITION_STRUCTURE_ID= PSV.POS_STRUCTURE_VERSION_ID
AND PPXA.FULL_NAME LIKE '%Ping, Mr. Fuu%';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24838271/viewspace-702885/,如需转载,请注明出处,否则将追究法律责任。