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