[Home] [Help]
View: PA_XLA_BC_BUDGET_TXN_V
View Text
SELECT (PP.NAME||' ( '||PP.SEGMENT1|| ' )')
, PBV.PROJECT_ID
, PBV.VERSION_NUMBER
, PBV.BUDGET_VERSION_ID
, PBV.BUDGET_TYPE_CODE
, BTYPE.BUDGET_TYPE
, PP.ORG_ID
, BTYPE.BUDGET_AMOUNT_CODE
, PBV.VERSION_NAME
FROM PA_BUDGET_VERSIONS PBV
, PA_BUDGET_TYPES BTYPE
, PA_PROJECTS_ALL PP
WHERE PBV.PROJECT_ID = PP.PROJECT_ID
AND BTYPE.BUDGET_TYPE_CODE = PBV.BUDGET_TYPE_CODE
AND PBV.PROJECT_ID = PP.PROJECT_ID
Columns
Name |
PROJECT_NAME_NUM_CONCAT |
PROJECT_ID |
BUDGET_VERSION_NUMBER |
BUDGET_VERSION_ID |
BUDGET_TYPE_CODE |
BUDGET_TYPE |
PROJ_ORG_ID |
BUDGET_AMOUNT_CODE |
BUDGET_VERSION_NAME |