Building a list Of Values

Building a list Of Values

1. Create Record Group

Under Record Group tab on Navigator
(Copy from a Previous One)
The sql is located here.


2.Create LOV

Under LOV tab on Navigator
(Copy from a Previous One)
Important –Set Column   Mapping Properties Here

3.Attach LOV to Item

Under item attribute

4.Commit Rule Logic

SELECT ffv.flex_value MEANING ,ffv.flex_value LOOKUP_CODE ,ffv.description
  DESCRIPTION
from
fnd_flex_value_Sets ffvs, fnd_flex_values_vl ffv where
  ffvs.flex_value_set_id=ffv.flex_value_set_id and ffvs.flex_value_set_name=
  'TK_COMMIT_RULE' ORDER BY 1

5.Marketing Status

SELECT ffv.flex_value MEANING ,ffv.flex_value LOOKUP_CODE ,ffv.description
  DESCRIPTION
from
fnd_flex_value_Sets ffvs, fnd_flex_values_vl ffv where
  ffvs.flex_value_set_id=ffv.flex_value_set_id and ffvs.flex_value_set_name=
  'TK_INV_MKTG_STATUS' ORDER BY 1

6.Planner Code

select planner_code, description
from
mtl_planners where nvl(disable_date, sysdate+1) > sysdate and
  organization_id = :1 order by planner_code