View: PER_ORG_STRUCTURES_LOV

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_ORG_STRUCTURES_LOV

View Text

SELECT PS.BUSINESS_GROUP_ID
, PS.ORGANIZATION_STRUCTURE_ID
, PS.NAME
, PS.PRIMARY_STRUCTURE_FLAG
, MEANING
, OSV.ORG_STRUCTURE_VERSION_ID
, OSV.DATE_FROM
, NVL(OSV.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY')) DATE_TO
, PS.POSITION_CONTROL_STRUCTURE_FLG
FROM PER_ORGANIZATION_STRUCTURES PS
, PER_ORG_STRUCTURE_VERSIONS OSV
, FND_LOOKUPS FL
WHERE PS.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID
AND PS.PRIMARY_STRUCTURE_FLAG = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'

Columns