APPS.MSC_AATP_REQ dependencies on MSC_ALLOC_TEMP

Line 1131: INSERT INTO msc_alloc_temp(demand_class)

1127:
1128: -- Insert these demand classes in Global Temp Table to use in SELECT clause.
1129:
1130: FORALL i IN l_demand_class_tab.FIRST..l_demand_class_tab.COUNT
1131: INSERT INTO msc_alloc_temp(demand_class)
1132: VALUES (l_demand_class_tab(i));
1133:
1134: -- for performance, we dont support the s/d details for forward Scheduling in case of allocated ATP if
1135: -- forward stealing needs to be supported.

Line 1178: FROM msc_alloc_temp

1174: AND S.INVENTORY_ITEM_ID = l_inv_item_id
1175: AND S.ORGANIZATION_ID = p_organization_id
1176: AND S.DEMAND_CLASS IN (
1177: SELECT demand_class
1178: FROM msc_alloc_temp
1179: WHERE demand_class IS NOT NULL)
1180: AND S.SD_DATE < l_infinite_time_fence_date
1181:
1182: UNION ALL

Line 1197: FROM msc_alloc_temp

1193: AND AD.INVENTORY_ITEM_ID = l_inv_item_id
1194: AND AD.ORGANIZATION_ID = p_organization_id
1195: AND AD.DEMAND_CLASS IN (
1196: SELECT demand_class
1197: FROM msc_alloc_temp
1198: WHERE demand_class IS NOT NULL)
1199: --bug3693892 added trunc
1200: AND trunc(AD.DEMAND_DATE) < l_infinite_time_fence_date
1201: AND P.PLAN_ID = AD.PLAN_ID

Line 1220: FROM msc_alloc_temp

1216: AND SA.INVENTORY_ITEM_ID = l_inv_item_id
1217: AND SA.ORGANIZATION_ID = p_organization_id
1218: AND SA.DEMAND_CLASS IN (
1219: SELECT demand_class
1220: FROM msc_alloc_temp
1221: WHERE demand_class IS NOT NULL)
1222: --bug3693892 added trunc
1223: AND trunc(SA.SUPPLY_DATE) < l_infinite_time_fence_date
1224: AND P.PLAN_ID = SA.PLAN_ID

Line 1287: FROM msc_alloc_temp

1283: AND AD.ORGANIZATION_ID = p_organization_id
1284: AND AD.ORIGINATION_TYPE <> 52 -- Ignore copy SO and copy stealing records for summary enhancement
1285: AND AD.DEMAND_CLASS IN (
1286: SELECT demand_class
1287: FROM msc_alloc_temp
1288: WHERE demand_class IS NOT NULL)
1289: --bug3693892 added trunc
1290: AND trunc(AD.DEMAND_DATE) < l_infinite_time_fence_date
1291:

Line 1310: FROM msc_alloc_temp

1306: 28, TRUNC(SYSDATE),
1307: TRUNC(SA.SUPPLY_DATE))
1308: AND SA.DEMAND_CLASS IN (
1309: SELECT demand_class
1310: FROM msc_alloc_temp
1311: WHERE demand_class IS NOT NULL)
1312: --bug3693892 added trunc
1313: AND trunc(SA.SUPPLY_DATE) < l_infinite_time_fence_date
1314: )

Line 1423: INSERT INTO msc_alloc_temp(supply_demand_date)

1419: -- all these dates in another pl/sql table. This is done to make sure we move thru
1420: -- data from various demand classes in correct order of dates as these may be misaligned.
1421:
1422: FORALL i IN l_atp_period_tab.FIRST..l_atp_period_tab.COUNT
1423: INSERT INTO msc_alloc_temp(supply_demand_date)
1424: VALUES (l_atp_period_tab(i));
1425:
1426: SELECT supply_demand_date --sd_date
1427: BULK COLLECT INTO

Line 1432: FROM msc_alloc_temp

1428: l_period_tab
1429: FROM
1430: (
1431: SELECT DISTINCT supply_demand_date --sd_date
1432: FROM msc_alloc_temp
1433: WHERE supply_demand_date IS NOT NULL
1434: --- for substitution we want to consider supplies only within substitution widow
1435: --- filter out dates after substitution window
1436: and supply_demand_date <= l_substitution_end_date

Line 1766: DELETE msc_alloc_temp;

1762: --bug3409973 end
1763: -- Delete data from table, in case we re-visit this table within same transaction
1764: -- as this is a transaction specific global temporary table.
1765:
1766: DELETE msc_alloc_temp;
1767:
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'before setting pegging for : ' || p_item_name);
1770: msc_sch_wb.atp_debug('Get_Forward_Material_Atp: ' || 'x_atf_date_quantity : ' || x_atf_date_quantity);