View: AP_OTHER_PERIODS_PN_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_OTHER_PERIODS_PN_V

View Text

SELECT AOP.PERIOD_TYPE PERIOD_TYPE
, AOP.PERIOD_NAME PERIOD_NAME
, AOP.PERIOD_NUM PERIOD_NUM
, AOP.PERIOD_YEAR PERIOD_YEAR
, AOP.START_DATE START_DATE
, AOP.END_DATE END_DATE
, ASP.ORG_ID
FROM AP_OTHER_PERIODS AOP
, GL_PERIOD_STATUSES GPS
, AP_SYSTEM_PARAMETERS ASP
WHERE AOP.MODULE = 'RECURRING PAYMENTS'
AND AOP.APPLICATION_ID = 200
AND GPS.APPLICATION_ID = 200
AND GPS.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
AND NVL(GPS.ADJUSTMENT_PERIOD_FLAG
, 'N') = 'N'
AND AOP.END_DATE BETWEEN GPS.START_DATE
AND GPS.END_DATE
AND ((GPS.CLOSING_STATUS IN ('O'
, 'F')) OR (GPS.END_DATE >= SYSDATE))

Columns