DBA Data[Home] [Help]

APPS.INV_MO_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 378: , mtl_material_transactions_temp mmtt

374: , wsh_delivery_details_ob_grp_v wdd
375: , wsh_delivery_assignments wda
376: , mtl_txn_request_lines ml
377: , mtl_txn_request_headers mh
378: , mtl_material_transactions_temp mmtt
379: WHERE wda.delivery_id = wnd.delivery_id
380: AND wda.delivery_detail_id = wdd.delivery_detail_id
381: AND wdd.released_status = 'S'
382: AND wdd.organization_id = p_organization_id

Line 406: FROM mtl_material_transactions_temp mmtt

402: --bug #3796571, forking the code for better performance when filtering parameters are not passed.
403: IF (p_so_number IS NULL AND p_mo_req_num IS NULL) THEN
404: OPEN x_pickslip FOR
405: SELECT UNIQUE pick_slip_number
406: FROM mtl_material_transactions_temp mmtt
407: WHERE mmtt.organization_id = p_organization_id
408: AND mmtt.pick_slip_number LIKE (p_pickslip_num);
409: ELSE
410: OPEN x_pickslip FOR

Line 412: FROM mtl_material_transactions_temp mmtt

408: AND mmtt.pick_slip_number LIKE (p_pickslip_num);
409: ELSE
410: OPEN x_pickslip FOR
411: SELECT UNIQUE pick_slip_number
412: FROM mtl_material_transactions_temp mmtt
413: , mtl_sales_orders mso
414: , mtl_txn_request_headers mh
415: WHERE mmtt.organization_id = p_organization_id
416: AND mmtt.move_order_header_id = mh.header_id