Knowledge Hub — Technical Document

Generated on 2026-08-28 08:32 | Confidential Client Asset

Query Project Lookups.sql

Published February 22, 2026 By Sai Sree Ram Gundepudi 
SELECT
	ppav.PROJECT_ID
  , ppav.NAME
  , ppav.enabled_flag
  , ppav.SEGMENT1
  , ppav.PROJECT_TYPE_ID
  , ppav.PROJECT_STATUS_CODE
  , ppav.START_DATE
  , ppav.COMPLETION_DATE
  , ptv.task_id
  , ptv.task_name
  , ptv.TASK_NUMBER
FROM
	fusion.PJF_PROJECTS_ALL_VL ppav
  , fusion.PJF_TASKS_V         ptv
WHERE
	ppav.PROJECT_ID =ptv.PROJECT_ID
ORDER BY
	ppav.NAME
  , ptv.task_id

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

More in OM
OM

Order Management Parameters.sql

-- SQL Query to obtain Order Management Parameters. SELECT qppvl.NAME , qppvl.DESCRIPTION , qppvl.PARAMETER_CODE...

 OM

Customer, SHIP_TO and BILL_TO Information on an Order.sql

-- The following SQL can be run from BI to obtain Customer information. SELECT dha.ORDER_NUMBER , dha.source_order_nu...

 OM

Billing Period Details as Shown on Sales Order Screen.sql

SELECT h.source_order_number Src_Order , h.order_number Order_Num , h.source_order_id , h.status_code ,...