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.WMS_OPP_CYC_COUNT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 144: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

140: BEGIN
141:
142: SELECT Count(DISTINCT msn.serial_number)
143: INTO l_loaded_sys_qty
144: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
145: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
146: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
147: mtlt.lot_number is null) or
148: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 652: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

648: BEGIN
649:
650: SELECT Count(DISTINCT msn.serial_number)
651: INTO l_loaded_sys_qty
652: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
653: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
654: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id and
655: mtlt.lot_number is null) or
656: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 908: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

904: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
905:
906: SELECT Count(DISTINCT msn.serial_number)
907: INTO l_loaded_sys_qty
908: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
909: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
910: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
911: mtlt.lot_number is null) OR
912: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1113: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_transaction_lots_temp mtlt

1109:
1110: BEGIN
1111: SELECT NVL ( SUM ( Nvl(mtlt.primary_quantity, mmtt.primary_quantity) ), 0 )
1112: INTO l_allocated_pri_qty
1113: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_transaction_lots_temp mtlt
1114: WHERE mmtt.inventory_item_id = p_inventory_item_id
1115: AND mmtt.organization_id = p_organization_id
1116: AND (p_parent_lpn_id IS NULL OR NVL ( mmtt.allocated_lpn_id, NVL ( mmtt.lpn_id, NVL ( mmtt.content_lpn_id, -1 ) ) ) = p_parent_lpn_id)
1117: AND mmtt.subinventory_code = p_subinventory

Line 1128: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_transaction_lots_temp mtlt

1124:
1125:
1126: OPEN x_alloc_cur FOR
1127: SELECT mmtt.TRANSACTION_TEMP_ID, Nvl(Nvl(mtlt.primary_quantity, mmtt.primary_quantity), 0) primary_quantity, Nvl(mmtt.TASK_PRIORITY,0)
1128: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_transaction_lots_temp mtlt
1129: WHERE mmtt.inventory_item_id = p_inventory_item_id
1130: AND mmtt.organization_id = p_organization_id
1131: AND (p_parent_lpn_id IS NULL OR NVL ( mmtt.allocated_lpn_id, NVL ( mmtt.lpn_id, NVL ( mmtt.content_lpn_id, -1 ) ) ) = p_parent_lpn_id)
1132: AND mmtt.subinventory_code = p_subinventory

Line 1159: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1155: l_progress := '60';
1156:
1157: SELECT Count(DISTINCT msn.serial_number)
1158: INTO l_allocated_pri_qty
1159: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1160: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1161: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1162: mtlt.lot_number IS NULL) OR
1163: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1184: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1180:
1181:
1182: OPEN x_alloc_cur FOR
1183: SELECT DISTINCT mmtt.TRANSACTION_TEMP_ID, Count(DISTINCT msn.serial_number) primary_quantity, Nvl(mmtt.TASK_PRIORITY,0)
1184: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1185: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1186: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1187: mtlt.lot_number is null) OR
1188: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1278: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1274: l_progress := '10';
1275:
1276: SELECT Count(DISTINCT msn.serial_number)
1277: INTO l_allocated_pri_qty
1278: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1279: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1280: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1281: mtlt.lot_number is null) OR
1282: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1297: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt

1293:
1294:
1295: OPEN x_det_alloc_cur FOR
1296: SELECT DISTINCT mmtt.TRANSACTION_TEMP_ID, Count(DISTINCT msn.serial_number) primary_quantity, Nvl(mmtt.TASK_PRIORITY,0)
1297: FROM mtl_serial_numbers_temp msnt, mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, wms_dispatched_tasks wdt
1298: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id (+)
1299: AND ((msnt.transaction_temp_id = mmtt.transaction_temp_id AND
1300: mtlt.lot_number is null) OR
1301: (msnt.transaction_temp_id = mtlt.serial_transaction_temp_id