Need a SQL query to fetch Funding source name for the project from Oracle PPM

Summary:

Need a SQL query to fetch Funding source name for the project from Oracle PPM

Content (required):

SQL query

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Few sample tables are as follows.

GMS_AWARD_FUNDINGS_VL,

GMS_FUNDING_SOURCES_B,

GMS_FUNDING_SOURCES_TL

GMS_LOOKUPS

HZ_PARTIES

HR_ORGANIZATION_UNITS_F_TL

OKC_K_HEADERS_ALL_B