Demantra Solutions - EBS (MOSC)

MOSC Banner

Demantra 7.3.1.- How does table engine_branch_list gets populated?

edited Apr 23, 2014 12:00PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered
In Demantra 7.3.1, How does table Engine_branch_list gets populated.
I checked the procedure  insert_unit and dyn_insert_unit_branch_id

Its using following query

SELECT s.item_id                    item_id,
                        s.location_id                location_id,
                        MAX(sales_date)              sales_date,
                       
                        MIN(m.is_fictive)            is_fictive ,
                        SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-06-2011 00:00:00') THEN 1
ELSE 0 END) sales_in_old_fore,
                        SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-18-2012 00:00:00') THEN 1
ELSE 0 END) sales_in_new_fore
                       
                 FROM   sales_data s, mdp_matrix m,  engine_branch_list e

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center