This discussion is archived
0 Replies Latest reply: Feb 4, 2010 3:10 AM by 749712 RSS

Form personalization

749712 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points