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_DISTRIBUTIONS_ALL

Line 1037: FROM po_distributions_all pd,

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,
1039: mrp_system_items items,
1040: mrp_form_query list,
1041: mrp_sub_inventories msi

Line 1373: FROM po_distributions_all pd,

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,
1375: mtl_supply ms,
1376: mrp_form_query list,
1377: mrp_sub_inventories msi

Line 1430: FROM po_distributions_all pd,

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,
1431: mrp_system_items items,
1432: mtl_supply ms,
1433: mrp_form_query list,
1434: mrp_sub_inventories msi