DBA Data[Home] [Help]

APPS.MSC_DEMANTRA_PKG dependencies on MSD_DEM_SCN_ENTRIES_V

Line 382: from msd_dem_scn_entries_v

378: demand_class,
379: decode(organization_id,
380: -1, msc_hub_calendar.get_item_org(-1, inventory_item_id, sr_instance_id),
381: organization_id) owning_org_id
382: from msd_dem_scn_entries_v
383: where scenario_id=p_plan_id
384: ) k1,
385:
386: (select distinct start_date

Line 387: from msd_dem_scn_entries_v

383: where scenario_id=p_plan_id
384: ) k1,
385:
386: (select distinct start_date
387: from msd_dem_scn_entries_v
388: where scenario_id=p_plan_id) k2
389: ) k,
390: msd_dem_scn_entries_v f
391: where k.scenario_id = f.scenario_id(+)

Line 390: msd_dem_scn_entries_v f

386: (select distinct start_date
387: from msd_dem_scn_entries_v
388: where scenario_id=p_plan_id) k2
389: ) k,
390: msd_dem_scn_entries_v f
391: where k.scenario_id = f.scenario_id(+)
392: and k.sr_instance_id = f.sr_instance_id(+)
393: and k.organization_id = f.organization_id(+)
394: and k.customer_id = f.customer_id(+)