View: GL_RECURRING_VALID_PERIODS_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_RECURRING_VALID_PERIODS_V

View Text

SELECT PS.PERIOD_NAME PERIOD_NAME
, PS.LEDGER_ID LEDGER_ID
, PS.CLOSING_STATUS CLOSING_STATUS
, PS.START_DATE START_DATE
, PS.END_DATE END_DATE
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, RB.RECURRING_BATCH_ID RECURRING_BATCH_ID
FROM GL_PERIOD_STATUSES PS
, GL_RECURRING_BATCHES RB
WHERE PS.APPLICATION_ID = 101
AND PS.CLOSING_STATUS IN ('O'
, 'F') AND EXISTS ( SELECT 'VALID HEADER EXISTS' FROM GL_RECURRING_HEADERS RH WHERE RH.RECURRING_BATCH_ID = RB.RECURRING_BATCH_ID AND ((DECODE( GREATEST( SYSDATE
, PS.START_DATE )
, SYSDATE
, LEAST( SYSDATE
, PS.END_DATE )
, PS.START_DATE ) >= NVL( RH.START_DATE_ACTIVE
, PS.START_DATE )) OR (NVL( RH.START_DATE_ACTIVE
, PS.START_DATE ) BETWEEN PS.START_DATE
AND PS.END_DATE))
AND DECODE( GREATEST( SYSDATE
, PS.START_DATE )
, SYSDATE
, LEAST( SYSDATE
, PS.END_DATE )
, PS.START_DATE ) <= NVL( RH.END_DATE_ACTIVE
, PS.END_DATE ))

Columns