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 PO_REQ_DISTRIBUTIONS_ALL

Line 1094: FROM po_req_distributions_all pd,

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
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,

Line 1203: po_req_distributions_all pd,

1199: prl.quantity) new_quantity,
1200: SUM(nvl(ms.to_org_primary_quantity,0) * pd.req_line_quantity/
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

Line 1266: po_req_distributions_all pd,

1262: pl.quantity) new_quantity,
1263: SUM(nvl(ms.TO_ORG_PRIMARY_QUANTITY, 0) * pd.req_line_quantity /
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

Line 1486: FROM po_req_distributions_all pd,

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,
1487: po_requisition_lines_all pl,
1488: mrp_system_items items,
1489: mtl_supply ms,
1490: mrp_form_query list,

Line 1595: po_req_distributions_all pd,

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,
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