eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_CALENDAR

Line 1033: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1029: ms.item_id item_id,
1030: ms.to_organization_id org_id,
1031: PO row_type,
1032: PO_OFF offset,
1033: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1034: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1035: SUM(ms.to_org_primary_quantity) new_quantity,
1036: SUM(ms.to_org_primary_quantity) old_quantity
1037: FROM po_distributions_all pd,

Line 1034: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1030: ms.to_organization_id org_id,
1031: PO row_type,
1032: PO_OFF offset,
1033: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1034: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1035: SUM(ms.to_org_primary_quantity) new_quantity,
1036: SUM(ms.to_org_primary_quantity) old_quantity
1037: FROM po_distributions_all pd,
1038: mtl_supply ms,

Line 1078: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1074: ms.item_id,
1075: ms.to_organization_id,
1076: PO,
1077: PO_OFF,
1078: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1079: UNION ALL
1080: ---------------------
1081: -- Intransit Shipment
1082: ----------------------

Line 1088: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1084: ms.item_id item_id,
1085: ms.to_organization_id org_id,
1086: TRANSIT row_type,
1087: TRANSIT_OFF offset,
1088: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1089: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1090: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1091: new_quantity,
1092: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)

Line 1089: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1085: ms.to_organization_id org_id,
1086: TRANSIT row_type,
1087: TRANSIT_OFF offset,
1088: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1089: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1090: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1091: new_quantity,
1092: SUM(nvl(ms.to_org_primary_quantity, 0) * pd.req_line_quantity/pl.quantity)
1093: old_quantity

Line 1135: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1131: GROUP BY ms.item_id,
1132: ms.to_organization_id,
1133: TRANSIT,
1134: TRANSIT_OFF,
1135: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1136: UNION ALL
1137: SELECT
1138: ms.item_id item_id,
1139: ms.to_organization_id org_id,

Line 1142: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1138: ms.item_id item_id,
1139: ms.to_organization_id org_id,
1140: TRANSIT row_type,
1141: TRANSIT_OFF offset,
1142: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1143: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1144: SUM(ms.to_org_primary_quantity)new_quantity,
1145: SUM(ms.to_org_primary_quantity) old_quantity
1146: FROM mtl_secondary_inventories msub,

Line 1143: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1139: ms.to_organization_id org_id,
1140: TRANSIT row_type,
1141: TRANSIT_OFF offset,
1142: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1143: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1144: SUM(ms.to_org_primary_quantity)new_quantity,
1145: SUM(ms.to_org_primary_quantity) old_quantity
1146: FROM mtl_secondary_inventories msub,
1147: mrp_system_items items,

Line 1186: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1182: ms.item_id,
1183: ms.to_organization_id,
1184: TRANSIT,
1185: TRANSIT_OFF,
1186: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1187: UNION ALL
1188: ------------------------
1189: -- Purchase Requisitions
1190: ------------------------

Line 1196: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1192: ms.item_id item_id,
1193: ms.to_organization_id org_id,
1194: REQ row_type,
1195: REQ_OFF offset,
1196: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1197: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1198: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1199: prl.quantity) new_quantity,
1200: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/

Line 1197: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1193: ms.to_organization_id org_id,
1194: REQ row_type,
1195: REQ_OFF offset,
1196: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1197: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1198: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1199: prl.quantity) new_quantity,
1200: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
1201: prl.quantity) old_quantity

Line 1249: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1245: ms.item_id,
1246: ms.to_organization_id,
1247: REQ,
1248: REQ_OFF,
1249: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1250: UNION ALL
1251: ----------------------
1252: -- Intransit Receipts
1253: ----------------------

Line 1259: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1255: ms.item_id item_id,
1256: ms.to_organization_id org_id,
1257: RECEIVING row_type,
1258: RECEIVING_OFF offset,
1259: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1260: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1261: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1262: pl.quantity) new_quantity,
1263: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /

Line 1260: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1256: ms.to_organization_id org_id,
1257: RECEIVING row_type,
1258: RECEIVING_OFF offset,
1259: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1260: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1261: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1262: pl.quantity) new_quantity,
1263: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
1264: pl.quantity) old_quantity

Line 1308: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1304: ms.item_id,
1305: ms.to_organization_id,
1306: RECEIVING,
1307: RECEIVING_OFF,
1308: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1309: UNION ALL
1310: SELECT
1311: ms.item_id item_id,
1312: ms.to_organization_id org_id,

Line 1315: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1311: ms.item_id item_id,
1312: ms.to_organization_id org_id,
1313: RECEIVING row_type,
1314: RECEIVING_OFF offset,
1315: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1316: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1317: SUM(ms.to_org_primary_quantity)new_quantity,
1318: SUM(ms.to_org_primary_quantity) old_quantity
1319: FROM mtl_secondary_inventories msub,

Line 1316: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1312: ms.to_organization_id org_id,
1313: RECEIVING row_type,
1314: RECEIVING_OFF offset,
1315: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1316: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1317: SUM(ms.to_org_primary_quantity)new_quantity,
1318: SUM(ms.to_org_primary_quantity) old_quantity
1319: FROM mtl_secondary_inventories msub,
1320: mrp_system_items items,

