DBA Data[Home] [Help]

APPS.INV_MO_LOVS dependencies on MTL_SALES_ORDERS

Line 189: , mtl_sales_orders mso

185: , MAX(h.move_order_type)
186: , DECODE(COUNT(l.line_number), 1, MAX(l.line_number), NULL)
187: , DECODE(COUNT(l.line_id), 1, MAX(l.line_id), NULL)
188: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
189: , mtl_sales_orders mso
190: WHERE mso.sales_order_id = l.txn_source_id
191: AND (p_so_number IS NULL OR mso.segment1 = p_so_number)
192: AND h.organization_id = p_organization_id
193: AND h.request_number LIKE (p_mo_req_number)

Line 413: , mtl_sales_orders mso

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
417: AND mso.sales_order_id = mmtt.transaction_source_id