FND Design Data [Home] [Help]

View: PSBBV_CONSTRAINT_FORMULAS

Product: PSB - Public Sector Budgeting
Description:
Implementation/DBA Data: ViewAPPS.PSBBV_CONSTRAINT_FORMULAS
View Text

SELECT CF.STEP_NUMBER
, '_LA:CF.PREFIX_OPERATOR:FND_LOOKUPS:PSB_CONSTRAINT_PREFIX_OPERATOR:MEANING'
, '_LA:CF.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, CF.CONCATENATED_SEGMENTS
, '_LA:CF.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, CF.ELEMENT_VALUE
, CF.CURRENCY_CODE
, '_LA:CF.POSTFIX_OPERATOR:FND_LOOKUPS:PSB_POSTFIX_OPERATOR:MEANING'
, CF.AMOUNT
, CF.PAY_ELEMENT_ID
, CF.PAY_ELEMENT_OPTION_ID
, CF.ALLOW_MODIFY
, CF.EFFECTIVE_START_DATE
, CF.EFFECTIVE_END_DATE
, CF.CONSTRAINT_FORMULA_ID
, CF.CONSTRAINT_ID
, CF.BUDGET_YEAR_TYPE_ID
, CF.LAST_UPDATE_DATE
, CF.LAST_UPDATED_BY
, CF.CREATED_BY
, CF.CREATION_DATE
FROM PSB_CONSTRAINT_FORMULAS CF
, PSB_BUDGET_YEAR_TYPES BYT
, PSB_ENTITY PE
WHERE CF.CONSTRAINT_ID = PE.ENTITY_ID
AND CF.BUDGET_YEAR_TYPE_ID = BYT.BUDGET_YEAR_TYPE_ID(+) WITH READ ONLY

Columns

Name
STEP_NUMBER
"_LA:PREFIX_OPERATOR"
"_LA:BALANCE_TYPE"
GL_ACCOUNT
"_LA:ELEMENT_VALUE_TYPE"
ELEMENT_VALUE
CURRENCY_CODE
"_LA:POSTFIX_OPERATOR"
AMOUNT
PAY_ELEMENT_ID
PAY_ELEMENT_OPTION_ID
ALLOW_MODIFY
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
CONSTRAINT_FORMULA_ID
CONSTRAINT_ID
BUDGET_YEAR_TYPE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE