PlanVersionStatus and corresponding values PJO_PLAN_VERSIONS_B.PLAN_STATUS_CODE
Summary:
PlanVersionStatus and corresponding values PJO_PLAN_VERSIONS_B.PLAN_STATUS_CODE
Content (please ensure you mask any confidential information):
In rest api - /fscmRestApi/resources/11.13.18.05/projectBudgets/{PlanVersionId}
we get value for attribute PlanVersionStatus.
There is a column PLAN_STATUS_CODE in table PJO_PLAN_VERSIONS_B.
My questions are -
1) what are the different possible values for the attribute PlanVersionStatus? What are the corresponding values for PJO_PLAN_VERSIONS_B.PLAN_STATUS_CODE ?
2) in which base table oracle stores relationship between attribute PlanVersionStatus and column PJO_PLAN_VERSIONS_B.PLAN_STATUS_CODE?
I need this information for custom reporting requirements.