DBA Data[Home] [Help]

VIEW: APPS.GL_PERIOD_NAMES_ALL_V

Source

View Text - Preformatted

SELECT glps.period_name, glps.start_date, glps.application_id, glps.ledger_id, glps.ledger_id set_of_books_id, glps.closing_status, glps.end_date FROM gl_period_statuses glps, financials_system_parameters fsp WHERE glps.ledger_id = fsp.set_of_books_id
View Text - HTML Formatted

SELECT GLPS.PERIOD_NAME
, GLPS.START_DATE
, GLPS.APPLICATION_ID
, GLPS.LEDGER_ID
, GLPS.LEDGER_ID SET_OF_BOOKS_ID
, GLPS.CLOSING_STATUS
, GLPS.END_DATE
FROM GL_PERIOD_STATUSES GLPS
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE GLPS.LEDGER_ID = FSP.SET_OF_BOOKS_ID