VIEW: APPS.PA_BUDGETARY_CONTROL_OPTIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)