VIEW: APPS.AP_OTHER_PERIODS_PN_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))