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

If GAC errors out it

If GAC errors out it means one of two things...
 

1. Its an item that has uplift.

        (2 credits per one debit)
This is the rare case.
1,Query tk_gac_interface by transaction_id
2,remove uplift entry
3. Adjust dollars per Kriss Hunts instruction
 
Example Below
 
select transaction_id, base_transaction_value from mtl_transaction_accounts  where transaction_id = 15131018;update  mtl_transaction_accounts set base_transaction_value = -42.66 where transaction_id = 15131018and base_transaction_value = -41.09
 
delete from mtl_transaction_accountswhere transaction_id = 15131018and base_transaction_value = -6.16
 
select segment1 from mtl_system_items m, mtl_material_transactions twhere m.inventory_item_id = t.inventory_item_idand m.organization_id = t.organization_idand t.transaction_id = 15513879
 
 
 
No MTA transactions
 
1. Derive Item Number
 
select segment1 from mtl_system_items m, mtl_material_transactions twhere m.inventory_item_id = t.inventory_item_idand m.organization_id = t.organization_idand t.transaction_id = 15513879
 
2. UPDATE through hammer manager
 
update tk_gac_interface
set interfaced_flag = 'Y'
where transaction_id = 15513879