Super Contributor.. JHarris941 Super Contributor..
Super Contributor..
347 views

Proposal Statuses

Jump to solution

Hello All,

Im trying to develop a query that returns: 

Timesheets will not be able to be submitted if they are charging time to a proposal or enhancement that is Not Submitted

 

Here is what i have so far:

 

select
fmp.request_id,
fmp.proposal_name,to_char(ts.creation_date, 'MM/DD/YY HH12:MI:SSam') "TS Creation Date",
to_char(tsl.last_update_date, 'MM/DD/YY HH12:MI:SSam') "Line Creation Date"
from
tm_time_sheet_lines tsl,
kcrt_fg_pfm_proposal fmp,
tm_time_sheets ts
where tsl.work_item_id = fmp.request_id
and ts.time_sheet_id = tsl.time_sheet_id
--user id of resource--
--and ts.resource_id =
order by ts.creation_date desc;

But I can't seem to find where Proposal or Enhancements statuses are stored and to link the table.

Does anyone know where the Proposal statuses are in regards to the DB tables?

 

Thanks,

Jajcen

0 Likes
1 Solution

Accepted Solutions
Highlighted
Super Contributor.. Samit Aggarwal Super Contributor..
Super Contributor..

Re: Proposal Statuses

Jump to solution

KCrt_requests table stores the status of request . in this table we have column - status id which store the status id in which that request is . Further you can get status name by joining it with kcrt_statuses using status_id column. You can combine kcrt reuquests with kcrt_fg_pfm_proposal with reuqest exist in both table..

 

 

2 Replies
Highlighted
Super Contributor.. Samit Aggarwal Super Contributor..
Super Contributor..

Re: Proposal Statuses

Jump to solution

KCrt_requests table stores the status of request . in this table we have column - status id which store the status id in which that request is . Further you can get status name by joining it with kcrt_statuses using status_id column. You can combine kcrt reuquests with kcrt_fg_pfm_proposal with reuqest exist in both table..

 

 

Super Contributor.. JHarris941 Super Contributor..
Super Contributor..

Re: Proposal Statuses

Jump to solution

Excellent thank you sir! 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.