[Home] [Help]
View: 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
Name |
BUSINESS_GROUP_ID |
ORGANIZATION_STRUCTURE_ID |
NAME |
PRIMARY_STRUCTURE_FLAG |
MEANING |
ORG_STRUCTURE_VERSION_ID |
DATE_FROM |
DATE_TO |
POSITION_CONTROL_STRUCTURE_FLG |