View: PA_REP_COMP_REP_ORG_V

Product:	PA - Projects
Description:	View for reporting organization lov in competence reports
Implementation/DBA Data:	APPS.PA_REP_COMP_REP_ORG_V

View Text

SELECT ORG_HR.PARENT_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(ORG_HR.PARENT_ORGANIZATION_ID)
, ORG_HR.CHILD_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(ORG_HR.CHILD_ORGANIZATION_ID)
, DECODE(ORG_HR.PARENT_ORGANIZATION_ID
, ORG_HR.CHILD_ORGANIZATION_ID
, 'N'
, 'Y')
FROM PA_ORG_HIERARCHY_DENORM ORG_HR
, PA_IMPLEMENTATIONS IMP
WHERE ORG_HR.PA_ORG_USE_TYPE = 'REPORTING'
AND NVL(ORG_HR.ORG_ID
, -1) = NVL(IMP.ORG_ID
, -1)
AND ORG_HR.ORG_HIERARCHY_VERSION_ID = IMP.ORG_STRUCTURE_VERSION_ID

Columns