Query for PPM Project Status #PPM #Projects

 Hi,

In this post let's see how to fetch Project Status in Oracle Fusion.


Tables used:

PJF_PROJECTS_ALL_VL

PJF_PROJECT_STATUSES_TL


Query:

Select PPST.PROJECT_STATUS_NAME


from

PJF_PROJECTS_ALL_VL PPAV

PJF_PROJECT_STATUSES_TL PPST


where 1=1

AND PPST.LANGUAGE=USERENV('LANG')

AND PPA.PROJECT_STATUS_CODE=PPST.PROJECT_STATUS_CODE




No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Add Barcode in oracle fusion Reports

 Hi Everyone, In this post let us see how to add Barcode in Oracle Fusion RTF Templates and setups to be done to reflect in the report outpu...