APPS.WPS_SUPPLY_DEMAND dependencies on MTL_DEMAND_INTERFACE

Line 1100: FROM MTL_DEMAND_INTERFACE MDI1

1096: AND P.CALENDAR_CODE = C1.CALENDAR_CODE
1097: AND P.CALENDAR_EXCEPTION_SET_ID = C1.EXCEPTION_SET_ID
1098: AND C.CALENDAR_DATE = TRUNC(O.DATE_REQUIRED)
1099: AND NOT EXISTS (SELECT 'exists in group?'
1100: FROM MTL_DEMAND_INTERFACE MDI1
1101: WHERE MDI1.ATP_GROUP_ID = P_GROUP_ID
1102: AND MDI1.ORGANIZATION_ID + 0 = V.ORGANIZATION_ID
1103: AND MDI1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1104: AND NVL(MDI1.SUPPLY_HEADER_ID, -1) = D.WIP_ENTITY_ID);

Line 1205: FROM MTL_DEMAND_INTERFACE MDI1

1201: 2, I.CUM_MANUFACTURING_LEAD_TIME,
1202: 3, I.PREPROCESSING_LEAD_TIME+I.FULL_LEAD_TIME+I.POSTPROCESSING_LEAD_TIME,
1203: 4, R.INFINITE_SUPPLY_TIME_FENCE)), C.PRIOR_SEQ_NUM+1)
1204: AND NOT EXISTS (SELECT 'exists in group?'
1205: FROM MTL_DEMAND_INTERFACE MDI1
1206: WHERE MDI1.ATP_GROUP_ID = P_GROUP_ID
1207: AND MDI1.ORGANIZATION_ID = V.ORGANIZATION_ID
1208: AND MDI1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1209: AND NVL(MDI1.SUPPLY_HEADER_ID, -1) = WRS.WIP_ENTITY_ID);

Line 1386: FROM MTL_DEMAND_INTERFACE MDI1

1382: 2, I.CUM_MANUFACTURING_LEAD_TIME,
1383: 3, I.PREPROCESSING_LEAD_TIME+I.FULL_LEAD_TIME+I.POSTPROCESSING_LEAD_TIME,
1384: 4, R.INFINITE_SUPPLY_TIME_FENCE)), C.PRIOR_SEQ_NUM+1)
1385: AND NOT EXISTS (SELECT 'exists in group?'
1386: FROM MTL_DEMAND_INTERFACE MDI1
1387: WHERE MDI1.ATP_GROUP_ID = P_GROUP_ID
1388: AND MDI1.ORGANIZATION_ID + 0 = V.ORGANIZATION_ID
1389: AND MDI1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1390: AND NVL(MDI1.SUPPLY_HEADER_ID, -1) = F.WIP_ENTITY_ID);