Line 1359: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1355: ms.item_id,
1356: ms.to_organization_id,
1357: RECEIVING,
1358: RECEIVING_OFF,
1359: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1360: UNION ALL
1361: -------------------
1362: -- PO in Receiving
1363: -------------------

Line 1369: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1365: ms.item_id item_id,
1366: ms.to_organization_id org_id,
1367: RECEIVING row_type,
1368: RECEIVING_OFF offset,
1369: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1370: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1371: SUM(ms.to_org_primary_quantity) new_quantity,
1372: SUM(ms.to_org_primary_quantity) old_quantity
1373: FROM po_distributions_all pd,

Line 1370: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1366: ms.to_organization_id org_id,
1367: RECEIVING row_type,
1368: RECEIVING_OFF offset,
1369: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1370: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1371: SUM(ms.to_org_primary_quantity) new_quantity,
1372: SUM(ms.to_org_primary_quantity) old_quantity
1373: FROM po_distributions_all pd,
1374: mrp_system_items items,

Line 1412: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1408: ms.item_id,
1409: ms.to_organization_id,
1410: RECEIVING,
1411: RECEIVING_OFF,
1412: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1413: UNION ALL
1414: -------------------
1415: --- PO SUPPLY Scrap
1416: -------------------

Line 1425: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1421: ms.item_id item_id,
1422: ms.to_organization_id org_id,
1423: SCRAP row_type,
1424: SCRAP_OFF offset,
1425: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1426: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1427: SUM(ms.to_org_primary_quantity * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1428: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1429: 0 old_quantity

Line 1426: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1422: ms.to_organization_id org_id,
1423: SCRAP row_type,
1424: SCRAP_OFF offset,
1425: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1426: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1427: SUM(ms.to_org_primary_quantity * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1428: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1429: 0 old_quantity
1430: FROM po_distributions_all pd,

Line 1471: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1467: ms.item_id,
1468: ms.to_organization_id,
1469: SCRAP,
1470: SCRAP_OFF,
1471: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1472: UNION ALL
1473: ---------------------------
1474: -- Intransit Shipment Scrap
1475: ---------------------------

Line 1481: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1477: ms.item_id item_id,
1478: ms.to_organization_id org_id,
1479: SCRAP row_type,
1480: SCRAP_OFF offset,
1481: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1482: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1483: SUM((nvl(ms.to_org_primary_quantity,0)* pd.req_line_quantity/pl.quantity) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1484: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1485: 0 old_quantity

Line 1482: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1478: ms.to_organization_id org_id,
1479: SCRAP row_type,
1480: SCRAP_OFF offset,
1481: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1482: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1483: SUM((nvl(ms.to_org_primary_quantity,0)* pd.req_line_quantity/pl.quantity) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1484: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1485: 0 old_quantity
1486: FROM po_req_distributions_all pd,

Line 1527: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1523: GROUP BY ms.item_id,
1524: ms.to_organization_id,
1525: SCRAP,
1526: SCRAP_OFF,
1527: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1528: UNION ALL
1529: SELECT
1530: ms.item_id item_id,
1531: ms.to_organization_id org_id,

Line 1534: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1530: ms.item_id item_id,
1531: ms.to_organization_id org_id,
1532: SCRAP row_type,
1533: SCRAP_OFF offset,
1534: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1535: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1536: SUM(nvl(ms.to_org_primary_quantity,0) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1537: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1538: 0 old_quantity

Line 1535: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1531: ms.to_organization_id org_id,
1532: SCRAP row_type,
1533: SCRAP_OFF offset,
1534: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1535: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1536: SUM(nvl(ms.to_org_primary_quantity,0) * DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1537: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1538: 0 old_quantity
1539: FROM mtl_secondary_inventories msub,

Line 1579: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1575: ms.item_id,
1576: ms.to_organization_id,
1577: SCRAP,
1578: SCRAP_OFF,
1579: mrp_calendar.date_offset(items.organization_id,1,ms.receipt_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1580: UNION ALL
1581: -------------------------------
1582: -- Purchase Requisitions Scrap
1583: -------------------------------

Line 1589: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,

1585: ms.item_id item_id,
1586: ms.to_organization_id org_id,
1587: SCRAP row_type,
1588: SCRAP_OFF offset,
1589: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1590: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1591: SUM(nvl(ms.to_org_primary_quantity,0) *DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1592: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1593: 0 old_quantity

Line 1590: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,

1586: ms.to_organization_id org_id,
1587: SCRAP row_type,
1588: SCRAP_OFF offset,
1589: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) new_date,
1590: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME)) old_date,
1591: SUM(nvl(ms.to_org_primary_quantity,0) *DECODE(SIGN(ITEMS.SHRINKAGE_RATE),
1592: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1593: 0 old_quantity
1594: FROM mrp_system_items items,

Line 1635: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))

1631: ms.item_id,
1632: ms.to_organization_id,
1633: SCRAP,
1634: SCRAP_OFF,
1635: mrp_calendar.date_offset(items.organization_id,1,ms.need_by_date, CEIL(items.POSTPROCESSING_LEAD_TIME))
1636:
1637: UNION ALL
1638: ---------------------------------------------
1639: --- Planned order, Model /* Modified in 1402080 */