0 Replies Latest reply: Feb 4, 2010 5:10 AM by 749712 RSS

    Form personalization

    749712
      HI I am Using below query in Forms prsonalization. But its giving error (FRM 41076) while applying.please help


      Query works if i remove decode. (i.e last condition)

      SELECT Et.Expenditure_type, Et.Unit_of_measure Uom, Et.Cost_rate_flag,
      Et.Description, Et.System_linkage_function System_linkage_function,
      Et.System_linkage_m
      FROM Pa_expenditure_types_expend_v Et, Pa_expenditure_types_desc_v Dt
      WHERE Et.Expenditure_type = Dt.Expenditure_type
      AND :Exp_items.Expenditure_item_date
      BETWEEN Et.Expnd_typ_start_date_active
      AND NVL (
      Et.Expnd_typ_end_date_active,
      :Exp_items.Expenditure_item_date
      )
      AND :Exp_items.Expenditure_item_date
      BETWEEN Et.Sys_link_start_date_active
      AND NVL (
      Et.Sys_link_end_date_active,
      :Exp_items.Expenditure_item_date
      )
      AND ( Et.System_linkage_function = :GROUPS.System_linkage_function
      OR ( :GROUPS.System_linkage_function = 'ST'
      AND Et.System_linkage_function = 'OT'
      )
      )
      AND ( NVL (
      :Expenditures.Denom_currency_code,
      :Expenditures.Acct_currency_code
      ) = :Expenditures.Acct_currency_code
      OR ( :Expenditures.Denom_currency_code !=
      :Expenditures.Acct_currency_code
      AND Et.Cost_rate_flag = 'N'
      )
      )
      AND 'Y' = DECODE (
      (SELECT DISTINCT Fdfcuv.Application_column_name
      FROM Hr_operating_units Hou,
      Pa_lookups Pl,
      Fnd_descr_flex_col_usage_vl Fdfcuv
      WHERE Pl.Meaning = Hou.NAME
      AND Fdfcuv.End_user_column_name =
      Pl.Predefined_flag
      AND Pl.Lookup_type =
      'PFC_OU_TO_DIVISION_LOOKUP'
      AND Hou.NAME = :GROUPS.Operating_unit
      AND Fdfcuv.Descriptive_flexfield_name =
      'PA_EXPENDITURE_TYPES_DESC_FLEX'),
      'ATTRIBUTE1', Dt.Attribute1,
      'ATTRIBUTE2', Dt.Attribute2,
      'ATTRIBUTE3', Dt.Attribute3,
      'ATTRIBUTE4', Dt.Attribute4
      )
      ORDER BY Et.Expenditure_type

      Edited by: Neer on Feb 4, 2010 12:05 AM

      Edited by: Neer on Feb 4, 2010 3:10 AM