APPS.INV_MO_PURGE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 156: FROM mtl_material_transactions_temp mmtt

152: WHERE oola.line_id = mo_line.txn_source_line_id
153: AND (NVL(open_flag,'Y') ='Y' and cancelled_flag='N')
154: AND NOT EXISTS (
155: SELECT 1
156: FROM mtl_material_transactions_temp mmtt
157: WHERE mmtt.move_order_line_id = mo_line.line_id)
158: AND NOT EXISTS (
159: SELECT 1
160: FROM wsh_delivery_details wdd

Line 235: FROM mtl_material_transactions_temp mmtt

231: and order_line is not open (OE_ORDER_LINES_ALL.OPEN_FLAG <> 'Y') */
232: BEGIN
233: SELECT 1
234: INTO can_delete
235: FROM mtl_material_transactions_temp mmtt
236: WHERE mmtt.move_order_line_id = mo_line.line_id
237: AND ROWNUM < 2;
238:
239: can_delete := 0;

Line 366: FROM mtl_material_transactions_temp mmtt

362: --Delete MTRL if allocations doesn't exist for this MO line
363: BEGIN
364: SELECT 1
365: INTO can_delete
366: FROM mtl_material_transactions_temp mmtt
367: WHERE mmtt.move_order_line_id = mo_line.line_id
368: AND ROWNUM < 2;
369:
370: can_delete := 0;