[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 |
APPS.PA_XLA_BC_BUDGET_TXN_V