The below is applicable for Customer Billable Contracts/Projects Using Projects in a Manufacturing Environment has its own benefits and disadvantages. But that is the subject of a different discussion topic. LoL. There is a lot of choice on how to setup accounting (based on the needs). Below is the 80% scenario that will fit most […]
Accounting for Costs/COGS: Project Manufacturing Environment Read More »
Use the below query to fetch list of Projects & key data needed by Business Analysts SELECT (SELECT name FROM HR_ORGANIZATION_UNITS_F_TL WHERE organization_id = ppp.ORG_ID AND LANGUAGE = ‘US’) Business_Unit_Name ,(SELECT name FROM pjf_projects_all_vl p1WHERE p1.project_id = ppp.created_from_project_id) Project_Template ,(SELECT project_type FROM pjf_project_types_vlWHERE project_type_id = ppp.project_type_id) Project_Type ,SEGMENT1 Project_Number ,NAME Project_Name ,DESCRIPTION Project_Description ,(SELECT
PPM SQL : Querying for Projects & Classifications Read More »
