VIEW: APPS.PSBFV_CONSTRAINT_FORMULAS

Source

View Text - Preformatted

SELECT pe.NAME, cf.STEP_NUMBER, '_LA:cf.prefix_operator:FND_LOOKUPS:PSB_CONSTRAINT_PREFIX_OPERATOR:meaning', byt.NAME, '_LA:cf.balance_type:FND_LOOKUPS:PSB_BALANCE_TYPE:meaning', cf.CONCATENATED_SEGMENTS, pe.NAME, peo.NAME, '_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.ALLOW_MODIFY, '_DF:PSB:PSB_CONSTRAINT_FORMULAS:cf', cf.EFFECTIVE_START_DATE, cf.EFFECTIVE_END_DATE, cf.CONSTRAINT_FORMULA_ID, cf.CONSTRAINT_ID, cf.BUDGET_YEAR_TYPE_ID, cf.PAY_ELEMENT_ID, cf.PAY_ELEMENT_OPTION_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, psb_pay_elements ppe, psb_pay_element_options peo WHERE cf.constraint_id = pe.entity_id AND cf.budget_year_type_id = byt.budget_year_type_id(+) AND ppe.pay_element_id(+) = cf.pay_element_id AND peo.pay_element_option_id(+) = cf.pay_element_option_id WITH READ ONLY

View Text - HTML Formatted

SELECT PE.NAME
, CF.STEP_NUMBER
, '_LA:CF.PREFIX_OPERATOR:FND_LOOKUPS:PSB_CONSTRAINT_PREFIX_OPERATOR:MEANING'
, BYT.NAME
, '_LA:CF.BALANCE_TYPE:FND_LOOKUPS:PSB_BALANCE_TYPE:MEANING'
, CF.CONCATENATED_SEGMENTS
, PE.NAME
, PEO.NAME
, '_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.ALLOW_MODIFY
, '_DF:PSB:PSB_CONSTRAINT_FORMULAS:CF'
, CF.EFFECTIVE_START_DATE
, CF.EFFECTIVE_END_DATE
, CF.CONSTRAINT_FORMULA_ID
, CF.CONSTRAINT_ID
, CF.BUDGET_YEAR_TYPE_ID
, CF.PAY_ELEMENT_ID
, CF.PAY_ELEMENT_OPTION_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
, PSB_PAY_ELEMENTS PPE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE CF.CONSTRAINT_ID = PE.ENTITY_ID
AND CF.BUDGET_YEAR_TYPE_ID = BYT.BUDGET_YEAR_TYPE_ID(+)
AND PPE.PAY_ELEMENT_ID(+) = CF.PAY_ELEMENT_ID
AND PEO.PAY_ELEMENT_OPTION_ID(+) = CF.PAY_ELEMENT_OPTION_ID WITH READ ONLY