DBA Data[Home] [Help]

APPS.MSC_ATP_UTILS dependencies on MTL_SUPPLY_DEMAND_TEMP

Line 1096: INSERT INTO MTL_SUPPLY_DEMAND_TEMP

1092: FOR j IN 1..x_atp_supply_demand.inventory_item_id.COUNT LOOP
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_sd '||j);
1095: END IF;
1096: INSERT INTO MTL_SUPPLY_DEMAND_TEMP
1097: (
1098: RECORD_TYPE,
1099: SUPPLY_DEMAND_SOURCE_TYPE,
1100: ON_HAND_QUANTITY,

Line 1150: INSERT INTO MTL_SUPPLY_DEMAND_TEMP

1146: FOR j IN 1..x_atp_period.inventory_item_id.COUNT LOOP
1147: IF PG_DEBUG in ('Y', 'C') THEN
1148: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp period '||j);
1149: END IF;
1150: INSERT INTO MTL_SUPPLY_DEMAND_TEMP
1151: (
1152: ATP_PERIOD_START_DATE,
1153: ATP_PERIOD_END_DATE,
1154: ATP_PERIOD_TOTAL_SUPPLY,