APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 364: OR group_mark_id in (select a.serial_transaction_temp_id from mtl_transaction_lots_temp a

360: FROM mtl_serial_numbers msn, mtl_material_statuses_tl mms
361: WHERE inventory_item_id = p_item_id
362: AND (group_mark_id IS NULL
363: OR group_mark_id = -1
364: OR group_mark_id in (select a.serial_transaction_temp_id from mtl_transaction_lots_temp a
365: where a.transaction_temp_id = p_group_mark_id)
366: OR group_mark_id = p_group_mark_id
367: )
368: AND (line_mark_id IS NULL

Line 370: OR line_mark_id in (select a.serial_transaction_temp_id from mtl_transaction_lots_temp a

366: OR group_mark_id = p_group_mark_id
367: )
368: AND (line_mark_id IS NULL
369: OR line_mark_id = -1
370: OR line_mark_id in (select a.serial_transaction_temp_id from mtl_transaction_lots_temp a
371: where a.transaction_temp_id = p_group_mark_id)
372: OR line_mark_id = p_group_mark_id)
373: AND current_organization_id = p_organization_id
374: AND current_status = 3

Line 2501: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, mtl_material_statuses_tl mms

2497: , msn.lot_number
2498: , 0
2499: , msn.current_status
2500: , mms.status_code
2501: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn, mtl_material_statuses_tl mms
2502: WHERE msn.inventory_item_id = p_item_id
2503: AND msn.current_organization_id = p_organization_id
2504: AND msn.current_status = 3
2505: AND msn.current_subinventory_code = p_subinv_code

Line 2771: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2767: , 0
2768: , 0
2769: , ''
2770: , ''
2771: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2772: WHERE mtlt.transaction_temp_id = p_temp_id
2773: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2774: ORDER BY LPAD(fm_serial_number, 20);
2775: END IF;

Line 2879: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

2875: FROM mtl_material_transactions_temp
2876: WHERE move_order_line_id = p_move_order_line_id
2877: UNION
2878: SELECT mtlt.serial_transaction_temp_id
2879: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
2880: WHERE move_order_line_id = p_move_order_line_id
2881: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
2882: AND mtlt.serial_transaction_temp_id IS NOT NULL)
2883: )