APPS.MSD_DEM_SOP dependencies on STANDARD

Line 3608: avg(msi.standard_cost) StandardCost,

3604: group by tei.item
3605: union all
3606: select
3607: (Select Bucket_date from msd_dem_day_dates where day_date=trunc(sysdate)),tei.item item_name,
3608: avg(msi.standard_cost) StandardCost,
3609: avg(mis.item_price) ItemPrice,
3610: avg(mia.repair_cost) RepairCost,null
3611: from
3612: ' || var_schema || '.t_ep_organization teo,

Line 3635: and (msi.standard_cost IS NOT NULL OR mis.item_price IS NOT NULL OR mia.repair_cost IS NOT NULL )

3631: and mia.plan_id(+) = msi.plan_id
3632: and mia.sr_instance_id(+) = msi.sr_instance_id
3633: and mia.organization_id(+) = msi.organization_id
3634: and mia.inventory_item_id(+) = msi.inventory_item_id
3635: and (msi.standard_cost IS NOT NULL OR mis.item_price IS NOT NULL OR mia.repair_cost IS NOT NULL )
3636: group by tei.item';
3637:
3638: msd_dem_common_utilities.log_debug ('The query to be executed is -' || sql_statement);
3639: msd_dem_common_utilities.log_debug ('Executing the query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));