VIEW: APPS.PQH_BDGT_CMMTMNT_ELMNTS_V

Source

View Text - Preformatted

SELECT bce.bdgt_cmmtmnt_elmnt_id, bgt.budget_name, bce.budget_id, pet.element_name, bce.element_type_id, bce.salary_basis_flag, piv1.name element_input_value, bce.element_input_value_id, piv2.name frequency_input_value, bce.frequency_input_value_id, fml.formula_name, bce.formula_id, bce.dflt_elmnt_frequency, bce.overhead_percentage, bce.created_by, bce.creation_date, bce.last_updated_by, bce.last_update_date, bce.last_update_login, bce.object_version_number, bce.actual_commitment_type, hl.meaning actual_commitment_type_desc, bal.balance_type_id, bal.balance_name FROM pqh_bdgt_cmmtmnt_elmnts bce, pqh_budgets bgt, pay_element_types_v pet, pay_input_values_v piv1, pay_input_values_v piv2, ff_formulas_f_v fml, pay_balance_types bal,hr_lookups hl WHERE bce.budget_id = bgt.budget_id AND bce.element_type_id = pet.element_type_id(+) AND bce.element_input_value_id = piv1.input_value_id(+) AND bce.frequency_input_value_id = piv2.input_value_id(+) AND bce.formula_id = fml.formula_id(+) AND hl.lookup_type = 'PQH_BDGT_CALC_TYPE' AND bce.actual_commitment_type = hl.lookup_code(+) AND bce.balance_type_id = bal.balance_type_id(+)

View Text - HTML Formatted

SELECT BCE.BDGT_CMMTMNT_ELMNT_ID
, BGT.BUDGET_NAME
, BCE.BUDGET_ID
, PET.ELEMENT_NAME
, BCE.ELEMENT_TYPE_ID
, BCE.SALARY_BASIS_FLAG
, PIV1.NAME ELEMENT_INPUT_VALUE
, BCE.ELEMENT_INPUT_VALUE_ID
, PIV2.NAME FREQUENCY_INPUT_VALUE
, BCE.FREQUENCY_INPUT_VALUE_ID
, FML.FORMULA_NAME
, BCE.FORMULA_ID
, BCE.DFLT_ELMNT_FREQUENCY
, BCE.OVERHEAD_PERCENTAGE
, BCE.CREATED_BY
, BCE.CREATION_DATE
, BCE.LAST_UPDATED_BY
, BCE.LAST_UPDATE_DATE
, BCE.LAST_UPDATE_LOGIN
, BCE.OBJECT_VERSION_NUMBER
, BCE.ACTUAL_COMMITMENT_TYPE
, HL.MEANING ACTUAL_COMMITMENT_TYPE_DESC
, BAL.BALANCE_TYPE_ID
, BAL.BALANCE_NAME
FROM PQH_BDGT_CMMTMNT_ELMNTS BCE
, PQH_BUDGETS BGT
, PAY_ELEMENT_TYPES_V PET
, PAY_INPUT_VALUES_V PIV1
, PAY_INPUT_VALUES_V PIV2
, FF_FORMULAS_F_V FML
, PAY_BALANCE_TYPES BAL
, HR_LOOKUPS HL
WHERE BCE.BUDGET_ID = BGT.BUDGET_ID
AND BCE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID(+)
AND BCE.ELEMENT_INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID(+)
AND BCE.FREQUENCY_INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID(+)
AND BCE.FORMULA_ID = FML.FORMULA_ID(+)
AND HL.LOOKUP_TYPE = 'PQH_BDGT_CALC_TYPE'
AND BCE.ACTUAL_COMMITMENT_TYPE = HL.LOOKUP_CODE(+)
AND BCE.BALANCE_TYPE_ID = BAL.BALANCE_TYPE_ID(+)