[Home] [Help]
View: AR_PERIODS_V
Product: | AR - Receivables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
APPS.AR_PERIODS_V
|
View Text
SELECT PST.PERIOD_NAME
, PST.PERIOD_YEAR
, PST.PERIOD_NUM
, PST.START_DATE
, PST.END_DATE
FROM GL_PERIOD_STATUSES PST
, AR_SYSTEM_PARAMETERS SP
WHERE PST.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
AND PST.APPLICATION_ID = 222
AND PST.CLOSING_STATUS != 'N'
AND PST.ADJUSTMENT_PERIOD_FLAG != 'Y'
Columns
Name |
PERIOD |
PERIOD_YEAR |
PERIOD_NUM |
START_DATE |
END_DATE |