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_SECONDARY_INVENTORIES

Line 1146: FROM mtl_secondary_inventories msub,

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,
1148: mtl_supply ms,
1149: mrp_form_query list,
1150: mrp_sub_inventories msi

Line 1223: ( exists (SELECT NULL from mtl_secondary_inventories

1219: AND pd.requisition_line_id = prl.requisition_line_id
1220: AND prl.requisition_line_id = ms.req_line_id
1221: AND ms.to_org_primary_quantity > 0
1222: AND (prl.destination_subinventory is NULL OR
1223: ( exists (SELECT NULL from mtl_secondary_inventories
1224: where organization_id = prl.destination_organization_id AND
1225: secondary_inventory_name = prl.destination_subinventory AND
1226: nvl(availability_type,2) = SYS_YES)))
1227: AND ms.destination_type_code = 'INVENTORY'

Line 1319: FROM mtl_secondary_inventories msub,

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,
1321: mtl_supply ms,
1322: mrp_form_query list,
1323: mrp_sub_inventories msi

Line 1539: FROM mtl_secondary_inventories msub,

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,
1540: mrp_system_items items,
1541: mtl_supply ms,
1542: mrp_form_query list,
1543: mrp_sub_inventories msi