DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 101: -- msc_atp_sd_details_temp

97: --
98: -- dsting 9/17/2002
99: --
100: -- Populate the period record with data from the temp table
101: -- msc_atp_sd_details_temp
102: --
103: -- NOTE: as part of the pegging enhancement this procedure assumes that
104: -- only 1 item's data is in the session specific temp table
105: --

Line 154: FROM msc_atp_sd_details_temp

150: x_atp_period.Identifier2,
151: x_atp_period.Total_Demand_Quantity,
152: x_atp_period.Total_Supply_Quantity,
153: x_atp_period.Period_Quantity
154: FROM msc_atp_sd_details_temp
155: GROUP BY
156: supply_demand_date
157: ,ATP_level
158: -- ,order_line_id

Line 248: FROM msc_atp_sd_details_temp

244: x_atp_period.Identifier2,
245: x_atp_period.Total_Demand_Quantity,
246: x_atp_period.Total_Supply_Quantity,
247: x_atp_period.Period_Quantity
248: FROM msc_atp_sd_details_temp
249: GROUP BY
250: supply_demand_date
251: ,ATP_level
252: ,scenario_id