Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Proposal Statuses

SOLVED
Go to solution
Highlighted
JHarris941
Regular Collector

Proposal Statuses

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

2 REPLIES
Samit42
Member
Solution

Re: Proposal Statuses

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

 

 

JHarris941
Regular Collector

Re: Proposal Statuses

Excellent thank you sir! 

//Add this to "OnDomLoad" event