APPS.FLM_SUPPLY_DEMAND dependencies on MTL_DEMAND_INTERFACE

Line 1094: FROM MTL_DEMAND_INTERFACE MDI1

1090: AND P.CALENDAR_CODE = C1.CALENDAR_CODE
1091: AND P.CALENDAR_EXCEPTION_SET_ID = C1.EXCEPTION_SET_ID
1092: AND C.CALENDAR_DATE = TRUNC(O.DATE_REQUIRED)
1093: AND NOT EXISTS (SELECT 'exists in group?'
1094: FROM MTL_DEMAND_INTERFACE MDI1
1095: WHERE MDI1.ATP_GROUP_ID = P_GROUP_ID
1096: AND MDI1.ORGANIZATION_ID + 0 = V.ORGANIZATION_ID
1097: AND MDI1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1098: AND NVL(MDI1.SUPPLY_HEADER_ID, -1) = D.WIP_ENTITY_ID);

Line 1199: FROM MTL_DEMAND_INTERFACE MDI1

1195: 2, I.CUM_MANUFACTURING_LEAD_TIME,
1196: 3, I.PREPROCESSING_LEAD_TIME+I.FULL_LEAD_TIME+I.POSTPROCESSING_LEAD_TIME,
1197: 4, R.INFINITE_SUPPLY_TIME_FENCE)), C.PRIOR_SEQ_NUM+1)
1198: AND NOT EXISTS (SELECT 'exists in group?'
1199: FROM MTL_DEMAND_INTERFACE MDI1
1200: WHERE MDI1.ATP_GROUP_ID = P_GROUP_ID
1201: AND MDI1.ORGANIZATION_ID = V.ORGANIZATION_ID
1202: AND MDI1.INVENTORY_ITEM_ID = V.INVENTORY_ITEM_ID
1203: AND NVL(MDI1.SUPPLY_HEADER_ID, -1) = WRS.WIP_ENTITY_ID);

Line 1383: FROM MTL_DEMAND_INTERFACE MDI1

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

Line 1544: MTL_DEMAND_INTERFACE G, /* use the table directly - perf bug 4899603 */

1540: FROM BOM_CALENDAR_DATES C ,
1541: OE_ORDER_LINES L,
1542: MTL_ATP_RULES R ,
1543: /* MTL_GROUP_ATPS_VIEW G , */
1544: MTL_DEMAND_INTERFACE G, /* use the table directly - perf bug 4899603 */
1545: MTL_PARAMETERS P ,
1546: MTL_SYSTEM_ITEMS I
1547: WHERE I.ATP_FLAG in ('C', 'Y')
1548: AND P.ORGANIZATION_ID = I.ORGANIZATION_ID