View: PA_BUDGETARY_CONTROL_OPTIONS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_BUDGETARY_CONTROL_OPTIONS_V

View Text

SELECT OPT.ROWID ROW_ID
, OPT.PROJECT_TYPE
, OPT.PROJECT_ID
, OPT.BALANCE_TYPE
, OPT.EXTERNAL_BUDGET_CODE
, OPT.GL_BUDGET_VERSION_ID
, OPT.ENCUMBRANCE_TYPE_ID
, OPT.BDGT_CNTRL_FLAG
, OPT.AMOUNT_TYPE
, OPT.BOUNDARY_CODE
, OPT.FUND_CONTROL_LEVEL_PROJECT
, OPT.FUND_CONTROL_LEVEL_TASK
, OPT.FUND_CONTROL_LEVEL_RES_GRP
, OPT.FUND_CONTROL_LEVEL_RES
, OPT.BUDGET_TYPE_CODE
, OPT.PROJECT_TYPE_ORG_ID
, OPT.LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY
, OPT.CREATION_DATE
, OPT.CREATED_BY
, OPT.LAST_UPDATE_LOGIN
FROM PA_BUDGETARY_CONTROL_OPTIONS OPT
, PA_IMPLEMENTATIONS IMP
WHERE NVL(OPT.PROJECT_TYPE_ORG_ID
, -99) = NVL(IMP.ORG_ID
, -99)

Columns