APPS.WPS_SUPPLY_DEMAND dependencies on MTL_DEMAND

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);

Line 1449: MTL_DEMAND D,

1445: MTL_PARAMETERS P,
1446: MTL_SYSTEM_ITEMS I,
1447: MTL_ATP_RULES R,
1448: BOM_CALENDAR_DATES C,
1449: MTL_DEMAND D,
1450: BOM_CALENDAR_DATES C1
1451: WHERE D.ORGANIZATION_ID = V.ORGANIZATION_ID
1452: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),D.COMPLETED_QUANTITY)
1453: AND D.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID