APPS.INV_CYC_SERIALS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 61: mtl_material_transactions_temp mmtt

57: AND NVL(mcce.export_flag, 2) = 2
58: -- added for bug 13691739 starts
59: AND NOT EXISTS (SELECT 1
60: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
61: mtl_material_transactions_temp mmtt
62: WHERE mmtt.inventory_item_id = p_inventory_item_id
63: AND mmtt.organization_id = p_organization_id
64: AND mmtt.wms_task_status = 4
65: AND mmtt.wms_task_type <> 2

Line 120: mtl_material_transactions_temp mmtt

116: AND NVL ( mcce.number_of_counts , 0 ) = NVL ( mcsn.number_of_counts , 0 ) -- Bug 4533713
117: -- added for bug 13691739 starts
118: AND NOT EXISTS (SELECT 1
119: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
120: mtl_material_transactions_temp mmtt
121: WHERE mmtt.inventory_item_id = p_inventory_item_id
122: AND mmtt.organization_id = p_organization_id
123: AND mmtt.wms_task_status = 4
124: AND mmtt.wms_task_type <> 2

Line 174: mtl_material_transactions_temp mmtt

170: AND NVL(mcce.export_flag, 2) = 2
171: -- added for bug 13691739 starts
172: AND NOT EXISTS (SELECT 1
173: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
174: mtl_material_transactions_temp mmtt
175: WHERE mmtt.inventory_item_id = p_inventory_item_id
176: AND mmtt.organization_id = p_organization_id
177: AND mmtt.wms_task_status = 4
178: AND mmtt.wms_task_type <> 2

Line 242: mtl_material_transactions_temp mmtt

238: AND NVL(mcce.export_flag, 2) = 2
239: -- added for bug 13691739 starts
240: AND NOT EXISTS (SELECT 1
241: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
242: mtl_material_transactions_temp mmtt
243: WHERE mmtt.inventory_item_id = p_inventory_item_id
244: AND mmtt.organization_id = p_organization_id
245: AND mmtt.wms_task_status = 4
246: AND mmtt.wms_task_type <> 2

Line 329: mtl_material_transactions_temp mmtt

325: AND NVL(mcce.export_flag, 2) = 2
326: -- added for bug 13691739 starts
327: AND NOT EXISTS (SELECT 1
328: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
329: mtl_material_transactions_temp mmtt
330: WHERE mmtt.inventory_item_id = p_inventory_item_id
331: AND mmtt.organization_id = p_organization_id
332: AND mmtt.wms_task_status = 4
333: AND mmtt.wms_task_type <> 2

Line 401: mtl_material_transactions_temp mmtt

397: AND NVL(mcce.export_flag, 2) = 2
398: -- added for bug 13691739 starts
399: AND NOT EXISTS (SELECT 1
400: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
401: mtl_material_transactions_temp mmtt
402: WHERE mmtt.inventory_item_id = p_inventory_item_id
403: AND mmtt.organization_id = p_organization_id
404: AND mmtt.wms_task_status = 4
405: AND mmtt.wms_task_type <> 2

Line 466: mtl_material_transactions_temp mmtt

462: AND mcce.entry_status_code IN (1, 3)
463: AND NVL(mcce.export_flag, 2) = 2
464: AND NOT EXISTS (SELECT 1
465: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
466: mtl_material_transactions_temp mmtt
467: WHERE mmtt.inventory_item_id = p_inventory_item_id
468: AND mmtt.organization_id = p_organization_id
469: AND mmtt.wms_task_status = 4
470: AND mmtt.wms_task_type <> 2

Line 519: mtl_material_transactions_temp mmtt

515: AND NVL(mcce.export_flag, 2) = 2
516: -- added for bug 13691739 starts
517: AND NOT EXISTS (SELECT 1
518: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
519: mtl_material_transactions_temp mmtt
520: WHERE mmtt.inventory_item_id = p_inventory_item_id
521: AND mmtt.organization_id = p_organization_id
522: AND mmtt.wms_task_status = 4
523: AND mmtt.wms_task_type <> 2