AP Accounts Payables Open-Close Periods (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Payables (AP-Fusion-SQL's)
1

This AP Accounts Payables Open-Close Periods query retrieves accounts payables period status details, including period name, date range, closing status, and related ledger and operating unit information.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This query retrieves the period status details 
  GL.NAME LEDGER_NAME,
  FABU.BU_NAME ORGANIZATION_NAME,
  GPS.PERIOD_NAME,
  GPS.PERIOD_TYPE,
  GPS.PERIOD_YEAR,
  GPS.QUARTER_NUM QUARTER_NUMBER, 
  GPS.PERIOD_NUM PERIOD_NUMBER, 
  GPS.START_DATE PERIOD_START_DATE,
  GPS.END_DATE PERIOD_END_DATE, 
  GPS.CLOSING_STATUS
FROM
  GL_PERIOD_STATUSES GPS,
  GL_LEDGERS GL,
  FUN_ALL_BUSINESS_UNITS_V FABU 
WHERE
  1 = 1
  AND GPS.APPLICATION_ID = 200 --Account Payables
  AND GPS.LEDGER_ID = GL.LEDGER_ID
  AND GL.LEDGER_ID = FABU.PRIMARY_LEDGER_ID