DBA Data[Home] [Help]

APPS.INV_MINMAX_HELPER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

      SELECT SUM(primary_quantity)
	INTO l_shipped_qty
	FROM mtl_material_transactions
       WHERE transaction_action_id = 1
	 AND source_line_id = p_order_line_id
	 AND organization_id = p_organization_id
	 AND inventory_item_id = p_inventory_item_id;