[Home] [Help]
View: PABV_ACCOUNTING_PERIODS
View Text
SELECT PPA.PERIOD_NAME
, POU.ORGANIZATION_ID
, TL.NAME
, '_LA:STATUS:PA_LOOKUPS:CLOSING STATUS:MEANING'
, PPA.START_DATE
, PPA.END_DATE
, '_LA:CURRENT_PA_PERIOD_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
FROM PA_PERIODS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS_TL TL
, HR_ALL_ORGANIZATION_UNITS POU
WHERE PPA.ORG_ID = POU.ORGANIZATION_ID(+)
AND PPA.ORG_ID = TL.ORGANIZATION_ID(+)
AND TL.LANGUAGE = USERENV('LANG')
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
PERIOD_NAME |
ORG_ID |
ORGANIZATION_NAME |
"_LA:PERIOD_STATUS" |
START_DATE |
END_DATE |
"_LA:CURRENT_PA_PERIOD_FLAG" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |