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.AHL_PRD_MRSHL_PVT dependencies on MTL_RESERVATIONS

Line 146: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV

142: --ARUNJK modified Exception date and added AOG_FLAG and OBJCET_VERSION_NUMBER for Marshalling
143: DECODE(SIGN(TRUNC(ASML.SCHEDULED_DATE)- TRUNC(ASML.REQUESTED_DATE)), 1, ASML.SCHEDULED_DATE, NULL) EXCEPTION_DATE,
144: ASML.AOG_FLAG,
145: ASML.OBJECT_VERSION_NUMBER ASM_OBJECT_VERSION_NUMBER,
146: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV
147: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
148: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
149: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
150: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY

Line 226: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV

222: --ARUNJK modified Exception date and added AOG_FLAG and OBJCET_VERSION_NUMBER for Marshalling
223: DECODE(SIGN(TRUNC(ASML.SCHEDULED_DATE)- TRUNC(ASML.REQUESTED_DATE)), 1, ASML.SCHEDULED_DATE, NULL) EXCEPTION_DATE,
224: ASML.AOG_FLAG,
225: ASML.OBJECT_VERSION_NUMBER ASM_OBJECT_VERSION_NUMBER,
226: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV
227: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
228: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
229: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
230: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY

Line 573: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV

569: --ARUNJK modified Exception date and added AOG_FLAG and OBJCET_VERSION_NUMBER for Marshalling
570: DECODE(SIGN(TRUNC(ASML.SCHEDULED_DATE)- TRUNC(ASML.REQUESTED_DATE)), 1, ASML.SCHEDULED_DATE, NULL) EXCEPTION_DATE,
571: ASML.AOG_FLAG,
572: ASML.OBJECT_VERSION_NUMBER ASM_OBJECT_VERSION_NUMBER,
573: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV
574: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
575: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
576: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
577: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY

Line 650: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV

646: --ARUNJK modified Exception date and added AOG_FLAG and OBJCET_VERSION_NUMBER for Marshalling
647: DECODE(SIGN(TRUNC(ASML.SCHEDULED_DATE)- TRUNC(ASML.REQUESTED_DATE)), 1, ASML.SCHEDULED_DATE, NULL) EXCEPTION_DATE,
648: ASML.AOG_FLAG,
649: ASML.OBJECT_VERSION_NUMBER ASM_OBJECT_VERSION_NUMBER,
650: (SELECT nvl(SUM(mrv.primary_reservation_quantity),0) FROM mtl_reservations MRV
651: WHERE MRV.INVENTORY_ITEM_ID =WIRO.INVENTORY_ITEM_ID
652: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
653: AND MRV.DEMAND_SOURCE_HEADER_ID = WIRO.WIP_ENTITY_ID
654: AND MRV.DEMAND_SOURCE_LINE_ID =WIRO.OPERATION_SEQ_NUM) RESERVED_QUANTITY