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 MTL_SUPPLY

Line 1038: mtl_supply ms,

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,
1039: mrp_system_items items,
1040: mrp_form_query list,
1041: mrp_sub_inventories msi
1042: WHERE (arg_res_level = 1

Line 1097: mtl_supply ms,

1093: old_quantity
1094: FROM po_req_distributions_all pd,
1095: po_requisition_lines_all pl,
1096: mrp_system_items items,
1097: mtl_supply ms,
1098: mrp_form_query list,
1099: mrp_sub_inventories msi
1100: WHERE (arg_res_level = 1
1101: OR (arg_res_level = 2

Line 1148: mtl_supply ms,

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,
1148: mtl_supply ms,
1149: mrp_form_query list,
1150: mrp_sub_inventories msi
1151: WHERE (arg_res_level = 1
1152: OR (arg_res_level = 2

Line 1205: mtl_supply ms,

1201: prl.quantity) old_quantity
1202: FROM mrp_system_items items,
1203: po_req_distributions_all pd,
1204: po_requisition_lines_all prl,
1205: mtl_supply ms,
1206: mrp_form_query list,
1207: mrp_sub_inventories msi
1208: WHERE (arg_res_level = 1
1209: OR (arg_res_level = 2

Line 1268: mtl_supply ms,

1264: pl.quantity) old_quantity
1265: FROM po_requisition_lines_all pl,
1266: po_req_distributions_all pd,
1267: mrp_system_items items,
1268: mtl_supply ms,
1269: mrp_form_query list,
1270: mrp_sub_inventories msi
1271: WHERE (arg_res_level = 1
1272: OR (arg_res_level = 2

Line 1321: mtl_supply ms,

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,
1321: mtl_supply ms,
1322: mrp_form_query list,
1323: mrp_sub_inventories msi
1324: WHERE (arg_res_level = 1
1325: OR (arg_res_level = 2

Line 1375: mtl_supply ms,

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,
1375: mtl_supply ms,
1376: mrp_form_query list,
1377: mrp_sub_inventories msi
1378: WHERE (arg_res_level = 1
1379: OR (arg_res_level = 2

Line 1432: mtl_supply ms,

1428: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1429: 0 old_quantity
1430: FROM po_distributions_all pd,
1431: mrp_system_items items,
1432: mtl_supply ms,
1433: mrp_form_query list,
1434: mrp_sub_inventories msi
1435: WHERE (arg_res_level = 1
1436: OR (arg_res_level = 2

Line 1489: mtl_supply ms,

1485: 0 old_quantity
1486: FROM po_req_distributions_all pd,
1487: po_requisition_lines_all pl,
1488: mrp_system_items items,
1489: mtl_supply ms,
1490: mrp_form_query list,
1491: mrp_sub_inventories msi
1492: WHERE (arg_res_level = 1
1493: OR (arg_res_level = 2

Line 1541: mtl_supply ms,

1537: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1538: 0 old_quantity
1539: FROM mtl_secondary_inventories msub,
1540: mrp_system_items items,
1541: mtl_supply ms,
1542: mrp_form_query list,
1543: mrp_sub_inventories msi
1544: WHERE (arg_res_level = 1
1545: OR (arg_res_level = 2

Line 1596: mtl_supply ms,

1592: -1, 0, (NVL(ITEMS.SHRINKAGE_RATE,0)))) new_quantity,
1593: 0 old_quantity
1594: FROM mrp_system_items items,
1595: po_req_distributions_all pd,
1596: mtl_supply ms,
1597: mrp_form_query list,
1598: mrp_sub_inventories msi
1599: WHERE (arg_res_level = 1
1600: OR (arg_res_level = 2