Time by Task Stage - Oracle

theWorX

The Time by Stage portlet displays time logged to each project task stage. The portlet displays the project id, project name, task stage, and charge code for each different task stage on the project. This portlet provides management with a quick view of all project task stages by project without having to navigate into each project individually.

Download Details
Submission Date Sep 5, 2012 4:36 pm
Submitter Rego
Content Type Portlet
Database Architecture Oracle
Work Type
Work Categories
Related Content
Supported Versions 12.x, 13.x, 14.x, 15.x
Special Instructions This portlet requires a new field on the task object, a new lookup, and the Investment Allocation Job to be running. The new field should include:
• Name: Task Stage ??ID: rego_task_stage
• Type: Lookup - String ??Lookup: Rego Stages
The new lookup should include the following:
• Name: Rego Stages ??ID: rego_stages
• Source: Dynamic Query
SELECT lookup_code, name, sort_order
FROM cmn_lookups_v
WHERE lookup_type = 'INV_STAGE_TYPE'
and parent_lookup_code='IT'
and LANGUAGE_CODE = @WHERE:PARAM:LANGUAGE@
@BROWSE-ONLY:AND is_active=1:BROWSE-ONLY@
Company Rego Consulting