/* Formatted on 5/15/2014 9:12:46 AM (QP5 v5.115.810.9015) */
SELECT DISTINCT PD.segment1 POSITION_NUMBER,
pd.segment2 POSITION_NAME,
pd.segment3 POSITION_GRADE,
(SELECT name
FROM hr_all_organization_units
WHERE ORGANIZATION_ID = pd.segment4)
org,
pd.segment4 org_id,
pd.segment5 POSITION_CODE,
po.name position,
j.name job,
po.position_id
FROM per_positions po,
per_jobs j,
hr_all_organization_units org,
PER_POSITION_DEFINITIONS PD
WHERE 1 = 1
AND po.BUSINESS_GROUP_ID = 81
AND pd.POSITION_DEFINITION_ID = po.POSITION_DEFINITION_ID
AND j.job_id = po.job_id
AND org.ORGANIZATION_ID = po.ORGANIZATION_ID
AND po.position_id = 17624
SELECT DISTINCT PD.segment1 POSITION_NUMBER,
pd.segment2 POSITION_NAME,
pd.segment3 POSITION_GRADE,
(SELECT name
FROM hr_all_organization_units
WHERE ORGANIZATION_ID = pd.segment4)
org,
pd.segment4 org_id,
pd.segment5 POSITION_CODE,
po.name position,
j.name job,
po.position_id
FROM per_positions po,
per_jobs j,
hr_all_organization_units org,
PER_POSITION_DEFINITIONS PD
WHERE 1 = 1
AND po.BUSINESS_GROUP_ID = 81
AND pd.POSITION_DEFINITION_ID = po.POSITION_DEFINITION_ID
AND j.job_id = po.job_id
AND org.ORGANIZATION_ID = po.ORGANIZATION_ID
AND po.position_id = 17624
You are awesome and appreciate your effort in writing this blog
ReplyDeletegood work
ReplyDeleteHi all, Oracle technical and fusion cloud SCM online classes, if you are interested whatsapp to this number 7382582893, thank you.
ReplyDelete