GA Grant Reference Information (SQL Script)

Enterprise Resource Planning (ERP) Grants Accounting (GMS)
1

This GA grant reference information query retrieves grant award information by organization, including status and dates, to support monitoring and management.

#sqlquery

SELECT
--SQL4Fusion (An Orbit Analytics Project)
--This query lists award details by organization for grant tracking.
  HAOUT.NAME                       ORGANIZATION_NAME,
  GACV.CONTRACT_NUMBER             AWARD_NUMBER,
  GACV.CONTRACT_NAME			   AWARD_NAME,
  GACV.START_DATE				   AWARD_START_DATE,
  GACV.END_DATE					   AWARD_END_DATE,
  GACV.STS_CODE					   STATUS_CODE,
  GACV.AWARD_PURPOSE_CODE		   AWARD_PURPOSE,
  GACV.AWARD_TYPE				   AWARD_TYPE
FROM
  GMS_AWARD_CONTRACT_V GACV,
  HR_ALL_ORGANIZATION_UNITS_TL HAOUT
WHERE
  1 = 1
  AND HAOUT.ORGANIZATION_ID = GACV.ORG_ID
  AND HAOUT.LANGUAGE = USERENV('LANG')