DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_ATP_SD_DETAILS_TEMP

Line 102: -- msc_atp_sd_details_temp

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

Line 155: FROM msc_atp_sd_details_temp

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

Line 249: FROM msc_atp_sd_details_temp

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